Hi:
I use something like this:

ActiveChart.SeriesCollection(1).XValues = "=Data!R" & InitialRow &
"C" & Col & ":R" & EndRow & "C" & Col

Hope this help