Well, I'm not sure how to make one data series have two different colors.

Your solution on sheet2 looks pretty good. I was thinking also, instead of
having a second row for your "second" series, use columns for May-forward on
the same row as your second series data source.

As the months go on, you would then simply need to change your data source
properties for each series. Using a named range as your series data source
may even make this more automatic.

If there is any way to make a single range have two colors, I'm sure either
Debra Dalgleish www.contextures.com or Jon Peltier www.peltiertech.com would
have it on their sites. Though I looked briefly and didn't see anything
directly relating.

Hope that helps a bit.

"germullen" wrote:


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