Active row range from sheet1 to sheet2

Hello,
This may be one of those totally simple things, but I'm teaching myself vba and have been pounding on this problem for days.

In short, sheet2 has a series of graphs that pull data from sheet1 and this all works fine if I set the exact data ranges in my code. But I want to have the data range be columns I through N in the row that contains the active cell on sheet1. I think I have the right idea, but can't seem to make it work.

I have tried many different ways. For instance:

Setting the data series in the first chart using ActiveCell:

.SeriesCollection(1).Values = Worksheets("Sheet1").Range(Cells(ActiveCell.Row, 9), Cells(ActiveCell.Row, 16))

or setting variables:

Dim ar As String ' active row from sheet1
Dim rngData As Range ' Range of user data to be used from sheet1

ar = ActiveCell.Row
Set rngData = Worksheets("Sheet1).Range(Cells(ar, 9), Cells(ar, 16))


or this:

Dim RowNum As Integer ' Active row from sheet 1
Set RowNum = Worksheets("Sheet1").Cells(ActiveCell.Row)

I'm such a beginner! Any ideas?