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.