Horizontal Gridlines not matching secondary Y-axis

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I'm trying to plot a line/column chart in Excel with 2 data series.
However when I am trying to add in horizontal gridlines, Excel scales
the secondary Y-axis to integers therefore not matching the primary
axis. (ie. the numbers on the secondary Y-axis do not line up with the
gridlines).

Is there anyway that I can fix the scale so that the numbers will
appear beside the gridlines?

Thanks a lot,
Steven
 
It is all a matter of arithmetic.
Suppose the primary axis goes from A to B with Major units set to N; for
example max is 45, min is 20 and the major units are 5 so the labels are 20,
25, 30, 35,40 and 45
Let the secondary axis go from C to D (say 0 to 350); now you want the same
numbers of tick marks on each axis so (D-C)/N is the value you need for the
Major units; in our example (350-0)/5 = 70

Hope this helps
best wishes
 
I'm printing hundreds of charts. Is there anyway that I can automate
this? (maybe do the calculatation in a sheet, can refer to the cells
for 'min, max, major unit, etc...)

Thanks again.
 
Back
Top