Hi All,

I want to hide a chart if there is no data. It's not a Pivot chart, and I am wondering if that's possible??

The charts work off formulas, and depending in the state selected, there will be more or less sales teams, and I only want the charts to appear where there is data.

For example, NSW might have 6 teams, and therefore requires 6 charts, where SA may only have 2 teams and therefore only 2 charts are required, but I get 2 charts full of data and 4 blank ones.