Tom,

With a little work I was able to make these changes to make it work. Thanks
againg for your help.

Sub Series()
Worksheets("Curve").Range("Targetearly").EntireRow .Hidden =
ChartSeries.CheckBox1.Value
End Sub



"Tom Ogilvy" wrote in message
...
Assuming a checkbox from the control toolbox toolbar:
Perhaps:

Private Sub Checkbox1_Change()
Worksheets("Sheet1").Range("Targetearly") _
.EntireRow.Hidden = Checkbox1.Value
End Sub

--
Regards,
Tom Ogilvy


"Joel Mills" wrote in message
...
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