Horizontal (Category) Axis

  • Thread starter Thread starter maria
  • Start date Start date
M

maria

How do I change the horizontal (category) axis so that the text in that area
is at a horizontal angle?
 
Forgive for this question, but where on earth is the Orientation on the
Alignment tab of the Format Axis dialog?
Maria
 
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/
_______

..
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart templates treates value axis as a category axis 3
Pivot Chart with 2 horizontal axis field (categories) 1
Anchoring Phase Change Lines 1
Restoring Horizontal Axis Labels 1
Horizontal Axis Options Changing 6
Custom EXCEL chart value axis BRAIN TEASER 1
Scatter Plot Chart with Category 3
Time Scales on Horizontal Axis - Excel Charts 1

Back
Top