Line Graphic with Area

[Guest]

How can I built a line graphic (one serie only) that as under the line a
coloured area without hiding the X and Y gridlines?

 

[Andy Pope]

Hi,

As you are aware the trick of using an area chart to colour below the
line will obscure the gridlines. Therefore you will have to create your
own gridlines using more dummy series. See Jon Peltier's explanation.
http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html

Cheers
Andy