HI Jacob,
Thanks very much.
Keith

"Jacob Skaria" wrote:

Replace the chartname in the below
Charts("Chartname").SeriesCollection(1).XValues =
Worksheets("Sheet1").Range("C3:C44")
--
If this post helps click Yes
---------------
Jacob Skaria


"keith" wrote:

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

Thanks
Keith