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
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ed Ferrero" wrote in message
...
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