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...
These are my x, y values that create the chart => https://snipboard.io/UhkOcZ.jpg.
Where do I put the 1900-01-01?
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.
- 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-bit