ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Angling Label Text on a Chart (https://www.excelbanter.com/charts-charting-excel/231635-angling-label-text-chart.html)

Karen

Angling Label Text on a Chart
 
I have a user with a Multi-Level Category Label on his chart. The label has
the following data:

2 4 6 8
Nov-09 Dec-09 Jan-10 Feb-10

He's wanting the text to be aligned at an angle and so far I'm only able to
get the top values to display at an angle and not both. Any ideas?

--
-Karen

Jon Peltier

Angling Label Text on a Chart
 
Excel does not allow for changing the orientation of lower layers of
multiple level labels.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Karen" wrote in message
...
I have a user with a Multi-Level Category Label on his chart. The label
has
the following data:

2 4 6 8
Nov-09 Dec-09 Jan-10 Feb-10

He's wanting the text to be aligned at an angle and so far I'm only able
to
get the top values to display at an angle and not both. Any ideas?

--
-Karen




Karen

Angling Label Text on a Chart
 
Thanks Jon...after spending too much time on it I came to the same conclusion
so I appreciate the confirmation :-)
--
-Karen


"Jon Peltier" wrote:

Excel does not allow for changing the orientation of lower layers of
multiple level labels.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Karen" wrote in message
...
I have a user with a Multi-Level Category Label on his chart. The label
has
the following data:

2 4 6 8
Nov-09 Dec-09 Jan-10 Feb-10

He's wanting the text to be aligned at an angle and so far I'm only able
to
get the top values to display at an angle and not both. Any ideas?

--
-Karen






All times are GMT +1. The time now is 09:06 AM.

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