Hide/Unhide Rows based on Zero Value

Hello All,

I am graphing data compiled using sumproduct. I have the sumproduct =value linked to a dropdown, so if one value is chosen, all other suproduct rows are 0s except the value chosen.

This allows the chart to show one value, except the zeroed data still shows on the chart legend. It looks like the only way to remove the legend entries is to hide the zeroed rows.

Would you be able to show me a VBA that would hide/unhide rows based on whether a cell is zero?

Attached is a dummy sheet as an example. I would like to hide Rows based on values in column B. If the Value in B,n is 0 I would like to hide row n. These rows will change from 0 to other numbers and if the value in B,n is not 0, I would like to unhide that row.

Alternatively, is there an easier/more elegant way to do what i'm doing???

Thanks again for the help, you guys are great!

-chiz