Negative values in Pie Charts

[Mortong]

Hi there

How do I stop negative numbers showing in pie charts? Currently they are added in as a positive number.

I would like an easy way to
1. Neg values get ignored
2. Neg values get shown on their own pie chart

I know I can change the values themselves but that seems like overkill...

Thanks

M

[Narcís]

Hi Mortong,

I can only think of one way to do what you request. You should check if the values are lower than zero and if so add them to an additional pie series specific for negative values.