Display or not display series

I have a graph with four series but some of the series may
be blank, i.e. the series name is blank series. Is
there a way to not display these series on the graph
and/or legend if they are blank, and display them if they
are without deleting the series?

Thanks!

Clay

Create a chart from all the data
Select the data on which the chart is based.
Choose DataFilterAutoFilter
In the heading cell for the series name column, select (NonBlanks)
from the dropdown list
The series with blank name cells will be hidden in the chart.

Clay wrote:
I have a graph with four series but some of the series may
be blank, i.e. the series name is blank series. Is
there a way to not display these series on the graph
and/or legend if they are blank, and display them if they
are without deleting the series?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html