Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jane
 
Posts: n/a
Default plotting 2 variables as scatter and naming each point

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?
  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

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/ne...els/index.html
--
Regards,

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

In article ,
says...
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"