Colouring area under curve in a scatter chart?

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

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

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" <ed@edferreroremove.com> wrote in message
news:uE%23EKgFKIHA.1204@TK2MSFTNGP03.phx.gbl...
>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 -

Two approaches:

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

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


"Ed Ferrero" <ed@edferreroremove.com> wrote in message
news:uE%23EKgFKIHA.1204@TK2MSFTNGP03.phx.gbl...
>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
>

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

On Sat, 17 Nov 2007, in microsoft.public.excel.charting,
Ed Ferrero <ed@edferreroremove.com> said:

>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/docro...l/DCPyramid.xls

--
Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

On Sat, 17 Nov 2007, in microsoft.public.excel.charting,
Ed Ferrero <ed@edferreroremove.com> said:

>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)

--
Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.