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.
To display percentage values as labels on a pie chart
-
Add a pie chart to your report. For more information, see How to: Add a Chart to a Report.
-
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.
-
On the design surface, right-click on the labels and select Series Label Properties. The Series Label Properties dialog box appears.
-
Type #PERCENT for the Label data option.
To display percentage values in the legend of a pie chart
-
On the design surface, right-click on the pie chart and select Series Properties. The Series Properties dialog box displays.
-
In Legend, type #PERCENT for the Custom legend text property.
Tasks
How to: Explode a Single Point on a Pie Chart
How to: Display Data Point Labels Outside a Pie Chart
How to: Collect Small Slices on a Pie Chart
Concepts
Pie Charts
Formatting the Legend on a Chart
Other Resources
Series Properties Dialog Box, Legend
Series Label Properties Dialog Box, General
Help and Information
Getting SQL Server 2008 Assistance