The one time that that can happen is if all the cells in the specified range
are empty.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"Robert Baer" wrote:

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".