PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Long Text Won't Wrap Chart X Axis
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Long Text Won't Wrap Chart X Axis
![]() |
Long Text Won't Wrap Chart X Axis |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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. |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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. |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

