Click to Rate and Give Feedback
TechNet
TechNet Library
SQL Server
SQL Server 2008
Reporting Services
Development
 How to: Display Data Point Labels O...

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
SQL Server 2008 Books Online (October 2009)
How to: Display Data Point Labels Outside a Pie Chart

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 points. 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.

  1. Add a pie chart to your report. For more information, see How to: Add a Chart to a Report.

  2. On the design surface, right-click on the chart and select Show Data Labels.

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

  2. Open the Properties pane.

  3. On the design surface, click on the chart. The properties for the chart are displayed in the Properties pane.

  4. In the Misc section, 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.

  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 3D Effects. The Chart Area properties dialog box appears.

  3. Select Enable 3D.

  4. If you want the chart to appear two-dimensional, in 3D Options set the Rotation and Inclination properties to 0.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker