Forum Discussion
Solved
Can't change the X-axis scale
Hello,
I'm trying to make a graph with two series and the x-axis as a 24-hour day, but when I add the second set of data I cannot change the scale and intervals of the x-axis (I don't get an option to pick horizontal axis - values).
I want to be able to change the interval to 6 hours so I don't a separate value for each hour.
Also, I want to make the additional vertical axis to line up with the 24th hour instead of being slightly shifted to the right.
In this case it's better to use scatter chart. Select this type of chart, adjust each series as
set second series on secondary axis, double click on X-axis and set min, max and interval.
Result is
and in attached file
