Do you know how to automatically scale Y axis in Excel graph? Isthere any existing add-ins I can use?I want the Y axis to automatically adjust its min, max and majorunits.
It will automatically adjust these by default when you create a newgraph. You can make this more controllable if you need to, and thisarticle might be a place to start:http://www.grbps.com/Excel2.pdf
I am writing a macro that inputs different data and form one graph,and excel can't automatically adjust it for me.