Is it possible to have a chart's source data cover ten series, but to chart
only the series where values are populated, i.e. if there is no value and
just blank text, it wont be charted?

I'd like the entire chart including the legend to be smart enough to exclude
those series.

is there any way to do this?

Help would be greatly appreciated!

thanks,
Dave