Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie Chart "Gas Gauge"
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie Chart "Gas Gauge"
Hi,
Here are some formula to create the effect. A1: =50 (or whatever your summed value is B1: =Green C1: =IF(AND(A1=75,A1<=100),A1,0) B2: =Yellow C2: =IF(AND(A1=50,A1<75),A1,0) B3: =Red C3: =IF(AND(A1=1,A1<50),A1,0) B4: =White C4: =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. http://peltiertech.com/Excel/Charts/SpeedometerXP.html For a more gauge looking xy chart have a look here http://www.andypope.info/charts/gauge.htm Cheers Andy Patrick wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie Chart "Gas Gauge"
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Pie chart on a pie chart (exploded)? | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |