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...
Your solution works well. Except when I do a partial => https://snipboard.io/l9OuN5.jpg. The chart x axis now starts at 10. How do I set the x axis to start at 0?
Set the minimum to 1/0/1900. That is the value corresponding to 0.
Nice trick!
- A simple solution. Start with --- Insert > Chart > Scatter [change every other y value to zero ... delta = 0.1 ... line width = 0.25 pt] =>https://snipboard.io/fFYrL6.jpg.
Then change [delta = 0.05 ... line width = 2 pt] => https://snipboard.io/OIB9aN.jpg.
It is also easy to do partials => https://snipboard.io/EuhZdw.jpg.
It would be good if Microsoft fixed the problems with the Area Charts. bhs67 Aaargh - 1/0/1900 does not work. Try 1/1/1900
- When I replace x = 0 with x = 1/0/1900 nothing changes. Where should I set the minimum?