Blank Values in Excel Pareto Charts

Hey everyone,

I have multiple pareto charts with corresponding tables, and the chart displays values when their at zero, does anyone know a way to force the chart to only display the codes with a value greater than zero associated with it.

As you can see, the chart displays the all the codes on the x-axis and the value of the code (instance of the code) on the y-axis. I want to force the chart to to only display the codes that have a value > zero.

There are about 27 codes in the table, seen above, so I need the table to automatically aggregate the values, but the chart wont filter out the codes that have zero instances (such as FZ seen above).
I have tried to use the filter settings through 'Pivot Table Analyze' and the filters on the pivot tables (again, seen above), but no code or filters I have tried seems to rid the chart of the codes with zero values.

If anyone has any ideas, it would be greatly appreciated.

Yeah here is an example file of what I am trying to eliminate in the pivot chart.

As you can see in the example file, there are only 6 codes that have a value greater than zero associated with it. I want to eliminate the codes that have values equal to zero. Thank you.