Forum Discussion
Axis options in a line diagram.
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.
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.
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.
- Hi Hans,
Link to sample file: https://docs.google.com/spreadsheets/d/1N93MCNbc6SwaF_5QNv1GcGbAygMASw9x/edit?usp=sharing&ouid=101398242242417236273&rtpof=true&sd=true
The axis options in sheet "22_chart" includes the Bounds and Units settings but in sheet "Sheet1" those settings are not included.
Do you know of a way to access the Bounds and Units settings in "Sheet1", please?
Greetings from Göteborg, SwedenThanks, 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.
- Hello Hans,
Thank you very much for solving my problem.
You provided me with a very useful lesson into yet another aspect of Excel.