conditional color fill of bar graphs

  • Thread starter Thread starter jwats
  • Start date Start date
J

jwats

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.
 
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!
 
Back
Top