different y-axis auto scaling...
 

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??
--
dh13134

different y-axis auto scaling...
 

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...00906ACNJ.html
_______


"dh13134" wrote in message
...
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??
--
dh13134

different y-axis auto scaling...
 

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


"Jon Peltier" wrote:

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...00906ACNJ.html
_______


"dh13134" wrote in message
...
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??
--
dh13134

different y-axis auto scaling...
 

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...00906ACNJ.html
_______


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


"Jon Peltier" wrote:

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...00906ACNJ.html
_______


"dh13134" wrote in message
...
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??
--
dh13134