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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top