Hi,

I used this code so I don't need to know the name of the
graph.

Sheets("Graph Book").Select
ActiveChart.Select
ActiveChart.SeriesCollection(1).XValues = Sheets
("Graph Data").Range("B1:IU1")

now I get this error
Unable to set the XValues property of the Series class

What kind of a chart is it?

Is there a worksheet named Graph Data?

What does B1:IU1 contain?

What kind of a sheet is Graph Book? How do you avoid knowing the name
of the chart?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi,

I used this code so I don't need to know the name of the
graph.

Sheets("Graph Book").Select
ActiveChart.Select
ActiveChart.SeriesCollection(1).XValues = Sheets
("Graph Data").Range("B1:IU1")

now I get this error
Unable to set the XValues property of the Series class