Thread: Removing Empty Series from Legend

This is a new problem with this workbook

http://www.excelforum.com/excel-char...of-series.html

How can I keep the legend from displaying symbols for all those blank series for the x/y scatter (short of deleting them 1 by 1)? I'm open to VBA solutions.

I'm working in Excel 2007. This will be a protected spreadsheet with unprotected data cells. Users will be adding new lines of data which would constitute a new series.

Thanks in advance.

You need to hide the unused rows to remove the series from the chart/legend.

Your VBA code could control the hidden state of the rows in the table.
Leave the file row in the table empty and reveal the next when new lot item is added in column A. You would need worksheet event code for this.


right sheet tab and View Code.

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Range("A6:A203"), Target) Is Nothing Then
        If Len(Target.Value) > 0 Then
            If Target.Offset(1, 0).EntireRow.Hidden Then
                Target.Offset(1, 0).EntireRow.Hidden = False
                Target.Offset(1, 0).Activate
            End If
        End If
    End If
    
End Sub

Works perfectly Andy! Just what I was looking for. Thanks!