Colouring area under curve in a scatter chart?

[Ed Ferrero]

I am using Excel 2003 and have a scatter chart with several series.

I would like to fill the area under each series with a different colour.
Does anyone know a way to do this?

The chart in question can be found here. It is not easily reproducible as an
area chart.
http://www.edferrero.com/Content/Scatter_Pyramid.xls

Apologies for cross-posting this, my three-week old laptop had a major drive
failure today, so I have spent most of the day trying to recover data files
(successfully) and trying to format the OS partition (unsuccessfully). I
must be a little tired now...

Ed Ferrero

 

[Ed Ferrero]

One way to do this is by using a stacked cone chart and changing the 3-D
perspective so that the chart looks flat.
http://www.edferrero.com/Content/Cone_Pyramid.xls

But I feel that this is cheating, and the original question still stands -
does anyone know how to fill the area under a scatter chart series?

Ed Ferrero

 

[Andy Pope]

Hi Ed,

Couple of ways both of which involve area charts.

Add 5 series to the chart all of which are area. The use all of the xy
points you have calculated for the pyramid.
There is a small variation between xy outlines and area outlines.

Or convert the xy series in to 5 stacked area charts, value would need to be
altered. Add another area series to the secondary axis and this plots the
outline pyramid shape and acts as a mask when formatted to match the plot
area.

I have emailed you examples.

Cheers
Andy

 

[Jon Peltier]

Ed -

Two approaches:

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

- Jon

 

[Ed Ferrero]

Thanks guys,

Jon's Line and Fill Effects in Excel Charts Using VBA is what I vaguely
remembered, but could not find at all last night.

But I love Andy's method of using an area series attached to the secondary
axis that acts as a mask for unwanted chart elements.

Ed Ferrero

 

[Del Cotter]

One way to do this is by using a stacked cone chart and changing the 3-D
perspective so that the chart looks flat.
http://www.edferrero.com/Content/Cone_Pyramid.xls

But I feel that this is cheating, and the original question still stands -
does anyone know how to fill the area under a scatter chart series?

Here's a pure stacked area chart implementation, using time-scale axis:

http://www.branta.demon.co.uk/docroot/excel/DCPyramid.xls

 

[Del Cotter]

One way to do this is by using a stacked cone chart and changing the 3-D
perspective so that the chart looks flat.
http://www.edferrero.com/Content/Cone_Pyramid.xls

But I feel that this is cheating, and the original question still stands -
does anyone know how to fill the area under a scatter chart series?

Here's a pure stacked area chart implementation, using time-scale axis:

http://www.branta.demon.co.uk/excel/DCPyramid.xls

(Apologies for the earlier incorrect URL)