Thread: Chart gridlines over an area graph

Good morning!

I have an excel chart with an area graph. When I add gridlines to the chart
the lines do not show over the colored area portion of the graph. i found a
button for droplines which added the Y axis lines, but have found nothing
that will show the X axis lines through the graph.

Any ideas are greatly appreciated.

Have a GREAT day!

brenda

Hi,

You will need to draw the gridlines yourself using additional data series.
For horizontal gridlines you could use a series for each line, changing
the y value for each series.
Or a single series plotted as xyscatter. The x value would be 1 and the
y value will vary according to the required gridlines. You could then
use the X error bar with a fixed value to provide the lines.

See Jon Peltier's explanation,
http://peltiertech.com/Excel/Charts/...Gridlines.html

Cheers
Andy


frendabrenda1 wrote:
> Good morning!
>
> I have an excel chart with an area graph. When I add gridlines to the chart
> the lines do not show over the colored area portion of the graph. i found a
> button for droplines which added the Y axis lines, but have found nothing
> that will show the X axis lines through the graph.
>
> Any ideas are greatly appreciated.
>
> Have a GREAT day!
>
> brenda

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

On Wed, 28 Jun 2006, in microsoft.public.excel.charting,
frendabrenda1 <frendabrenda1@discussions.microsoft.com> said:

>I have an excel chart with an area graph. When I add gridlines to the chart
>the lines do not show over the colored area portion of the graph. i found a
>button for droplines which added the Y axis lines, but have found nothing
>that will show the X axis lines through the graph.

Make fake gridlines by creating a data series that plots horizontal
lines, then make sure it's the last series so it plots on top of the
others. Jon Peltier's web site has examples.

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