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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Steven" wrote in message
ups.com...
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

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.


Bernard Liengme wrote:
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Steven" wrote in message
ups.com...
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

I would put this question in the programming newsgroup
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Steven" wrote in message
oups.com...
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.


Bernard Liengme wrote:
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Steven" wrote in message
ups.com...
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