pie chart legends

[shlomi_weiss]

Hi all

I have a pie chart in xcelsius 5.3 and the labels have long text.

I want to have the labels at the bottom of the chart in order to preserve space for the chart it self.

My problem is that I can only have all legends in one line and it's not enough to see all of them.

Is there a way to wrap the legends or format them in several lines?

Regards

Shlomi Weiss

[Former Member · Accepted solution]

HI,

Yes, we can do some tricks to get it. Use one background component for chart and uncheck the background option in chart. Assign data to chart i mean only values not labels. Also uncheck the legend in chart. Now you can use no of check box's for labels. Example if you have 7 labels then you can use 7 check box's. Align in the bottom of the chart. The same colors of the pie chart need to set for 7 check box's for both checked & unchecked. Now give the labels for check box's as a title.

For reference:

http://analysis-reporting.blogspot.com/2009/06/formatting-tricks-2.html

Regards,

Senthil K

[Former Member]

Hi,

You can truncate the length of the labels dynamically by building some excel-formula's:

1) calculate the lenght of each individual original label with the len-function

2) calculate the total lenght of all labels together

3) calculate the total numbers of labels

4) define the total possible lenght of chars you have room for underneath your pie (by trial & error)

5) calculate the maximum length you have for each label (result 4 / result 3)

6) evaluate for each label whether the original length > result 5

7) under condition (if-formula), evaluate if the total length (result 2) exceeds the possible length (result 2)

😎 is result 7 is true, then truncate all individual labels for which result 6 is true to the maximum of result 5 by using the instr-function and don't truncate the labels for which result 6 is false

9) use these results (the excel-cells) as input for the pie-labels and voila!

Greetings Erik-Jan

[Former Member]

Silly enough: no. Unless you are good with paint