Forum Discussion
How do I change the X axis values for an Area Chart?
The x-axis of a scatter chart is numeric. The x-axis of all other chart types is text except when it is a date axis. So you could set the axis to be a date axis:
Unfortunately, you will have to specify the min and max as dates. You can find out the values you need by entering the numbers in cells and then formatting them as dates:
Where do I put the 1900-01-01?
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.
- I understand that. Where, in the Excel cells, should I enter 1900-01-01, etc.? It would help if you provided an image similar to --- https://snipboard.io/UhkOcZ.jpg --- that shows how the Excel cells should be modified.
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.