PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Auto-wrap titles on horizontal axis??

Reply

Auto-wrap titles on horizontal axis??

 
Thread Tools Rate Thread
Old 11-07-2008, 11:03 PM   #1
wctoomey@gmail.com
Guest
 
Posts: n/a
Default 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.
  Reply With Quote
Old 11-07-2008, 11:18 PM   #2
wctoomey@gmail.com
Guest
 
Posts: n/a
Default Re: 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, wctoo...@gmail.com 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.


  Reply With Quote
Old 11-07-2008, 11:26 PM   #3
wctoomey@gmail.com
Guest
 
Posts: n/a
Default Re: Auto-wrap titles on horizontal axis??

Shrinking the font by 0.5 point size worked for me

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off