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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()