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...
When I replace x = 0 with x = 1/0/1900 nothing changes. Where should I set the minimum?
bhs67 Aaargh - 1/0/1900 does not work. Try 1/1/1900
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.