How to word wrap the Data Labels in a Pie chart?
I am developing an RDL with a pie chart and I show the Data Labels outside this chart. However, because my expression is so long, it is being cutoff currently because all of it has to appear on one line for each group. Is there a way to make
it wrap to the next line to prevent this?Ryan D
October 14th, 2011 12:46pm
Hi Ryan,
The “vbCrlf” code is use to word wrap. How about add the “vbCrlf” into the expression? For example:
=Fields!A.Value & vbCrlf & Fields!B.Value
If this does not solve this issue, please post me the expression in the Pie Chart and a screenshot to show the current result. We’ll work together to solve this issue.
Thanks,
Bin Long
TechNet
Subscriber Supportin
forum
If you have any feedback on our support, please contact
tnmff@microsoft.comPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2011 11:20pm
Thanks Bin. That does work for splitting "A.Value" from "B.Value". But in this case "A.Value" is too long. How do I split this?
Here is a screenshot for just one value; normally there are more values, making this pie chart even more crowded.
Ryan D
October 17th, 2011 6:33pm
Hi ironryan77,
Could you please post me the complete expression for the labels on the 3D-pie chart? If the expression include string and field expression, we can try to use many “vbcrlf” for the expression.
For expression, I write an expression for the “Label” property like this:
=”In-Home Services - Intercept, Reporting Services” & Sum(Fields!MyField.Value)
We can modify the expression like this:
=”In-Hone Services – Intercept,” &vbcrlf & “Reporting Services” & vbcrlf & Sum(Fields!MyField.Value)
Hope this helps.
Thanks,
Bin LongPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
October 24th, 2011 5:53am
Hi ironryan77,
Could you please post me the complete expression for the labels on the 3D-pie chart? If the expression include string and field expression, we can try to use many “vbcrlf” for the expression.
For expression, I write an expression for the “Label” property like this:
=”In-Home Services - Intercept, Reporting Services” & Sum(Fields!MyField.Value)
We can modify the expression like this:
=”In-Hone Services – Intercept,” &vbcrlf & “Reporting Services” & vbcrlf & Sum(Fields!MyField.Value)
Hope this helps.
Thanks,
Bin LongPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
October 24th, 2011 12:52pm