Building a chart where any series is added like this

myChart.SeriesCollection(5).Values = "='sheet1'!R63C72:R63C79"

I there a way to scale this, divide each value by X, with some kind
of range collection operation (looked for some array function couldn't
find one), or do I have to touch each cell and recalculate before
defining the SeriesCollection? Thank you.