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?

Hi,

If I understand your question correctly then I think that you should use
AutoFilter to produce your results. (Check Help for more info on AutoFilter.)

Use the dates as column headers and insert the data in the 10 rows under the
headers. Add an additional header called Selection. In the Selection column
insert your numbers 1 to 10. Then click on any single cell in the range and
then Autofilter.

Now select all your date headers and data (leave out the selection column)
and create your chart with all the data. You will see a chart with multiple
series for the 10 rows of data. Click on the drop down arrow against
Selection header and select the individual row required and you have your
chart with just the selected series.

Regards,

OssieMac



"ABCD" wrote:

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?