How to show negative values in a pie chart?

1. How do you represent a negative value in a pie chart?
2. How do you show negative values on a graph?
3. Why would we not use the pie chart if there are negative values in our data?

How do you represent a negative value in a pie chart?

Pie charts aren't designed to display negatives. Excel outputs the absolute value of all values. So, -20 is output in the pie chart as a slice with 20% of the pie's circumference. The only way to tell the number is negative is to reference the legend.

How do you show negative values on a graph?

Negative numbers are to the left of the origin on the x-axis and below the origin on the y-axis. To graph with negative numbers, start at the origin and go to the left if the x-value is negative, and downward if the y-coordinate is negative.

Why would we not use the pie chart if there are negative values in our data?

Pie charts are not designed to represent the data with negative values as negative slices can not be represented graphically as opposed to negative bars can be shown below the zero line in bar chart. So Pie chart legend can not make difference between a positive value and a negative value while totaling.