How do I get a pie chart to recognize a negative number?

[Guest]

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?

 

[Jon Peltier]

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

 

[Guest]

I didn't think it could be done...but my boss insisted that it could. Thank
you

 

[Jon Peltier]

Bosses are like that. I almost said in my first response that you should
explain to your boss how it works.

- Jon