Remove 0% and "blanks" from Pie Chart

Hi Folks,

I'm trying to display a Pie Chart that ignores when the hours worked = 0 or when there is no line item

In the attached Row 13 (Project 6) has had no work done to it for the period 1/7/24 - 28/7/24. Therefore, I'd like for it not to be displayed in the Pie Chart or Chart Legend

Similarly, Rows 16 - 18 have no entries in them. Therefore, I'd like for those not to be displayed until/unless data is entered.

Basically if Column AD = 0 or has no value (it has formula) then don't include in the Pie Chart

I've googled and seen some solutions but am struggling to make it work for me.

Can any of your fine minds help me out with this please.

Thanking you as always.

MM

Thanks MrShorty,

That's the course of last resort. Ideally I'm looking for a solution that's fully automated if possible.

MM