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

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

Thanks, I think I can make that work..