| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get a pie chart to recognize a negative number?
I need to make a pie chart that has one part of the pie as a negative
percentage. Does anyone know how to get my chart to recognize this negative number? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I get a pie chart to recognize a negative number?
Seriously? Pie charts can't handle negative numbers. How do you display it
so it subtracts from the whole pie? How does the reader remember that the blue wedge is deducted? It just won't work. This is only reason #14 that pie charts are really not a very good design for a useful chart. You could try a clustered column chart or maybe a stacked column, depending on what the data is and what exactly you're trying to show. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Kenda" wrote in message ... I need to make a pie chart that has one part of the pie as a negative percentage. Does anyone know how to get my chart to recognize this negative number? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I get a pie chart to recognize a negative number?
I didn't think it could be done...but my boss insisted that it could. Thank
you "Jon Peltier" wrote: Seriously? Pie charts can't handle negative numbers. How do you display it so it subtracts from the whole pie? How does the reader remember that the blue wedge is deducted? It just won't work. This is only reason #14 that pie charts are really not a very good design for a useful chart. You could try a clustered column chart or maybe a stacked column, depending on what the data is and what exactly you're trying to show. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Kenda" wrote in message ... I need to make a pie chart that has one part of the pie as a negative percentage. Does anyone know how to get my chart to recognize this negative number? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I get a pie chart to recognize a negative number?
Bosses are like that. I almost said in my first response that you should
explain to your boss how it works. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Kenda" wrote in message ... I didn't think it could be done...but my boss insisted that it could. Thank you "Jon Peltier" wrote: Seriously? Pie charts can't handle negative numbers. How do you display it so it subtracts from the whole pie? How does the reader remember that the blue wedge is deducted? It just won't work. This is only reason #14 that pie charts are really not a very good design for a useful chart. You could try a clustered column chart or maybe a stacked column, depending on what the data is and what exactly you're trying to show. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Kenda" wrote in message ... I need to make a pie chart that has one part of the pie as a negative percentage. Does anyone know how to get my chart to recognize this negative number? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart number of occurences | Charts and Charting in Excel | |||
| Automate bar chart color based on value postive or negative | Excel Discussion (Misc queries) | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| how do i subtract a negative number | Excel Worksheet Functions | |||
| chart label reference based on the column number | Charts and Charting in Excel | |||
Linear Mode
