show/hide multiple series using named ranges

[goofy11]

I'm trying to create a dynamic chart using named ranges that will not only
expand or collapse based on the data size, but will also dynamically show
varying number of series. I've seen some posts that appear to address this,
but I can't quite make it happen. My data is structured similar to this:

Date (A1) Series1 (B1) Series2 (C1)
6/15/2007 1000 1500
6/16/2007 1200 1550
6/17/2007 1150 1400

Not only could I have varying number of days starting in cell A2 going down,
but I could also have varying number of series. Today I may have two series
to chart, but next time, I could have 5 series. If I initially create my
chart adding many series--say like 20 (more than I'd ever need), and then
only have data for a few series, the chart will only plot a couple of lines
like I want, but the legend will show placeholders for all 20 series. Is
there any way I can create a dynamic chart that will allow me to only show
the number of series with data (and only show these in the legend)?

Lastly, I want to avoid using VBA since this is going to be a downloadable
report from the web.

Any help would be greatly appreciated.

 

[Bob Phillips]

The only way that I can think is if you can force the value #N/A or blanks
into the values in the source. If that is not possible, how ill you
recognise that the series is empty?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)