Changeing a graph

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

Mark Scholes

Hi,
I want to change a graph dynamicly, so it will graph only
the range of value I which it too.

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

This give a subscript out of range error, how do I fix it.

Thanks MarkS
 
Subscript out of range means one of the names you have in your code does not
exist. Example, you don't have a Chart 1 (maybe you have a Chart1 or it
is no longer named chart 1. )
 
Back
Top