Forum Discussion
How do I change the X axis values for an Area Chart?
Insert > Chart > Scatter --- results in https://snipboard.io/DBOqm3.jpg. It is easy to change the X axis values.
Insert > Chart > More Charts > More Scatter Charts > Area --- results in https://snipboard.io/j1onUm.jpg. How do I change the X axis values?
16 Replies
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:
- These are my x, y values that create the chart => https://snipboard.io/UhkOcZ.jpg.
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.
