I've seen some of the links here that show 1 method on how to do
dynamic charts. However, that method isn't working for me.

I want the user to select 1 from 3 drill down options - for a metric
dashboard.

Once that is selected, a range is populated.
- for option 1, it is u11:v14
- for option 2, it is u11:v24
- for option 1, it is u11:v30

The way that I have setup the range from U11:v30, is that when Option
1 is selected, the range U15:v30 is blank. There's a formula that
populates it with "".

My problem is that no matter what the selection, my chart wants to
display the full range U11:V30, which in 2 of the 3 scenarios, those
show as Zeros on the chart and the zeros are unlabelled.

Any help?