PC Review


Reply
Thread Tools Rate Thread

How to add a name column to scatter chart's data label?

 
 
Excel 009
Guest
Posts: n/a
 
      5th Aug 2011
I have the following data and want to create a scatter chart. I am
using either 2003 or 2007.


Person X1 X2
a 2 4
b 8 2
c 9 3
d 1 5
e 8.5 1

(The range is =Sheet1!$A$1:$C$6)

I want to put the values (a, b, c, d, e) from the Person column next
to the data point. For example, d for the (1,5). The objective is to
put the a, b, c on the data point.

In my last attempt, I set up the series value for X in an
unconventional way – I included the Person column in it - "=Sheet1!$A
$2:$B$6"
But the problem is that X value becomes (a, 2), (b,8).

Can anyone help?

Excel 009
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stacked Column Chart Data Label Connector Lines Erik Microsoft Excel Charting 4 5th Jun 2009 11:55 PM
Showing Percentage Value Data Label in a 100% Stacked Column Chart =?Utf-8?B?Q2xhcmU=?= Microsoft Excel Charting 0 23rd Jul 2007 05:36 PM
text label in x-axis (scatter chart) andy650@gmail.com Microsoft Excel Charting 2 20th Jun 2006 10:48 PM
Percent Data Label on 100% Stacked Column Chart =?Utf-8?B?UE5pY2hvbHM=?= Microsoft Excel Charting 2 13th Jun 2005 01:56 PM
scatter chart data label problem Tom Microsoft Excel Charting 1 12th Aug 2003 09:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:03 AM.