You can't format the chart based on the colours in the source data, but
Jon Peltier has some instructions for creating conditional charts:

http://www.geocities.com/jonpeltier/...html#CondChart

Wolfgang Huell wrote:
Hi all.

I am using conditional formatting to show if a value in a cell is good or
bad (green or red).
Is there a way to do the same thing when I chart these values? Good
datapoints = green colums, bad ones red (based on the color of the cell
where the datapoint comes from)?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html