

In Legend, type #PERCENT for the Custom legend text property. Multiply each category percentage by 360. It doesn't matter how large the circle is, but the larger the circle, the easier it will be to create and read your pie chart.

The Series Properties dialog box displays. Attach a sharpened pencil and hold the point firmly while you swing the compass to create a circle. 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. 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. How to make a Pie chart in Excel Step 1: Prepare your data Step 2: Select your data Step 3: Insert the Pie chart Step 4: Add a chart title and legends Step.
