how do I put a text label on a point in an XY scatter

P

Paul

I am a marketer and I use excel to plot 2 x 2 matricies using x y scatter
graphs but I cannot get the excel to put the text label on the datapoint
 
J

Jon Peltier

select the series, then select the point (two single clicks), then right
click and choose the format option. On the Data Label tab, add any default
label and click OK. Select this label (again, two single clicks), then click
the select the text in the label and type whatever you want.

If you have a lot of points, and the labels are in the worksheet, use one of
these free Excel utilities to add labels in bulk:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- 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