Forum Discussion
How do I change the X axis values for an Area Chart?
Double-click the x-axis.
Activate the Axis Options tab of the Format Axis task pane.
Under Axis Type, select Date axis (as shown in the screenshot in my previous reply).
You should then see the Minimum and Maximum boxes.
Enter the values according to your system date format. I use ISO date format yyyy-mm-dd, hence 1900-01-01. If you use for example m/d/yyyy, enter 1/1/1900 to represent 1, or 1/0/1900 to represent 0.
You should not modify the source data at all - leave them as they are now.
The date values should be entered in the Minimum and Maximum boxes of the Axis Options tab of the Format Axis task pane, as shown in the screenshot in my first reply.
- This is what I see => https://snipboard.io/xBcXTm.jpg. "Bounds" is not displayed.
I am using Office 365, Excel (Version 2409 Build 16.0.18025.20030) 64-bitCould 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? Alternatively, you can attach it to a private message to me. Thanks in advance.