ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   set text direction for multi-level category labels (https://www.excelbanter.com/charts-charting-excel/143901-set-text-direction-multi-level-category-labels.html)

kaa_63

set text direction for multi-level category labels
 
Hi,

I am using excel 2007 and have to build a bar chart comparing values in two
years (years is first category) for a list of statements (statements are the
second category - for each statement, there are 2 values, one for each year).

No problem building the chart, but category labels are not as I wish...
years appears horizontally - this is ok - but statements are 270 degrees
rotated, and no command found to put them horizontally, too.

Please let me know if there is a chance to resolve it! Thanks!

e m

multi level label problem
 
does anyone have an answer to this, I'm having a problem getting text to run horizontal...



kaa_6 wrote:

set text direction for multi-level category labels
23-May-07

Hi,

I am using excel 2007 and have to build a bar chart comparing values in two
years (years is first category) for a list of statements (statements are the
second category - for each statement, there are 2 values, one for each year).

No problem building the chart, but category labels are not as I wish...
years appears horizontally - this is ok - but statements are 270 degrees
rotated, and no command found to put them horizontally, too.

Please let me know if there is a chance to resolve it! Thanks!

Previous Posts In This Thread:

On Wednesday, May 23, 2007 4:08 PM
kaa_6 wrote:

set text direction for multi-level category labels
Hi,

I am using excel 2007 and have to build a bar chart comparing values in two
years (years is first category) for a list of statements (statements are the
second category - for each statement, there are 2 values, one for each year).

No problem building the chart, but category labels are not as I wish...
years appears horizontally - this is ok - but statements are 270 degrees
rotated, and no command found to put them horizontally, too.

Please let me know if there is a chance to resolve it! Thanks!

EggHeadCafe - Software Developer Portal of Choice
Performance Testing .NET Web Apps [MSPRESS]
http://www.eggheadcafe.com/tutorials...sting-net.aspx

Herbert Seidenberg

multi level label problem
 
Excel 2007 PivotChart
Multilevel category labels will orientate horizontally
automatically if text length and font size is
sufficiently small and chart size is
sufficiently large. See:
http://www.mediafire.com/file/wnwmnqmx1wt/11_08_09.xlsx


All times are GMT +1. The time now is 03:56 AM.

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