Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |