![]() |
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! |
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 |
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