Blank Series in Charts

L

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
 
D

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.
 
L

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
 
Top