 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / October 2006How 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? 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 _______ >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? I didn't think it could be done...but my boss insisted that it could. Thank you > 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 [quoted text clipped - 14 lines] > > 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 _______ >I didn't think it could be done...but my boss insisted that it could. >Thank [quoted text clipped - 22 lines] >> > negative >> > number? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.