smart charts

[Dave Breitenbach]

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

[Tushar Mehta]

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 <BD3A6E79-5F0E-48A0-9657-2CC897FF82B5@microsoft.com>,
DaveBreitenbach@discussions.microsoft.com 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
>

[Ed Ferrero]

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