C
cate
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.
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.