Here is what I am trying to accomplish.

I want one controlling cell in my spreadsheet where I manually write a
number from 1 to 10.

The spreadsheet has 10 rows with data for 10 variables for different dates
(different columns in the table). When I write say number 6 in the
controlling cell, The simple XY chart in my spreadsheet should take values
from row number 6 and update the plot. The data in row 6 is obviously the Y
variable. The X variable is the date variables which are mentioned in the
same common row for all the 10 variables. Basically I should be able to step
thru the 10 different data sets without having to plot 10 different plots.
Is there any way of doing this in Excel?