How to Add Fill To A Chart

[Brian]

I created a XY scatter plot. Now I would like to colour the plot area below
my line. Is this possible?If so, how is this done?

 

[Andy Pope]

Hi,

Have a look at Jon's example to get an idea of using a dummy data series
to colour parts of the plot area.
http://peltiertech.com/Excel/Charts/format.html#Quadrants

If you simply want to colour below a line then an area chart will
probably suit your needs.

Cheers
Andy

 

[Jon Peltier]

Alternatively, this page shows how to make a combination scatter-area chart, which
should do nicely.

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

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