I posted earlier about creating a dynamic chart, and I've found lots
of links to tutorials that show you how to move a range - like the 6
recent months, or charts that grow as you add data.

But what about a chart that can get smaller, in theory, this should
work the same, but I am having trouble implementing this. Basically, a
user selects a option from a drop down. Based on their choice, the
data range can be populated 3 different ways, with say 5, 10, or 20
rows of data. With the extra rows being populated by a formula that
leaves behind a "". The problem that I cannot get past, is that the
Chart always displays 20 rows - with extra blank labels and extra zero
values.

Thoughts?

What kind of chart? If it's a line or XY chart, use NA() instead of "" in
your formulas. It leaves an ugly #N/A error in the cells, but the error will
not plot in the chart.

- 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 posted earlier about creating a dynamic chart, and I've found lots
> of links to tutorials that show you how to move a range - like the 6
> recent months, or charts that grow as you add data.
>
> But what about a chart that can get smaller, in theory, this should
> work the same, but I am having trouble implementing this. Basically, a
> user selects a option from a drop down. Based on their choice, the
> data range can be populated 3 different ways, with say 5, 10, or 20
> rows of data. With the extra rows being populated by a formula that
> leaves behind a "". The problem that I cannot get past, is that the
> Chart always displays 20 rows - with extra blank labels and extra zero
> values.
>
> Thoughts?
>