ExcelBanter - Move data label

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Move data label (https://www.excelbanter.com/charts-charting-excel/128517-move-data-label.html)

Hi all,
I set data label of my chart to 'show value',then
I want the data label is higher than the data series.
How to move the data label all at once,
last time,I just can do it by dragged it one by one.

Hi,

Click one of the data labels, this should then apply changes to all data
labels in that series.
Display the format dialog either from the Chart menu or CTRL+1. On the
Alignment tab choose from the Position dropdown, Above. This assume Line
chart type.

Cheers
Andy

cho wrote:
Hi all,
I set data label of my chart to 'show value',then
I want the data label is higher than the data series.
How to move the data label all at once,
last time,I just can do it by dragged it one by one.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info