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/...nalChart1.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
_______

"Campbell" <[email protected]> wrote in message
news:[email protected]...
> 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