Another problem with changeing a graph

  • Thread starter Thread starter Mark Scholes
  • Start date Start date
M

Mark Scholes

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
 
Back
Top