If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Horizontal (Category) Axis
I just fired up 2007 to check where this is. Select the axis, press Ctrl+1
(numeral one) to open the Format Axis dialog. Click on Axis Options in the list on the left, if it's not already highlighted. Near the top, under Interval between Labels, change from Automatic to Specify Interval Unit, then change the number in the box to 1. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - Training in Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "Jon Peltier" wrote in message news:... On the main tab of the format axis dialog, there is a place for you to set the number of categories between labels. Change this to 1. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "maria" wrote in message ... Jon, First of all I do have the 2007 version and thank you for assisting me in this matter. Now I have a different problem concerning the same axis. When I try to display the text in a horizontal position I end up loosing one the text labels. -- Maria A Adams "Jon Peltier" wrote: Orientation on the Alignment tab of the Format Axis dialog. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "maria" wrote in message ... How do I change the horizontal (category) axis so that the text in that area is at a horizontal angle? -- Maria A Adams |
Thread Tools | |
Display Modes | |
|
|