View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Campbell
 
Posts: n/a
Default 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