Display or not display series

  • Thread starter Thread starter Clay
  • Start date Start date
C

Clay

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.
 
Back
Top