As advised by DonkeyOte, i create a thread that particularly relevant with below thread

http://www.excelforum.com/excel-char...cale-axis.html

where im using that method to manually change my scale.
------------------------------------------------------------------------------------------------

So hear this,

http://www.freeimagehosting.net/uploads/4962285661.jpg

As you can see in the picture above...
I've manage to make a graph of combination of scroll bar and drop down list.
But then i'm having problem with some graph which got some offset data.
So, i took Andy Pope method to change the scale. Then another problem occurred as some graph didn't need to set the y-scale manually. So, i was hoping that i can do some vb @ macro that can change the Y-scale back to auto.