Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
I have a Google Sheet with a some data that I need to chart. The horizontal axis should be a list of dates. When I plot the chart, though, it's inserting dates that aren't part of the data set. For example:
I've been playing with this for a while, and I can't figure out how to get it to use my actual headers as the axis rather than inserting dates that aren't there.
Any help would be greatly appreciated.
If the row you are using for labels contains dates, the spreadsheet supposes that you need an accurate representation of time. So it arranges the data chronologically and marks the time axis at equal time intervals:
If you want the specific dates to be used as labels, this means they should be used like text labels. Select the top row and apply Format->Number->Plain Text:
Now the columns are labeled with the text from the top row, and they are presented in the order of appearance in the spreadsheet.
