chart datapoint color

[Wolfgang Huell]

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)?

Regards,

Wolfgang.

 

[Debra Dalgleish]

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/Excel/Charts/format.html#CondChart