View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Colouring area under curve in a scatter chart?

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