If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Scratter Plot Problem
Hello, I am facing a problem about charting in Excel. I have a table as below rank name Xvalue Yvalue 1 Aron 10 20 2 Bran 10 30 3 Keny 20 40 4 Sally 30 60 I want to plot a graph of Yvalue against Xvalue, and at each data point, it need to show the respective rank and name, i.e. at data pt. (10,20), '1 Aron' should be show on the point. So how can I do it. -- hurriance ------------------------------------------------------------------------ hurriance's Profile: http://www.excelforum.com/member.php...o&userid=30882 View this thread: http://www.excelforum.com/showthread...hreadid=510962 |
#2
|
|||
|
|||
Scratter Plot Problem
Hi,
You can do this by linking the data label to a cell. Rob Bovey's free addin will make the process very easy. http://www.appspro.com/Utilities/ChartLabeler.htm Cheers Andy hurriance wrote: Hello, I am facing a problem about charting in Excel. I have a table as below rank name Xvalue Yvalue 1 Aron 10 20 2 Bran 10 30 3 Keny 20 40 4 Sally 30 60 I want to plot a graph of Yvalue against Xvalue, and at each data point, it need to show the respective rank and name, i.e. at data pt. (10,20), '1 Aron' should be show on the point. So how can I do it. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem Retrieving Printer Object Information | Beverly R | Setting Up & Running Reports | 2 | May 16th, 2005 06:02 PM |
Office XP Update Problem | Bill | General Discussions | 0 | December 1st, 2004 06:11 PM |
Problem with display of header in Word 2003 | Padser | Page Layout | 0 | October 8th, 2004 07:47 AM |
Big Problem. We need the fix | Captain K | Calendar | 0 | July 8th, 2004 04:50 PM |
Is it possible to plot 3 surfaces in a Pivot Chart? (Repost) | Alison | Charts and Charting | 5 | October 21st, 2003 11:00 PM |