Text-wrapping horizontal axis labels
Hi,
I've a small problem which I can't seem to find a solution for - I have created a set of financial reports for a client, which includes a number of charts. The charts are waterfall charts, which I've constructed using a form of stacked bar chart. The labels for the horizontal axis are linked to text alongside the calculations for the charts. The text in the labels is of varying lengths and for some of the charts, this text is being wrapped to two layers on the label that appear on the chart. Every now and then, one of the labels is too long, and instead of wrapping to three layers (as I would expect it to) the text is not wrapped at all, on any of the labels, and so simply overlaps all the other labels. I know that lengthening the axis would help, but the size of the graph is standardised so that the reports are visually consistent. Also, I'm reluctant to change the font size of the label for the same reason. A manual carriage return in the cell containing the text for the label will accomplish wrapping to three layers for me, but it would seem to me that there should be a control for text-wrapping on axis labels that I use to change this. Does anyone have any ideas? Thanks, LAird |
Text-wrapping horizontal axis labels
"XXX stubbornly resists any kind of human intervention"
Unfortunately so many elements of Excel charting can complete this sentence. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 3/30/2010 7:35 AM, teylyn wrote: Hi LAird, unfortunately, axis labels stubbornly resist any kind of human intervention when it comes to resizing the label boxes or the wrapping. This has been an annoyance for a long time. cheers, teylyn LAird;684976 Wrote: Hi, I've a small problem which I can't seem to find a solution for - I have created a set of financial reports for a client, which includes a number of charts. The charts are waterfall charts, which I've constructed using a form of stacked bar chart. The labels for the horizontal axis are linked to text alongside the calculations for the charts. The text in the labels is of varying lengths and for some of the charts, this text is being wrapped to two layers on the label that appear on the chart. Every now and then, one of the labels is too long, and instead of wrapping to three layers (as I would expect it to) the text is not wrapped at all, on any of the labels, and so simply overlaps all the other labels. I know that lengthening the axis would help, but the size of the graph is standardised so that the reports are visually consistent. Also, I'm reluctant to change the font size of the label for the same reason. A manual carriage return in the cell containing the text for the label will accomplish wrapping to three layers for me, but it would seem to me that there should be a control for text-wrapping on axis labels that I use to change this. Does anyone have any ideas? Thanks, LAird |
All times are GMT +1. The time now is 01:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com