Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 71
Default Horizontal (Category) Axis

How do I change the horizontal (category) axis so that the text in that area
is at a horizontal angle?
--
Maria A Adams
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Horizontal (Category) Axis

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



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 71
Default Horizontal (Category) Axis

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

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




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Horizontal (Category) Axis

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" wrote in message
...
Forgive for this question, but where on earth is the Orientation on the
Alignment tab of the Format Axis dialog?
Maria

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






  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 71
Default Horizontal (Category) Axis

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






  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Horizontal (Category) Axis

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






  #7   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 71
Default Horizontal (Category) Axis

Thank you so much Jon
--
Maria A Adams


"Jon Peltier" wrote:

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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get multilevel category labels to appear horizontal? Chart help needed Charts and Charting in Excel 2 May 29th 13 05:13 AM
How to put a NAME in the Horizontal category axis label. Feejo Excel Discussion (Misc queries) 1 January 11th 08 12:42 PM
How do I set up horizontal category labels to wrap in ctg space? kaa_63[_2_] Charts and Charting in Excel 4 January 8th 08 05:38 PM
Horizontal category axis all packed together. Feejo Excel Discussion (Misc queries) 3 January 7th 08 10:26 PM
Adding data on Axis Major Gridlines next to Category Axis Collums jblittlejohn New Users to Excel 0 July 10th 05 12:17 PM


All times are GMT +1. The time now is 07:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"