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.
- Click the chart outside of the data labels that you want to change.
- Click one of the data labels in the series that you want to change.
- On the Format menu, click Selected Data Labels, and then click the Alignment tab.
- In the Label position box, click the location you want.