You cannot color an area chart in this way, but you can fudge it with a
column chart. Here's a technique:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"JW" wrote in message
...
I have been working with an area chart colored in green. Based on certain
values of the graph, I would like the area just below the data point
highlighted in a different color (like red). In the end, the area graph
will
have 2 different colors in the 'area' below the line. The color below,
will
depend on the value of the line above. Any help is appreciated.

Also, I would consider a vertical bar graph where the spacing in between
bars is zero. That way, from a far, it could give the appearance of an
area
graph. I think I would need each 'bar' colored appropriately. I have
struggled coming up with this graph as well.

I envision a 3 column data series...
Column A = x axis
Column B = y axis
Column C = logic calculation that determines whether the data point is
colored red or green.

I am open to suggestions and assistance.