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

No, not at the series level -- well, at least not without VBA
programming.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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

Hi Dave,

Tried a pivot chart?

Ed Ferrero
http://edferrero.m6.net

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