plotting 2 variables as scatter and naming each point

G

Guest

Can anyone tell me how to plot one variable against another as a scatter
graph and then get the persons name to be written next to each point plotted
on the graph?
 
T

Tushar Mehta

Select the 2 columns for the x and y values and click the Chart Wizard
button. Follow the steps to create a XY Scatter chart. Then, use Rob
Bovey's XY Chartlabeler (www.appspro.com) or John Walkenbach's Chart
Tools (www.j-walk.com) to add the 3rd column as labels. To do this by
hand see Data Labels
http://www.tushar-mehta.com/excel/newsgroups/data_labels/index.html
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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