SSRS Pie Chart with Percentages

http://technet.microsoft.com/en-us/library/dd239373.aspx

To display percentage values as labels on a pie chart

  1. Add a pie chart to your report. For more information, see Add a Chart to a Report (Report Builder and SSRS).
  2. On the design surface, right-click on the pie and select Show Data Labels. The data labels should appear within each slice on the pie chart.
  3. On the design surface, right-click on the labels and select Series Label Properties. The Series Label Properties dialog box appears.
  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}”.
  6. On the design surface, right-click on the pie chart and select Series Properties. The Series Properties dialog box displays.
  7. In Legend, type #PERCENT for the Custom legend text property.

To display percentage values in the legend of a pie chart

  1. On the design surface, right-click on the pie chart and select Series Properties. The Series Properties dialog box displays.
  2. In Legend, type #PERCENT for the Custom legend text property.

 

Resources:

http://technet.microsoft.com/en-us/library/dd239373.aspx

Leave a Reply

%d bloggers like this: