Changing Colour of Bar depending on Value

[Campbell]

Hi there,

I am trying to put together an attendence register for some students, th
calculations are sorted, but what I want to do is create a bar graph showing
total percentage attendance but having the bar change dependin on the value.
e.g. if attendance is 100% a Green Bar, if say 80% Amber and if 60% Red.

Is this possible?

Cheers

 

[Jon Peltier]

Here's a conditional charting approach that uses separate series for each
format:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______