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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 01:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com