A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Text-wrapping horizontal axis labels



 
 
Thread Tools Display Modes
  #1  
Old March 29th, 2010, 05:41 PM posted to microsoft.public.excel.charting
Laird
external usenet poster
 
Posts: 2
Default 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
  #2  
Old March 30th, 2010, 11:53 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default 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



 




Thread Tools
Display Modes

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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.