Since I will be creating 3 to 4 charts each on different worksheets, is there
a way I can substitue the activechart name and sheet name with variables?
That way I can use the same set of scripts to generate charts for different
worksheets?

Can someone show me how to change this line below to use variable names for
the activechart and sheet?

ActiveChart.SeriesCollection(1).values =
"=(sheet1!R11C7,Sheet1!R13C7,Sheet1!R18C7,Sheet1!R 20C7)"

Thanks,

YH