PIE CHART

[datastudent]

Hi,

Is there a way to not show the category in the graph if the amount is zero or blank without manually filtering it out?

My table has a formula where it would automatically show the category and amount from the other sheet. Here I have category (ECASH) but showing blank or zero amount and a blank category after that. I want them to not show in my pie graph legend.

 

[Cubist]

Hi,

Is there a way to not show the category in the graph if the amount is zero or blank without manually filtering it out?

My table has a formula where it would automatically show the category and amount from the other sheet. Here I have category (ECASH) but showing blank or zero amount and a blank category after that. I want them to not show in my pie graph legend.

View attachment 108176

One way is to hide the row whenever it’s blank. This would require VBA to automate it.