Export (0) Print
Expand All

Position Labels in a Chart (Report Builder and SSRS)

Because each chart type has a different shape, data point labels are placed in an optimal location so as not to interfere on the chart. The default position of the labels depends varies with the chart type:

  • On stacked charts, labels can only be positioned inside the series.

  • On funnel or pyramid charts, labels are placed on the outside in a column.

  • On pie charts, labels are placed inside the individual slices on a pie chart.

  • On bar charts, labels are placed outside of the bars that represent data points.

  • On polar charts, labels are placed outside of the circular area that represents data points.

Note 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 change the position of point labels in a Pie chart

  1. Create a pie chart.

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

  3. Open the Properties pane. On the View tab, click Properties.

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

  5. In the General section, expand the CustomAttributes node. A list of attributes for the pie chart is displayed.

  6. Select a value for the PieLabelStyle property.

To change the position of point labels in a Funnel or Pyramid chart

  1. Create a funnel or pyramid chart.

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

  3. Open the Properties pane. On the View tab, click Properties

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

  5. In the General section, expand the CustomAttributes node. A list of attributes for the funnel chart is displayed.

  6. For a funnel chart, select a value for the FunnelLabelStyle property. For a pyramid chart, select a value for the PyramidLabelStyle property.

    Note Note

    When this property is set to a value OutsideInColumn, the labels are drawn in a vertical column. There is no way to change the position of the column.

To change the position of point labels in a Bar chart

  1. Create a bar chart.

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

  3. Open the Properties pane. On the View tab, click Properties

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

  5. In the General section, expand the CustomAttributes node. A list of attributes for the bar chart is displayed.

  6. Select a value for the BarLabelStyle property.

When the bar label style is set to Outside, the labels will be placed outside of the bar, as long as it fits in the chart area. If the label cannot be placed outside of the bar but inside of the chart area, the label is placed inside the bar at the position closest to the end of the bar.

To change the position of point labels in an Area, Column, Line or Scatter chart

  1. Create an Area, Column, Line or Scatter chart.

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

  3. Open the Properties pane. On the View tab, click Properties

  4. On the design surface, click the series. The properties for the series are displayed in the Properties pane.

  5. In the Data section, expand the DataPoint node, then expand the Label node.

  6. Select a value for the Position property.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft