Forum Discussion
Shedvoy
Nov 03, 2019Copper Contributor
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.
On the Chart Design tab of the ribbon, select Add Chart Element > Axes > Secondary Horizontal.
Double-click the secondary horizontal axis (it is displayed at the top).
Under Axis Options, expand Labels, and set Label Position to None.
3 Replies
Sort By