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