I have not used scrollbar in excel much.
I have these data in my sheet1, Days column has data for days 1 to 365 and
Load column has numbers between 1 to 100.
I want to use scroll bar in such a way tha if i want Load number say 90 then
it should take all the value from Load which is less than or equal to 90 and
change chart according to that. In my chart i have days value on x -axis and
Load values of Y axis.
Day Load
1 45
2 50
3 90
.. .
.. 80
365 .

I have tried using scroll bar but it is not changing the chart the way i
want so must be i am doing soemthing worng . so not getting idea for what i
want to do.

Any advice, as always, is greatly appreciated.