Changing data markers to text on a xy scatter plot

S

shilpa

Could someone help me figure out how to substitute data markers with
text on a xy scatter plot.
thanks,
shilpa
 
J

Jon Peltier

Shilpa -

You can use Rob Bovey's Chart Labeler (a free addin from
http://appspro.com) or John Walkenbach's Chart Tools (another freebie
from http://j-walk.com) to apply text from a worksheet range to your
datapoints. Use the Centered option for the position of the labels,
then format the series to have no markers and no lines. The labels stay
where the points had been.

- Jon
 

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

Top