How to Display Negative values in Pie Chart?

[Navars]

Hi folks,

In my data it has some negative values, I want to show that negative values as well as positive values in my pie chart.

find the data and sample chart, Please help me on that.

[oknotsen]

If you want to display positive and negative numbers, a pie chart is not the correct / preferred visualization.

Consider using a bar chart instead.

[jonathandienst]

How do expect a pie chart to reflect the negative numbers if there also positive numbers? Onno is correct -  a pie chart cannot be used for such as visualisation, and any attempt to force (by Fabs() ing the results, fo example) it will distort the result significantly.

[vikasmahajan]

use FABS  command

[oknotsen]

Nah, use a better visualization instead .

[jonathandienst]

DO NOT JUST USE THE FABS COMMAND! This just distorts the data and is still not a useful visualisation

[vikasmahajan]

I think instead of bar chart you can use water fall chart !! for better visualization

Vikas

[Navars]

I tried with FABS it converts the values -ve to +ve and it displays, But my requirement is it shows both -ve as well as +ve values.

[sudeepkm]

I do not want to put it as a suggestion because I do not think PIE chart should be used when you have negative values.

But one possibility is to some how indicate which slices are negative. That you can achieve it by using PIE pop out to show those which are negative.

As Vikas mentioned without using fabs in your expression you can not build the PIE chart. Once you use the fabs in your chart expression then you go to Pie Pop out option to put a condition to show the negative ones as pop out slices.

not sure how end users will take it. but my suggestion to use a st. table with color format to indicate the negative ones than positive values.