google sheets
I have the following temperature data:
1/1/2019 9:00AM 18.5
1/1/2019 5:00PM 21.3
2/1/2019 8:00AM 23.6
2/1/2019 5:00PM 20.8
2/1/2019 9:00PM 13.4
I can get a plot with the x-axis as either date or time. But would like to plot the temperature at these time points nested within the dates.
Copy of a more extreme example of 'co-linearity`:
seems to have pointed to an acceptable solution/workaround. That is, add data point markers (Point size, in Customise in Chart Editor) - in the image to one [red] data series (also with the line made thinner than the default and the other [blue] series line increased in width).
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.
Best Answer