Export (0) Print
Expand All

Display Percentage Values on a Pie Chart (Report Builder and SSRS)


Applies To: SQL Server 2016

By default, categories are shown in the legend to identify each value. If you have labeled the pie chart using category labels, you may want show percentages in the legend.

System_CAPS_ICON_note.jpg Note

You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items.

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}".

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.

Pie Charts (Report Builder and SSRS)
Formatting the Legend on a Chart (Report Builder and SSRS)
Display Data Point Labels Outside a Pie Chart (Report Builder and SSRS)
Collect Small Slices on a Pie Chart (Report Builder and SSRS)

Community Additions

© 2016 Microsoft