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