Syntax for labeling title and series in chart with macro

[Cathy L]

I wrote a macro to create several charts using different cells. My issue
comes with labeling each individual chart and each series according to their
respective cell.
Ex:

ActiveChart.SeriesCollection(1).Name = "='Sec 9'!R5C2"

ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="='Range(Cells(4, j))"

- I want these to be variable according to respective cells.

Thanks,
Cathy