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?

On Thu, 12 Apr 2007, in microsoft.public.excel.charting,
hmm said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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.

"Del Cotter" wrote:

On Thu, 12 Apr 2007, in microsoft.public.excel.charting,
hmm said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Hi,

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

Cheers
Andy

hmm wrote:
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?