Chart graphs that automatically change depending on the subject

This would be (relatively) easy if the 4 types were the series, and the scores for a type the series values.

The problem here (if I understand it correctly!) is that the series of the chart are the family members, so the number of series varies. In the example, the series for brother1 and brother4 should be removed.

The number of data points for each series is fixed: the scores for each of the 4 types.

We can solve it by creating a Worksheet_Change event procedure:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim i As Long
    If Not Intersect(Range("B2:K5"), Target) Is Nothing Then
        Application.ScreenUpdating = False
        With Me.ChartObjects(1).Chart
            ' Delete the existing series
            For i = .SeriesCollection.Count To 1 Step -1
                .SeriesCollection(i).Delete
            Next i
            ' Add series for non-blank columns
            For i = 2 To 11
                If Cells(2, i).Value <> "" Then
                    .SeriesCollection.Add _
                        Source:=Cells(1, i).Resize(5), _
                        SeriesLabels:=True
                End If
            Next i
            ' We must specify the category labels again
            .FullSeriesCollection(1).XValues = Range("A2:A5")
        End With
        Application.ScreenUpdating = True
    End If
End Sub

See the attached demo workbook (I hope it will not be removed by the forum software).