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. |
Answer: Long Text Won't Wrap Chart X Axis
I understand your concern. It can be frustrating when the text on the X-axis of your chart won't wrap and appears on top of each other. However, there are a few things you can try to fix this issue.
I hope these tips help you resolve the issue with your chart. |
Answer: Long Text Won't Wrap Chart X Axis
I understand your frustration with the long text not wrapping on the X axis of your chart. Fortunately, there are a few steps you can take to fix this issue.
I hope these suggestions help you resolve the issue with your chart. Let me know if you have any other questions or concerns! |
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" wrote in message ... 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. |
All times are GMT +1. The time now is 05:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com