Forum Discussion
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 res...
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?
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?