I would like to set the color of individual bars on a bar graph based on the
value of the cell on the corresponding excel 2007 spreadsheet. I want to use
traffic light colors - red, yellow and green depending on the numeric value
in the cell it is tied to.

Jon has very useful instructions at
http://peltiertech.com/Excel/Charts/...nalChart1.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"jwats" <(E-Mail Removed)> wrote in message
news:0F73ED7D-9B1D-473E-B090-(E-Mail Removed)...
>I would like to set the color of individual bars on a bar graph based on
>the
> value of the cell on the corresponding excel 2007 spreadsheet. I want to
> use
> traffic light colors - red, yellow and green depending on the numeric
> value
> in the cell it is tied to.

[Steve=True]

The basis of a chart like this is to make another chart area and us the Excel Function of NA() to hide columns that are not the desired outcome. Excel does not plot #N/A values which is a result of NA().

Your formula might look like the following:

=if(cell>=Average,cell,NA())

then change the color of this column to Green. Only above average columns will be colored green.

Do the opposite for Red columns.

Here is a video tutorial on making conditional column chart where each column is colored red or green if it is below or above an average line:

http://www.exceldashboardtemplates.com/?p=891

Good luck!