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...
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?
Where do I put the 1900-01-01?