Changing Colour of Bar depending on Value

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

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

http://peltiertech.com/Excel/Charts...onalChart1.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" <Campbell@discussions.microsoft.com> wrote in message
news:A8DF4F55-F8F9-4B47-A3E9-2F0C14854B0C@microsoft.com...
> 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