Try this approach:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Patrick" wrote in message
...
I hope this is a simple question. How do I get a pie chart to begin at 100%
availability and decrease based on a sum at the end of a column of values?
If
I can color it, ie. 100%-75% green 74%-50% yellow, and 49% or less as red,
that would be even better. The only thing I can relate it to is an
automobile's gas gauge.