Auto-wrap titles on horizontal axis??
I have 27 identically sized charts that I created in Excel 2007. All
but 2 of them auto-wrapped the x-axis titles correctly. On the two bad charts the titles overrun each other. How the heck can I get these 2 misfits to conform? I can't find the setting on the Format Axis options and the Wrap Text button (under Home Alignment) is grayed out. As far as I can see, there is no difference in any chart settings between the good charts and the bad one. |
Auto-wrap titles on horizontal axis??
Nevermind...I fixed it myself. Weird. It's just seems to be a sizing
issue. I may need to enlarge the rest of the charts or play around with the chart area some more, but I think I am on the right track. Changing to a smaller font works too, but of course that looks bad when it's right next to another chart with larger axis labels. On Jul 11, 5:03*pm, wrote: I have 27 identically sized charts that I created in Excel 2007. *All but 2 of them auto-wrapped the x-axis titles correctly. *On the two bad charts the titles overrun each other. How the heck can I get these 2 misfits to conform? I can't find the setting on the Format Axis options and the Wrap Text button (under Home Alignment) is grayed out. As far as I can see, there is no difference in any chart settings between the good charts and the bad one. |
Auto-wrap titles on horizontal axis??
Shrinking the font by 0.5 point size worked for me
|
All times are GMT +1. The time now is 07:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com