software

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.

Hi,

Here are some formula to create the effect.
A1: =50 (or whatever your summed value is

B1: =GreenC1: =IF(AND(A1gt;=75,A1lt;=100),A1,0)
B2: =YellowC2: =IF(AND(A1gt;=50,A1lt;75),A1,0)
B3: =RedC3: =IF(AND(A1gt;=1,A1lt;50),A1,0)
B4: =WhiteC4: =100-SUM(C1:C3)

Select the range B1:C4 and create a pie chart. Colour the slices to
match the slice names. Adjusting the value in A1 will adjust the share
of the 2 visible slices with the colours matching your value bands.

For a more gauge looking pie chart have a look at Jon Peltier's example.
peltiertech.com/Excel/Charts/SpeedometerXP.html

For a more gauge looking xy chart have a look here
www.andypope.info/charts/gauge.htm

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Try this approach:

peltiertech.com/Excel/Charts/SpeedometerXP.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Patrickquot; gt; wrote in message
...
gt;I hope this is a simple question. How do I get a pie chart to begin at 100%
gt; availability and decrease based on a sum at the end of a column of values?
gt; If
gt; I can color it, ie. 100%-75% green 74%-50% yellow, and 49% or less as red,
gt; that would be even better. The only thing I can relate it to is an
gt; automobile's gas gauge.