Display or not display series

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
 
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
The series with blank name cells will be hidden in the chart.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart series select. 3
Overlay line graph points on bar graph 1
Insert Multiple Fields without Dialog closing between each... 0
Dynamic series in rows 1
Display Name of each Data Series 1
Use text descriptors as Y axis units 1
Convert Error Bars to Series and Colour 1
Data points in chart incorrect 0

Top