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 Data>Filter>AutoFilter
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