Fill Options for XY Graphs

[Guest]

Hello,

I want to be able to fill the area under an xy graph. How can I do this?

 

[Andy Pope]

Hi,

The usual work around is to use another data set plotted as an area chart.
This example actual shades between lines but you should get the idea.
http://www.andypope.info/ngs/ng21.htm

Or have a look at Jon's article if the xy graph is not a simple line.
http://peltiertech.com/Excel/Charts/VBAdraw.html

Cheers
Andy