Secondary-axis gridlines

[Guest]

Is there any way--even by a trick--of having horizontal gridlines cross the
secondary y-axis major-unit hash marks, rather than based on the primary
axis' marks?

 

[Del Cotter]

Is there any way--even by a trick--of having horizontal gridlines cross the
secondary y-axis major-unit hash marks, rather than based on the primary
axis' marks?

You can put your primary scale over on the right, and the secondary
scale on the left, which should produce the same visual effect.

 

[Guest]

Thanks for your reply, Del.

Unfortunately, that will not work. The choice of which data set I place on
the secondary axis is not that its axis appear on the right, but because
Excel plots the secondary data ON TOP of the primary, obstructing it from
view. Putting the primary scale on the right, I would have to exchange the
datasets I am using as secondary and primary (in order to draw gridlines from
primary). Doing so would cause the wrong dataset to appear above,
undesirably obstructing the other from view.

 

[Andy Pope]

Hi,

Have you seen Jon's page on arbitrary gridlines?
http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html

Cheers
Andy