Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
y-axis auto scaling... | Charts and Charting in Excel | |||
Scaling axis | Charts and Charting in Excel | |||
axis scaling | Charts and Charting in Excel | |||
Auto-scaling on Y axis inconsistent | Charts and Charting in Excel | |||
Auto Scaling of Y-axis | Charts and Charting in Excel |