set chart range automatically

D

Dave Breitenbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top