set chart range automatically
 

Is there a way to have a chart whose range covers 10 series of data reflect
only the nonerrant(or nonzero) results? I have a qualifier in my source data
which asks whether I'd like to reflect a given series in the chart. A table
is then created which will be the source data for the chart. The only
problem is, the number of series reflected in the table will vary, depending
on how many series I say to reflect.

Is there a way to have the chart's source data cover a range of up to 10
series but only reflect those where there is data, i.e. dont reflect any 0's??

tia,
Dave