Problem error when creating a chart in VBA

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
 
J

Jacob Skaria

Replace the chartname in the below
Charts("Chartname").SeriesCollection(1).XValues =
Worksheets("Sheet1").Range("C3:C44")
 
K

keith

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Control 11
Excel Macro for Charts 1
Excel Macro Help for Charts 8
Bubble Chart 1
Unable to set the xvalues property of the series class for a single row of source data 3
Plotting a number of single point series on a scatter graph 2
Runtime Error 1004 Unable to set the XValues property of series cl 2
Run-Time Error 1004 on ActiveChart.SeriesCollection(1).Values = 4

Top