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.

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.

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.