Hi Ryan,

You are correct that the column gaps are held when using #NA, or "". Unfortunately q felt said, 'No I want thegap to go as well.'

For a column chart #NA and "" act the same, assuming the axis crossing point is zero.

The only way to get the legend and column gaps to work is to remove the series.
You can do this via code or via hiding cells.

If you set the chart data to use range H4:J8 and use event code on the data validation cells B3:D3 then this will work.

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Range("B3:D3"), Target) Is Nothing Then
        Columns(Target.Column + 6).Hidden = Not (Target.Value = "Yes")
    End If
End Sub