different y-axis auto scaling...

[dh13134]

prior to excel 2007, i recall a setting for the y-axis, something like "Major
Unit" and "Minor Unit" - i could set my y-axis to be 0,5,10,15,20.... or
0,10,20...depending on the Major or Minor unit values. is that ability still
in excel 2007??

 

[Jon Peltier]

Of course. Right click the axis, choose Format Axis, and on the first view
of the dialog, up near the top, are the boxes to edit axis scale parameters.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

 

[dh13134]

DUH.... i've looked at that section SOOOO many times and it was right in
front of me!! thanks (and sorry!)

 

[Jon Peltier]

That new interface confuses a lot of people.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______