Update chart based on user input

Hi.

Im looking to create a graph that will show the current set of data and overwright the privious graph.

Wk 28 7.2 7.85 3.3
Wk 29
Wk 30
Wk 31
Wk 32
Wk 33
Wk 34
Wk 35
Wk 36
Wk 37
Wk 38
Wk 39
Wk 40
Wk 41
Wk 42
Wk 43
Wk 44
Wk 45
Wk 46
Wk 47
Wk 48
Wk 49
Wk 50
Wk 51
Wk 52

So the graph can show week 28 data.
When I type into week 29 the graph updates but only shows week 29.

Can anyone help me

With many thanks in advanced

Das

Thanks.

That Andy Pope is ideal. Would you know how to add additional columns to the data range.


Das

I mail Andy himself and he helped me out.

Here is a working solution to multi scrolling charts.

Thanks Again.

Das