Changing Colour of Bar depending on Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Campbell - 31 Mar 2006 12:52 GMT

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

Reply to this Message

Jon Peltier - 31 Mar 2006 13:16 GMT

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
_______

> Hi there,
>
[quoted text clipped - 8 lines]
>
> Cheers

Reply to this Message