Excel Bar Chart

[Chris waller]

I have created a bar chart for my manager which he is quite happy with, but
now I have been asked whether it is at all possible to apply a colour to each
bar depending on whether it is equal to certain criteria, a bit like the
conditional format facility. I am currently using Excel 2002. The criteria I
want to use is if the figure is >8.7 I would like the bar in the chart to be
red. >8.3<8.7 orange, >7.8<8.2 yellow and 7.7 or less green. I would also
like these figures to appear in an appropriate coloured square in the legend.
TIA

 

[Jon Peltier]

This page explains how to set up a conditional chart:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon

 

[Chris waller]

Jon,

Thanks that was just what I needed. I do just have one question. I have
recreated my graph from scratch, but unfortunately the #N/As appear on my
chart. Can you let me know how to get around this?

 

[Jon Peltier]

In a column or bar chart, you can use "" in place of NA() in the source
data.

- Jon