I'm trying to create a loop to generate a new chart for each column in a
spreadsheet. Macro recorder creates code like this, which I want to change
to the indexed cell format:

ActiveChart.SeriesCollection(1).XValues = "=Data!R3C4:R14C4"

I've tried this, but it doesn't seem to work:

ActiveChart.SeriesCollection(1).XValues = Worksheets("Data").Range(Cells(3,
1), Cells(3, 14))