Creating a Capcity Graph

[nuggie]

I am trying to create a capacity graph that shows percent of capacity used. I have four assets
Like This

Hip Printers 9.25 (8.25)
Sorter 0.07 0.93
Staffing 1.00 (0.00)


I have converted use to percent. First column is % of use, second is remaining capacity.

I am using a 100% stacked bar. I am trying to have it change color as the capacity reaches max. I also want it to go past 100% when the demand is greater then capacity. Currently it goes in the opposite direction.

Thanks for any direction.
~n

 

[Jon Peltier]

What are you stacking, and why are you constraining it to 100%? If you have two values that don't add to 100%, in a 100% stacked chart, the stacked bars will still reach to 100%.

To change a bar's color as a function of value, try the technique described here:

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