Thread: Move data label
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Move data label

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