Y-axis on both sides?? Gridlines priority??
 

Is it possible to display a y-axis on both sides of a chart?

Both should be identical, and should have automatic scales. It's on a
Area chart with four or five data series.

Alternatively, if I could give the Gridlines priority (ie if they
appeared on top of the coloured area ranges) it would solve my
problem.

Thanks


--
germullen
------------------------------------------------------------------------
germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
View this thread: http://www.excelforum.com/showthread...hreadid=542920

Y-axis on both sides?? Gridlines priority??
 

In place of gridlines use horizontal lines that you make yourself
Make them the same colour as the gridlines and they appear to extent to the
edges of the plot area
See http://peltiertech.com/Excel/Charts/...orzSeries.html
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"germullen" wrote
in message ...

Is it possible to display a y-axis on both sides of a chart?

Both should be identical, and should have automatic scales. It's on a
Area chart with four or five data series.

Alternatively, if I could give the Gridlines priority (ie if they
appeared on top of the coloured area ranges) it would solve my
problem.

Thanks


--
germullen
------------------------------------------------------------------------
germullen's Profile:
http://www.excelforum.com/member.php...o&userid=30626
View this thread: http://www.excelforum.com/showthread...hreadid=542920

Y-axis on both sides?? Gridlines priority??
 

Thanks, I think I can make that work..


--
germullen
------------------------------------------------------------------------
germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
View this thread: http://www.excelforum.com/showthread...hreadid=542920