Forum Discussion
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.
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?
2 Replies
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?
Hi Syndicate_Admin ,
Agree with the comments given by AntonioM . What is your specific business scenario and can you provide more detailed information, maybe I can give you the best reference.
Looking forward to your reply.
Best Regards,
Henry
