Secondary-axis gridlines

H

hmm

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?
 
D

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.
 
H

hmm

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top