How do I add buttons on a chartsheet which controls the autofilter on the underlying data?

Hi aab,
You can not add active-x to a chart sheet. But You can use classical combobox, listbox or buttons on chart sheet to get series name. After You know series name to be highlightet (visible), it is very simple to loop through all series and look for exact match and do some formating:

'Dim chrt As Chart
'Dim srs As Series
'Set chrt = ActiveChart
'For Each srs In chrt.SeriesCollection
' If srs.Name = "seriesname" Then
' srs.Format.Line.Weight = 3
' srs.Format.Line.ForeColor.RGB = RGB(r, g, b)
' Else
' srs.Format.Line.Weight = 1
' srs.Format.Line.ForeColor.RGB = RGB(192, 192, 192)
' End If
' Next srs

Hi Miroslav,

Thank you for your reply, much appreciated.

Can you break it down for me further please? Apologies, I am new to VBA!

If you hide rows in the underlying data of a chart, then it also "hides" that series on the chart which you hid in underlying data. I want to add check boxes to then chart sheet which will enable me to control which series I want to select and deselect so the graph doesn't look to congested.

wait a min...
You want a chart on excel worksheet together with source data table? Because this is different situation that I had replied to you earlier.
Only way how to prevent hiding lines in chart when hiding rows is to fill that chart via VBA (chart.seriescollection.newseries). Before tahat, you have to clean the lines in chart. Something like this (I coppied this from my wbk, and you have to arrange it to Your conditions):
CLEANING:

Please Login or Register  to view this content.

GET NEW SERIES NAME AND SOURCE RANGE FROM SHEET (you can put it in a loop or something). 'Ser' and ranges will be assingned according to you selection via button, dropdown etc...:

Please Login or Register  to view this content.

ADDING LINE TO CHART:

Please Login or Register  to view this content.

and I forgot: put "hiding row" procedure below my code... :-)