View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?