Forum Discussion
How do I change the X axis values for an Area Chart?
I am using Office 365, Excel (Version 2409 Build 16.0.18025.20030) 64-bit
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
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?
Set the minimum to 1/0/1900. That is the value corresponding to 0.
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?
- This is a good start! I'll strive to make this work. Thanks!
Thanks. Just like you, I couldn't get it to work. I had to create the chart from scratch.
I then ran into a new problem: a date axis only displays integer values (whole numbers).
So I removed the x-values 0.5, 1.5 etc.
That may be a deal-breaker for you, but I do not know of another way to do this.
See the attached version.
- Sorry for the delay. That file can be downloaded from my website - https://temp.foxping.com/.