Horizontal Bars Scroll-Bars!

Dear Forum,

I am trying to derive the EMI for a Loan Amount and also chart a PIE graph for the same..

Instead of Manually feeding the values such as :

Variable 1 : Loan Amount : Min : Rs 50,000/- Max :Rs 5000000/-
Each Spin (1 Unit) -Rs 25000/-

Variable 2 : Interest Rate : Min : 5% Max : 30%
Each Spin (1 Unit) -0.25%

Variable 3 : Tenure/Duration : Min : 6 months Max : 30 years
Each Spin (1 Unit) - 6 months

I want to have a Scroll-Bar where the values can change Automatically but am not aware of using the same...

Can someone please help me with a small attachment with the above variables attached to it..The values drawn should be displayed as well above the Scroll-Bar and maybe can make the Min and Max more dynamic by storing it somewhere in the Sheet..

I am looking for Non-VBA solution to do the same..

Thanks
e4excel