Horizontal (Category) Axis

[maria]

How do I change the horizontal (category) axis so that the text in that area
is at a horizontal angle?

 

[Jon Peltier]

Orientation on the Alignment tab of the Format Axis dialog.

- Jon

 

[maria]

Forgive for this question, but where on earth is the Orientation on the
Alignment tab of the Format Axis dialog?
Maria

 

[Jon Peltier]

Assuming you haven't upgraded to 2007 (the majority still haven't), right
click on the axis and choose Format Axis, click on the Alignment tab, and in
the Orientation group of controls, set the alignment of the labels.

In 2007 it's basically the same thing, though the "tabs" look less like tabs
than they used to.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______

..

 

[maria]

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.

 

[Jon Peltier]

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

 

[maria]

Thank you so much Jon
--
Maria A Adams

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/
_______