removing 0% from pie chart

I know this question was asked a billion times, but I haven't found any solution that solves it entirely.

I have a list of customers in one column and how many products they purchased during a certain amount of time. Some of these customers will buy 0 products in this month but more than 0 in the previous month. A pie graph of all the customers and their purchases shows the percentage each customer contributed to total sales, however, the pie chart changes according to the selected date range.

My problem is I don't want customers with 0% to show on the pie graph, but the issue is that these customers will not be 0% all the time since changing the date range will also change the value. So the customer must re-appear on the chart if this customer has more than 0%.

I tried the 0%;;; thing but it only removes the number "0%" while the name of the customer remaines and the chart gets very crowded.

Some told me to use macros, but I'm a bigginner and I have no idea what macros are or how to do them, so I prefer a more simple solution if possible.

I have attached a sample of my excel sheet so you can have an idea of what I'm talking about.

Thanks in advance.