I want to make a generate chart that will plot a vector field, I know how to plot it and have used the record option to make a program that will run for a set number of vectors, but I would like to allow it to run for a user input number of vectors, here is what I have, and I know its wrong, but I just don't know how to incorporate the "x" variable.

For i = 2 To tracer
x = i + 2
' Add next series
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(2).XValues = "=(Sheet1!RxC2,Sheet1!RxC10)"
ActiveChart.SeriesCollection(2).Values = "=(Sheet1!RxC2,Sheet1!RxC10)"
ActiveChart.SeriesCollection(2).Name = "=""Tracer i"""
Next i

Once again I know how I incorporated "x" is totally wrong but any help would be apprecieted, thanks