Dynamic label placement for Pie charts based on value
I'm using Report Builder 3.0. I'm wondering if it is possible to have an expression on the "PieLableStyle" property that will allow small slices of a pie chart (like those less than 10%) to have their labels on the outside but those that are larger to have it inside. Here's an example from excel of what I would want it to theoretically look like in my Report Builder report:
July 17th, 2012 3:44pm

Hi There Thanks for your posting. You will be able to do this. Please click on the Pie char label and go to properties and find the position property of label and put something like this =iif((sum(Fields!Rev_Ytd_Actual.Value)/Sum(Fields!Rev_Ytd_Actual.Value, "DataSet1")) >0.10,"Auto","Outside") =iif((sum(Fields!Rev_Ytd_Actual.Value)/Sum(Fields!Rev_Ytd_Actual.Value, "DataSet1")) >0.10,"Auto","Outside") you can put instead of Auto Center or Left or Right I hope this will help I am putting screenshot for your help Many thanks Syed Qazafi Anjum
Free Windows Admin Tool Kit Click here and download it now
July 17th, 2012 7:33pm

Ah-ha - got it to work! Though it took some messing around to get it to as the data I have doesn't quite work with the example given. Here's what I did for mine (I have categories that I'm counting the number of and then displaying the #percent): =iif(count(Fields!PRCategory.Value) > 10, "Auto", "Outside") Now I need to fidget with the sizes to get it more readable. Thanks for the help! Note for others - I had a heck of a time finding that "Position" property as I was looking under the graph settings. Its actually under the Chart Series Labels - click on the data labels and it will be under Appearance.
July 18th, 2012 12:31pm

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

Other recent topics Other recent topics