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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics