So i have a simple line chart, it plots a value for each entry into the table it is made from. Each only has 2 columns: DateTime, and Value
The value is cumulative, so you expect and upward trending line. The DateTime however, is arbitrary. In the sense that between row 1 and 2, could be 3 days, but between row 4 and 5 count be only 5 seconds.
For some reason, sheets insists on printing the X axis with all the dots equally spaced out, instead of being spaced out over the "time between" the 2 data points.
How do i convince sheets to reconsider? (The columns have been made type DateTime, they are not the default of "i am text" or whatever)