In Legend, type #PERCENT for the Custom legend text property. The Series Properties dialog box displays. On the design surface, right-click on the pie chart and select Series Properties. To display percentage values in the legend of a pie chart (Optional) To specify how many decimal places the label shows, type '#PERCENT'. The Series Label Properties dialog box appears. On the design surface, right-click on the labels and select Series Label Properties. The data labels should appear within each slice on the pie chart. On the design surface, right-click on the pie and select Show Data Labels. For more information, see Add a Chart to a Report (Report Builder and SSRS). To display percentage values as labels on a pie chartĪdd a pie chart to your report.

After adding a pie chart, you can add a chart title, add data labels. The Tutorial: Add a Pie Chart to Your Report (Report Builder) walks you through adding percentages to pie slices, if you'd like to try this with sample data first. Select the data and go to Insert > Insert Pie Chart > select chart type.

You may also want percentages in the legend or the pie slices themselves. Tip: You can also give your pie chart a different perspective by Rotating a chart. In paginated reports, by default the legend shows categories. Drag the Pie Explosion slider to increase the separation, or enter a number in the percentage box.

Create pie chart in excel percentages