Applying data as a line over an area chart

  • Thread starter Thread starter ahaigh
  • Start date Start date
A

ahaigh

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
 
Back
Top