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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.