Problem error when creating a chart in VBA

  • Thread starter Thread starter keith
  • Start date Start date
K

keith

Hello,
What would cause the following line...
ActiveChart.SeriesCollection(1).XValues = "=Sheet1!$R4$C3:$R44$C3"
to produce an error number 1004?

Thanks
Keith
 
Replace the chartname in the below
Charts("Chartname").SeriesCollection(1).XValues =
Worksheets("Sheet1").Range("C3:C44")
 
HI Jacob,
Thanks very much.
Keith

Jacob Skaria said:
Replace the chartname in the below
Charts("Chartname").SeriesCollection(1).XValues =
Worksheets("Sheet1").Range("C3:C44")
Click to expand...
 
Back
Top