Dynamic Charts
 

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?

Dynamic Charts
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
ps.com...
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?