Ignore blank series in legend wthout VBA

eawachte

New Member
Joined
Jan 14, 2011
Messages
29
I have created a chart to show several different output options as a result of the input options. I am able to view 20 different outputs based on my input combinations. On the side of the table i simply have a column where the user can put an "x" and if so the results are plotted. I am able to not plot the options that are not selected with an "x" in my chart, BUT I can not get rid of the series that are not selected to be plotted to disappear from the legend. There is not value in the legend for these series, but the colored line/symbol still shows up in the legend.

Is there a way to do this without using VBA? I am pretty good at certain things in VBA, but charts and such is not one of those items.

Thanks for any help with this!!

GW
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,837
Hi

No, I don't think you can do exactly what you want.

I am able to not plot the options that are not selected with an "x" in my chart,

You don't say how you do it but I guess you have some formulas to hide the data when the "x" is not present. This is not really not to plot, it's more to plot empty series, that's wly you get the entry in the legend box, the series may not have plottable data, but it's there.

Solutions:

- use the autofilter in your source table, filtering by the "x"'s. In this case you are really not including the series without the "x" in the chart and so there will be no entry in the legend box

- use vba. Buid the chart dinamically using only the series with the "x"

The autofilter solution seems the simpler solution.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,943
Messages
5,525,771
Members
409,663
Latest member
littleriver

This Week's Hot Topics

Top