How to get a pareto chart to ignore 0

[Kevin62]

I have a list column of possible production errors, total errors and then the cumulative percentage. The columns are validated in descending order. Sometimes, there are "0" (zero) errors. Validation leaves the zeros at the top and not the bottom which messes up the chart.

I need a way to make the chart ignore zeros, the validation to ignore zeros or both?

Here are examples of my code:

[shg]

How about changing 0 to na()?

[Kevin62]

I tried using

and it works as long as the row it's used in = 0. I get a name errors in rows where the answer is above 0.

[shg]

NA is a function.

=IFERROR('C-450'!C39 + 'C-625'!C40, NA())

[shg]

Kevin,

Re your PM: You can post the workbook here. The contents need only be sufficient to demonstrate the problem.

To attach a file: From the Reply dialog, press Go Advanced, then scroll down to the Manage Attachments button. Browse to the file and press Upload.

Zip beforehand if necessary to keep within size constraints.

[Kevin62]

Pareto.jpg

Here's all the code.

[shg]

Kevin, what am I supposed to do with an unreadable picture?

[Kevin62]

I apologize. I didn't know it would be so small.

[shg]

You would benefit greatly by reading the “Want to get your question answered quickly?” section of the Forum Rules.