Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to automatically scale Y axis in Excel graph?

  Asked By: Ronnie    Date: Feb 06    Category: MS Office    Views: 6114
  

Do you know how to automatically scale Y axis in Excel graph? Is
there any existing add-ins I can use?

I want the Y axis to automatically adjust its min, max and major
units.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Fedde Bakker     Answered On: Feb 06

It will automatically  adjust these by default when you create a new
graph. You can make this more controllable if you need to, and this
article might be a place to start:

http://www.grbps.com/Excel2.pdf

 
Answer #2    Answered By: Taylor White     Answered On: Feb 06

I am writing a macro that inputs different data and form one graph,
and excel  can't automatically  adjust it for me.

 
Didn't find what you were looking for? Find more on How to automatically scale Y axis in Excel graph? Or get search suggestion and latest updates.




Tagged: