Hello,
I have a chart that plots points on it and a line.
The data comes from multiple tables and columns.
Everything works great except that the spacing between the points is fixed instead of spaced based on the horizontal axis value.
This makes the chart look unrealistic.
Please see attached pictures. The top is how it is acting now, and the bottom is how I want it to look.
You see how the 0, 30, 50, and 100 horizontal axis points are spaced properly as if all the numbers in between are there, but just not shown.
The reason the top one has all that space to the left is due to all the N/As in the table.
I also need to get rid of that so it looks like the bottom example.
I tried changing the horizontal axis setting to Date instead of Automatic, and it works in spacing it properly and getting rid of all the extra empty space to the right of the chart, but it shows all the numbers in between 0-100 and it looks very cluttered.
I just want it to show the 0, 30, 50, and 100 (used numbers).
It would work if there was a way to hide the unused numbers in between.
If you can please help me resolve this.
Thank you!
BUntitled.jpg
Bookmarks