Gridlines on Top
 

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.

Gridlines on Top
 

On Thu, 27 Sep 2007, in microsoft.public.excel.charting,
mwavra said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Gridlines on Top
 

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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Del Cotter" wrote in message
...
On Thu, 27 Sep 2007, in microsoft.public.excel.charting,
mwavra said:

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.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.