close
Hi,
Set the data markers to none and use data labels instead.
Set the Position of the data label to center.
If the number you want to display is not the x or y value then you can
link the data label to a cell which contains the value you require.
Try either of these free addin to make the linking of cells and data
labels easier.
Rob Bovey's Chart Labeler, appspro.com
John Walkenbach's Chart Tools, j-walk.com
Cheers
Andy
treez wrote:
--
Andy Pope, Microsoft MVP - Excel
www.andypope.info
全站熱搜