Multi-colour Area chart (see attachment)
 

Hi, hope you can open the attached spreadsheet. I am trying (in vain)
to use two colours for the 'Profit' data series.

There is a potential solution in 'sheet2' but as we move through the
year it will require constant updating.

Any suggestions....?
Thanks


+-------------------------------------------------------------------+
|Filename: Profit.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4721 |
+-------------------------------------------------------------------+

--
germullen
------------------------------------------------------------------------
germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
View this thread: http://www.excelforum.com/showthread...hreadid=538415

Multi-colour Area chart (see attachment)
 

This problem is replicated in the main forum, where you can find a
solution, using two data overlapping series

Ger Mullen


--
germullen
------------------------------------------------------------------------
germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
View this thread: http://www.excelforum.com/showthread...hreadid=538415