Forum Discussion
Excel 365 Chart Gridlines
In the past, on a chart, I could adjust the starting and ending values for the y-axis on a chart (which I still can do). Additionally, I could space the major gridlines as I see fit. I have a graph that has data from 0-40 (y-axis), the gridlines are spaced (automatically) every 5 units. (5,10,15,20,25,30,35), I want the spacing to be every 4 units (4,8,12,16,20,24,28,32,36). How do I adjust the gridline spacing on a chart?
Thanks
I'm on a Mac but assume you have similar options when you ar not.
Format the Y-axis and then you should see an option to set the interval between labels. See attached.
4 Replies
I'm on a Mac but assume you have similar options when you ar not.
Format the Y-axis and then you should see an option to set the interval between labels. See attached.
I'm on Windows
Well I discovered on the chart I'm working on it is a pareto chart, not a combo chart. The pareto chart doesn't give me the capability to set the grid interval.
However, the combo chart does.
Do we speak about Excel Online or Excel Desktop?
I assume it is excel desktop. I'm working in the excel program, not on a browser.
