can I change data markers to numbers in a scatter chart?

A

Andy Pope

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, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

Cheers
Andy

treez wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - Chart Data Label positions 1
How do I adjust marker spacing in Excel scatter plot? 1
Filtering data for scatter plot with chart labels 2
Excel: using data labels as markers 4
Labeling each data point in scatter chart 2
numbers as markers in XY scatter plot 0
Changing the data label position below the chart axis. 2
Data Labels - I Only Want One 0

Top