How to make a negative number be 0% on a pie chart

[dbwoods11]

I am trying to make a pie chart for a group of numbers. Some are positive, some are negative.

1
1
-1
1

For example: With the numbers above the pie would be in 4 equal quarters. Instead it should be 3 equal parts since a negative number techincally doesnt get any slice of the pie.

How can I get the graph to take a negative number to be 0% of the pie?

Thanks

[Jarko28]

hi,

put a formula like this into an adjacent cell

=if(A2<0,0,A2)....drag down, and make the chart based on those values