Forum Discussion

AllenChan's avatar
AllenChan
Copper Contributor
Aug 09, 2023

Excel Pareto Chart ignore zero value/empty cell

Hi All,

 

I would like to ask for advice how to ignore zero value / empty cell when create Pareto Chart in Excel.

 

excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Aug 09, 2023

    AllenChan I don't believe you can do this in one go. You'd need a sub-set of the data where you have filtered out the zeros and empty cells. If you have Excel 365 of 2021 you could easily achieve that as shown below.

    File attached.

     

Resources