How do I connect cell color to bar chart color?

[Bob Freerks]

I have seen an excel spread sheet bar chart where the colors of the bars were
connected to the color of the cell. I was not able to determine how that was
accomplished and the author of the spread sheet no longer works for the
company that sent me the data. Does anyone know how this can be done?

 

[Andy Pope]

Hi Bob,

It's possible this was done using a vba macro.

For a non VBA approach have a look at Jon's examples of conditional charts.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy