Blank Series in Charts

[lorcanjc25]

I want to create a chart with 25 different seies'.

The problem is that some of the series will be blank sometime. But I d
not want to include all of the series' all of the time.
The data will be present at all times.

I have worked out how to make excel ignore the data for the series. Th
problem is that I end up with 25 series in my legend when only 4-5 ma
be on the graph.

Can anyone help me with this?

Many thanks in advanc

 

[Debra Dalgleish]

Create a chart from all the data
Select the data on which the chart is based.
Choose Data>Filter>AutoFilter
In the heading cell for the series name column, select (NonBlanks)
from the dropdown list (it's at the bottom of the list)
The series with blank name cells will be hidden in the chart.

 

[lorcanjc25]

Please help I just can't figure this ou

 

[lorcanjc25]

The problem is that I want to completely exclude some of the series.
This is done by selecting a check box beside the data serie

 

[Debra Dalgleish]

Link each check box to the cell on which it sits.
Filter that column for Blanks.

Or, use one of the techniques described by Jon Peltier:

http://www.peltiertech.com/Excel/Charts/ChartByControl.html