center data labels on my column chart

D

Dan

How do i get my data labels to appear in the center of
each column on my chart? Thanks.
 
D

Debra Dalgleish

Click on one of the labels
(that will select all the labels in the series)
Choose Format>Selected Data Labels
Select the Alignment tab
From the Label Position dropdown, choose Center


Immediately after formatting the first series,
if there are other series in the chart --
Select a label in another series
Press the F4 button on the keyboard, to repeat the
formatting from the previous series
Repeat for all series
 
Top