Negative in Pie Chart

[#1]

Hi,

It is possible to put in a Pie Chart Positive and Negative values in the same chart?????

I need Help with this plz

Regards

Carlos

[#2]

Carlos,

Pie charts aren't the best way to represent negative numbers. Stephen Few produced a great article about the problems with pie charts in general, might be worth a read

Save the Pies for Dessert - Stephen Few

[Oleg_Troyansky]

Yes, in order to ignore the negative values for the pie charts, use function rangemax():

rangemax(0, "your expression")

This way, all negatives are automatically replaced by zeros.

cheers,

[#4]

Hi,

There's no need to put them in 0, i resolved my problem with FABS(), the only thing you have to do is that you have to create a new expression as a Text Pop UP with out Fabs and that's all, you are going to have A Pie Chart with negative and positive values.

[#5]

Hello Orlando,

Thanks so much for the above, it works like a charm 🙂

[#6]

Just a quick thanks to Oleg - rangemax was just what I was looking for to ignore the negatives in my pie charts. Thanks to people like you beginners like me have a chance.

[christian77]

Hi:

Once you have your pie chart with negative values, set it to relative values, percentage, and see the result.

If your negative values are large, the chart won´t mean anything.

I recomend to use bar charts instead.

[Anonymous]

Thank you.  This was very helpful!!