Wednesday 26 June 2013

How To display percentage values as labels on a pie chart

To display percentage values as labels on a pie chart

This may sound simple but its not obvious when you try to do it in SSRS, basically to add the percentage values you need to do this

1. Add a pie chart to your report.

2. Right-click on the pie and select Show Data Labels. The data labels should appear within each slice on the pie chart.

3. Right-click on the labels and select Series Label Properties.

4. Type #PERCENT for the Label data option.

5. (Optional) To specify how many decimal places the label shows, type "#PERCENT{Pn}" where n is the number of decimal places to display. For example, to display no decimal places, type "#PERCENT{P0}".


To display percentage values in the legend of a pie chart

1. Right-click on the pie chart and select Series Properties.

2. In Legend, type #PERCENT for the Custom legend text property.

No comments:

Post a Comment

ADFS Timeout on Server 2012 for CRM 2011

This follows on from this Microsoft Guide http://social.technet.microsoft.com/wiki/contents/articles/7681.setting-the-adfs-timeout-for-crm...