Change the position of data labels automatically

You can change the position of a single data label by dragging it. Use this procedure to place all labels for a data series in a standard position on their data markers in 2-D bar, column, and line charts; 2-D and 3-D pie charts; and scatter and bubble charts.

  1. Click the chart outside of the data labels that you want to change.

  2. Click one of the data labels in the series that you want to change.

  3. On the Format menu, click Selected Data Labels, and then click the Alignment tab.

  4. In the Label position box, click the location you want.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!