ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Horizontal (Category) Axis (https://www.excelbanter.com/charts-charting-excel/226055-horizontal-category-axis.html)

Maria

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

Jon Peltier

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




Maria

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





Jon Peltier

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







Maria

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





Jon Peltier

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







Maria

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








All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com