Cannot change Series references
Tushar Mehta wrote:
See the comments to your other similar post. Also, I have no problems with
code like
ActiveChart.SeriesCollection(1).Values = "=charts!$A$1:$A$3"
or
With ActiveSheet.ChartObjects
.Item(.Count).Chart.SeriesCollection(1).Values = "=charts!$L$2:$N$2"
End With
Well in my code, the code
Series_1 = "='#of wells'!$C$" + RowLoc + ":$BQ$" + RowLoc
ActiveChart.SeriesCollection(1).Values = Series_1
is equivalent (same as)
ActiveChart.SeriesCollection(1).Values = "='#of wells'!$C$45:$BQ45"
which appears to be what you show.
Error message: "Unable to set the Values property of te Series clause".
|