Gridlines on Top

[Guest]

I know I can copy a chart, and reformat the copy to show only the gridlines
and then overlay it, but is there an easier way? I have a lot of charts that
are small size, and it would be easier to see the plot points if the
gridlines were on top rather than behind the data series.

 

[Del Cotter]

I know I can copy a chart, and reformat the copy to show only the gridlines
and then overlay it, but is there an easier way? I have a lot of charts that
are small size, and it would be easier to see the plot points if the
gridlines were on top rather than behind the data series.

Create your own gridlines using XY (Scatter) series.

 

[Jon Peltier]

If you use "arbitrary" gridlines, which are actually error bars, they will
appear in front of the charted data:

http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html

- Jon