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!

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

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