how do I get the bars on my graph to match the cell color
 

I have conditional formats on cells so that a color is generated based on
what number is in the cell. When I make a simple bar graph, the data series
is all one color. Without having to change each bar individually is there a
quicker way of doing this?

how do I get the bars on my graph to match the cell color
 

Hi,

See Jon Peltier's page on conditional charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html

You will need to apply the same CF formula to the chart data.

Cheers
Andy

kwazy4 wrote:
I have conditional formats on cells so that a color is generated based on
what number is in the cell. When I make a simple bar graph, the data series
is all one color. Without having to change each bar individually is there a
quicker way of doing this?