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
_______
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>
Similar Threads
