Solved: Select chart series with option button

[maccy]

I have a large table of data with similar values I would like to chart but it looks too busy.

Is there a way of using option buttons to select which data series I want to chart?

[Bob Phillips]

This code toggles it bewteen hidden and not. I used a line chart

[vba]

Public Function Series1()
With ActiveSheet.ChartObjects("Chart 2").Chart

With .SeriesCollection(2)
.Border.LineStyle = IIf(.Border.LineStyle = xlNone, xlContinuous, xlNone)
.MarkerStyle = IIf(.MarkerStyle = xlNone, xlAutomatic, xlNone)
.Smooth = False
End With
End With
End Function
[/vba]

[maccy]

Excellent,

Thanks for this. I found it works best with check boxes for multiple data series but works a treat