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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×