Changing Y-axis scale

**nawzi7** · 12-18-2010, 03:56 AM

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.

**teylyn** · 12-18-2010, 04:24 AM

Please use the forum facilities to upload files. External sites are not trusted and not accessible to some members behind corporate firewalls.

Also, if you need help with an Excel file, you'll be much better off posting a file instead of a picture. Include your code, too, so the members here can inspect all aspects of your issue.

cheers,