20 rows but need to display only 2 at a time in a chart.

[Roshlin]

Hi friends,

I have a chart with 20 rows and columns. I need to compare 2 rows at a time
in a simple line chart to see thier progress, for example row 1 with row 5 ,
then 4 with 10 and then 1 with 16 etc.

what would be the easiest way to achive this, for now I have to do it by
selecting the rows each time by edit data.

Can I have 2 dropdown menus above the chart with the column names so that
the chart would display the values I chose.

Thanks for your help.
Roshlin

 

[Roshlin]

Hi Dave,

Thanks for your quick response.
I'm done half way, I have the 2 combo boxes in A23 and A24 and they are
working fine.
I've made the series names with the column A.

where do I put this "the cell link is $A$23, and the dropdown lines is 20."

I get error Name? when I do this "In B23, enter
=OFFSET($A$1,$A$23,COLUMN()-1) "

Thanks for your help