On Sun, 15 Jun 2008, in microsoft.public.excel.charting,
Andy Pope said:
Del Cotter wrote:
Johnny said:
I want to create a chart where the areas under the baseline are a
different color than the areas above the baseline. Is that possible?

It's possible, but *very* tricky in the details. Jon did a similar
exercise a little while ago in his blog:
http://peltiertech.com/WordPress/200...ed-area-chart-
challenge/

This should give you a jump start.
http://www.andypope.info/charts/conditionalline2.htm

I've published my simple solution he

http://i-ocean.blogspot.com/
2008/06/excel-area-chart-with-colour-invert-if.html

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.