PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Long Text Won't Wrap Chart X Axis

Reply

Long Text Won't Wrap Chart X Axis

 
Thread Tools Rate Thread
Old 07-07-2008, 01:13 AM   #1
RoArmstrong
Guest
 
Posts: n/a
Default Long Text Won't Wrap Chart X Axis


I have a line chart with long question text that I want to use in the X axis
but the text is appears over the top of each other. I have to use this type
of chart because that is how the client wants it.
  Reply With Quote
Old 07-07-2008, 01:22 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: Long Text Won't Wrap Chart X Axis

If you have clients, you are a consultant. Advise them that a line chart may
not be the best choice. A bar chart may work better with the labels.

However, some clients are stubborn. You can manually insert line breaks into
the cell text using Alt+Enter, and these will carry into the chart axis
labels. This isn't perfect, of course, and at times I've resorted to using
other text elements (text boxes or data labels) in place of axis tick
labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RoArmstrong" <RoArmstrong@discussions.microsoft.com> wrote in message
news:3E46B01B-D43A-40F2-8FF2-C9437691BDE7@microsoft.com...
>I have a line chart with long question text that I want to use in the X
>axis
> but the text is appears over the top of each other. I have to use this
> type
> of chart because that is how the client wants it.



  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