Display Data Point Labels Outside a Pie Chart (Report Builder and SSRS)

  • Article

In Reporting Services, pie chart labeling is optimized to display labels on only several slices of data. Labels may overlap if the pie chart contains too many slices. One solution is to display the labels outside the pie chart, which may create more room for longer data labels. If you find that your labels still overlap, you can create more space for them by enabling 3D. This reduces the diameter of the pie chart, creating more space around the chart.

Note

You can create and modify report definitions (.rdl) 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. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

To display data point labels inside 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 chart and select Show Data Labels.

To display data point labels outside a pie chart

  1. Create a pie chart and display the data labels.

  2. Open the Properties pane.

  3. On the design surface, click on the pie itself to display the Category properties in the Properties pane.

  4. Expand the CustomAttributes node. A list of attributes for the pie chart is displayed.

  5. Set the PieLabelStyle property to Outside.

  6. Set the PieLineColor property to Black. The PieLineColor property defines callout lines for each data point label.

To prevent overlapping labels displayed outside a pie chart

  1. Create a pie chart with external labels.

  2. On the design surface, right-click outside the pie chart but inside the chart borders and select Chart Area Properties.The Chart AreaProperties dialog box appears.

  3. On the 3D Options tab, select Enable 3D.

  4. If you want the chart to have more room for labels but still appear two-dimensional, set the Rotation and Inclination properties to 0.

See Also

Pie Charts (Report Builder and SSRS)
Collect Small Slices on a Pie Chart (Report Builder and SSRS)
Display Percentage Values on a Pie Chart (Report Builder and SSRS)