PDA

View Full Version : Solved: Select chart series with option button



maccy
03-19-2009, 03:38 AM
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
03-19-2009, 04:50 AM
This code toggles it bewteen hidden and not. I used a line chart



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

maccy
03-19-2009, 05:35 AM
Excellent,

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