Forum Discussion
Solved
Chart reading dates incorrectly in Excel
Hello Community Members, the chart in Excel (Office 365) shows the date as January instead of March even though I've checked the regional date and time settings from the control panel. I've also ch...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Thanks!
Click on the chart, then double-click the x-axis.
Alternatively, select the x-axis, then activate the Format tab of the ribbon and click Format Selection.
In the Format Axis task pane, under Axis Options, select Text Axis as Axis Type.
The axis labels will then be the same as the cell values.
HansVogelaar thanks buddy for the help.