Prev: Blank instead of ""
Next: print message
From: LAird on 29 Mar 2010 12:41
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
From: teylyn on 30 Mar 2010 07:35

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



L
A
i
r
d
;
6
8
4
9
7
6

W
r
o
t
e
:


>
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


--
teylyn

Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com)
------------------------------------------------------------------------
teylyn's Profile: 983
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=191426

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Blank instead of ""
Next: print message