View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ahaigh
 
Posts: n/a
Default 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