Macro to enable/disable chart series

[lazerboi64]

Greetings:

Running Excel 2013. I have created an x-y scatter chart with a dozen-plus series to show time evolution of my data. I can right-click on the chart, select "Select Data" and manually check and uncheck the appropriate series. However, it's time consuming to go through the repetition when you're trying to see small changes. I would like to have macros linked to check boxes in the sheet to directly enable/disable the appropriate series. I've tried to do this via the macro recorder, but it doesn't record anything after right-clicking on the chart. All I get is the following:

Sub Select_dataset()
'
' Select_dataset Macro
'

'
ActiveSheet.ChartObjects("Chart 3").Activate
ActiveChart.PlotArea.Select
End Sub

Sub Deselect_dataset()
'
' Deselect_dataset Macro
'

'
ActiveSheet.ChartObjects("Chart 3").Activate
ActiveChart.PlotArea.Select
End Sub

Any help would be greatly appreciated!! Thanks in advance!

 

[Domenic]

You can use the IsFiltered property of the Series object to hide a series. For example, to hide Series 2...

ActiveSheet.ChartObjects("Chart 3").Chart.FullSeriesCollection(2).IsFiltered = True

or

ActiveChart.FullSeriesCollection(2).IsFiltered = True

And, of course, to unhide a series, set the IsFiltered property to False.

Hope this helps!

 

[lazerboi64]

Thanks! I'll give an update tomorrow when I can try this out tomorrow at work!

 

[lazerboi64]

Just tried the abbreviated version and it works like a charm. Now I just need to add some logic to toggle the filtered state so that it follows the check box. Thanks once again!

 

[Erni76]

I have tried and learned that you also can refer to the series by its name. Example:

ActiveSheet.ChartObjects("Chart 3").Chart.FullSeriesCollection("Sales").IsFiltered = True

 

[lazerboi64]

I have tried and learned that you also can refer to the series by its name. Example:

ActiveSheet.ChartObjects("Chart 3").Chart.FullSeriesCollection("Sales").IsFiltered = True

I believe I do that. In my case they're "Chart_Purple", "Chart_Yellow", etc.