Forum Discussion
Solved
Axis options in a line diagram.
I am using MS 365 and doing a standard line diagram with a date axis. Why does the Axis Options differ between diagrams in individual sheets of the same work book? In some sheets the Axis Options co...
Thanks, that helps.
The x-axis values in Sheet1, range A4:A27 are left-aligned, indicating that Excel sees them as text values.
Select A4:A27.
On the Data tab of the ribbon, click Text to Columns.
Click Next > twice.
Select YMD from the drop-down next to Date.
Click Finish.
If all goes well, the values will now be right-aligned.
If you now double-click the x-axis, you should see all sections.
Could it be the difference between a date axis and a text axis (with dates treated as text)?