Gridlines on Top

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mwavra - 27 Sep 2007 20:38 GMT

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.

Reply to this Message

Del Cotter - 27 Sep 2007 21:50 GMT

>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.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message

Jon Peltier - 27 Sep 2007 23:19 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

>>I know I can copy a chart, and reformat the copy to show only the
>>gridlines
[quoted text clipped - 4 lines]
>
> Create your own gridlines using XY (Scatter) series.

Reply to this Message