smart charts

D

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
 
T

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
 

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

Similar Threads

Convert Error Bars to Series and Colour 1
One extra x axis item that wont go away - can anyone help? 3
User Selectable Series and Number of Series for Line Chart 2
I can get line chart to ignore zeros but the legend still contains 3
Stacked Bar Chart 1
Macro to change position of chart labels on line chart 1
XL2007: stock chart- difficulty adding additional series 1
Employee Schedule not plotting properly - chart type / data series not correct 0

Top