Using (Spinner? ) to control Graph

[applebyd]

Morning all,

Title Should say it all.

I've had a good hunt using various combos of spinner and graph
in the search functions but....

I have a a data table, dates = rows, data = columns.

I'd like, if possible, to have a spinner control the graph on
the basis that each week is a row of data.

Now I have NO problems getting a spinner to change the
value in a cell but to move up or down a row each time
is proving err.....

AArrghh................

Any help, or suggestions for a different way of attacking it would be
greatly appreciated.

TIA

daveA

 

[cornflakegirl]

It sounds like you should be using VLOOKUP. Is there a reason why that wouldn't work?