
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 Click on the pie to select the whole pie. (Optional) To specify how many decimal places the label shows, type "#PERCENT". To do this, you have to click on the Chart Elements icon, select the Legend option, and finally select the Right option. On the Insert tab, in the Charts group, click the Pie symbol. Share Follow answered at 14:13 Rory 32. The Series Label Properties dialog box appears. 1 Assuming by 'pivot cake' you mean a pie chart ( shudder ), you can simply add datalabels to the chart and then format them to display the percentage. 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. 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. You may also want percentages in the legend or the pie slices themselves.

In paginated reports, by default the legend shows categories.
