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

[germullen]

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

 

[Bernard Liengme]

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/AddLineHorzSeries.html

 

[germullen]

Thanks, I think I can make that work..