Forum Discussion
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.
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.