I have a chart embedded on a sheet and have named ranges that are plotted on
the chart. I would like for the user to be able to use a UserForm to select
the data series on the chart. I recorded this macro to try and learn the
code necessary. I have assigned it to a checkbox control, but don't know
how to hide or unhide the data when the box is checked/unchecked. Below is
the code. I would like the Row selection based on the "Name" to either be
hidden or visible. I will assign each checkbox to the series of data that
will be include on the chart.

Joel




Sub RemoveEarly()
'
Application.Goto Reference:="TARGETEARLY"
Selection.EntireRow.Hidden = True
End Sub