Hi,

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

Cheers
Andy

Del Cotter wrote:
On Thu, 12 Jun 2008, in microsoft.public.excel.charting,
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...art-challenge/

Are you sure you couldn't just use a column graph instead? Excel Column
chart type has the facility that's strangely lacking in its Area chart
type, the ability to change color when the value is negative.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info