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)

  • Consider sharing a copy of your sheet.
    – ZygD
    Jan 24 at 5:04
  • Nothing that sheet will tell you that the question did not. The problem doesn't seem all that complex to me. It just doesn't seem to have any option to alter it save for cheating with extra columns for the desired effect. Jan 24 at 6:38


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.