Dynamic Charts

[mark.wolven]

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?

 

[Jon Peltier]

How did you define the dynamic ranges, and how did you incorporate them into
the chart? Dynamic names cannot be used to define the entire source data
range of a chart, only the data ranges containing X values, Y values, and
series names for each individual series.

In Line and XY charts, "" is interpreted as zero. If you use NA() instead,
you get an ugly #N/A error in the sheet, but the cells are not plotted.

- Jon