Applying data as a line over an area chart

Hi,

I posted this question earlier on the miscellaneous forum but I struggled with the answer so I'm hoping I might have more luck if I explain more clearly.

I have an area chart in excel with the x-axis being days and the y-axis being a percentage. (Each section of the chart is coloured)

I need to work out a way of overlaying an additional line over the top of the existing data (using the same x&y axis') Unfortunately I can't just draw it on as I'll need the data for the line in cells referenced elsewhere.

Is there a way I can set this up? There doesn't seem to be an option for area/ line chart and with a line chart I can't seem to apply colour between the lines.

Thanks in advance,

Hi,

See if this is any clearer.

Create your area chart and include the series you want plotted as a
line. Now select this series and use the menu Chart > Chart Type... to
change the series to a line chart.

Cheers
Andy

ahaigh wrote:
> Hi,
>
> I posted this question earlier on the miscellaneous forum but I
> struggled with the answer so I'm hoping I might have more luck if I
> explain more clearly.
>
> I have an area chart in excel with the x-axis being days and the y-axis
> being a percentage. (Each section of the chart is coloured)
>
> I need to work out a way of overlaying an additional line over the top
> of the existing data (using the same x&y axis') Unfortunately I can't
> just draw it on as I'll need the data for the line in cells referenced
> elsewhere.
>
> Is there a way I can set this up? There doesn't seem to be an option
> for area/ line chart and with a line chart I can't seem to apply colour
> between the lines.
>
> Thanks in advance,
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info