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,


--
ahaigh
------------------------------------------------------------------------
ahaigh's Profile: http://www.excelforum.com/member.php...o&userid=32414
View this thread: http://www.excelforum.com/showthread...hreadid=554892

Applying data as a line over an area chart
 

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