How to get a pie chart to ignore negative values but recognize them when they become positive

You could use a formula such as =IF(B>0,B,0) and use this column of formulas for the chart instead of the column with the raw data.

"Is that my only option?"

You asked:

"How do I make the proper adjustment to get an accurately depicted pie chart?"

Numbers will chart the information that you supply.

If your spreadsheet supplies the negative values, and those values are sent to cells included in the group selected for the chart, then those values, ignoring the sign, will be included in the chart.

If you don't want those values included in the chart, then 'the proper adjustment' is to not supply the chart with those values.

You can do that using Badunit's formula, or this version:

=IF(B<0,"",B)

Different appearance on the table, but the same appearance on the chart as with **'s formula.

Regtards,

Barry

FatCaddie wrote:

Is that my only option? The spreadsheet has already been built, formatted and released for public review. I'd rather not change anything that will affect the look of the spreadsheet.

You can hide the column after entering the formulas and creating the chart (and be sure to click the "show hidden data" box for your chart). Your table will look exactly as it did before.