Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Chart Pie chart negative values

Good, I'm trying to show the data from a table in a pie chart and in the table I have some results where the number is negative, and in the graph I'm just taking the positive values, the negative results don't show them.

Alberto99_0-1649758613931.png

I would like to show both positive and negative values on the chart.

Greetings, thank you.

  • If you have some negative values a pie chart might not be the best option.

     

    You could use ABS() to get the absolute value, which a pie chart would plot, but then you'd need a way to show which are negative or not (SIGN() could help with that). Or, you could have two pie charts, one for the positive and one for the negatives?