I am trying (in vain) to use two colours for one data series in an Area
chart. See the attached zipped files

There is a potential solution in 'sheet2' but it gets messy updating
for a new month.

Any suggestions....?


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

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