Positive and negative values in Pie Chart

[#1]

Hi there,

I got a dynamic Pie Chart, which is created depending on the chosen values.

Sometimes the result is, that there are postive and negative values in this chart. Since, I try to figure out a certain potential of the variable, this case is happening a lot. It means that the variable reached its full potential which I would like to show in this pie chart in some way.

Is there any chance to do this nicely?

Thanks a lot in advance.

Alexander

[MK_QSL]

PIE Chart can't show Negative Values...

There are some tricks to show -Ve values but it will misguide to the analyst.

check below thread.

How to create a pie chart with positive and negative values

[manojkulkarni]

You cann't represent negative values in pie chart. Instead you use color coding for text or pie for negative values.

[#4]

Logically it doesn't make sense to have a fabs slice on a pie chart unless all your values were negative, all you are doing is under proportioning the counterweight.

[Anonymous · Accepted solution]

I suggest using a stacked bar chart instead of a pie chart.

[flipside]

As others have stated, a pie chart isn't really the best option because it cannot show negatives and positives together on one pie.

You could, however, create two expressions and group them so the user can switch between positive results and negative results using the cyclic button.

EXPR1 - Positives: RangeMax(Value,0)

EXPR2 - Negatives: RangeMin(Value,0)

This works best when there is a legend with numbers showing and the Suppress Zero Values option unchecked.

flipside

[#7]

Thanks to all of you, but I think this works the best.