Can't change the X-axis scale

[Shedvoy]

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.

[#2 · Accepted solution]

@Shedvoy 

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

[#3]

@Sergei Baklan 

That's exactly what I wanted, thank you!

[#4]

@Shedvoy , you are welcome