Forum Discussion
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 date and time are clearly displayed as '00/00/00 00:00:00' format (dd/mm/yy). In contrast, the humidity line displays as '00/dd/yy 00:00:00'. I intended for both lines to use the 'dd/mm/yy' format. How can I rectify this inconsistency with the humidity line, and identify its root cause?
Find attached my Excel sheet. Thanks.
1 Reply
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:
