Forum Discussion
WorrypasCanada
Sep 06, 2023Copper Contributor
Plotted lines, inconsistent display of date
Hi, In my Excel chart, I've plotted two lines: one for temperatures and the other for humidity, both data sets originating from a Data Logger. Upon clicking any point on the temperature line, the...
Patrick2788
Sep 06, 2023Silver Contributor
I resolved it by setting the cell format of the dates in the sheet to use dd/mm/yy.
Then in the Format Axis menu, I enabled the following: