May 05 2022 04:02 AM
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 comprise five groups of settings (type, bounds, units, vertical crosses, position) but in other sheets the Axis Options comprise only three groups and with two groups missing (bounds and units are missing). Why?
I do need to use the bounds and units settings to make my diagram look right. Is there a way to access the bounds and units settings when they do not show up automatically?
May 05 2022 04:10 AM
Could it be the difference between a date axis and a text axis (with dates treated as text)?
May 05 2022 05:18 AM
Hi Hans, Thanks for the input. My axis are all of type date axis however.
I will try to share a screen shot showing date axis but without the Bounds and Units settings.
May 05 2022 06:04 AM
Or better:
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
May 05 2022 07:32 AM
May 05 2022 07:48 AM
SolutionThanks, 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.
May 05 2022 01:44 PM
May 05 2022 07:48 AM
SolutionThanks, 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.