PC Review


Reply
 
 
=?Utf-8?B?UGV0ZXIgUiBLbmlnaHQ=?=
Guest
Posts: n/a
 
      26th Sep 2005
hi,
is it possible to lable data points on a scatter chart not with the x or y
values but with a thrid column from the spreadsheet. e.g. the following
example, time is plotted on the x axis and value on the y and I'd like the
data points labeled a,b,c ...

label time value
a 1 1
b 2 4
c 3 9
d 4 16
e 5 25
f 6 36
g 7 49
h 8 64
i 9 81
j 10 100
k 11 121
l 12 144
m 13 169

 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      26th Sep 2005
Peter -

Use one of these third party Excel add-ins to assign another column as data
labels to a series in a chart. Both are free, and easy to install and use:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com/ss

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Peter R Knight" <(E-Mail Removed)> wrote in message
news:5ECECA81-BF2E-4D50-82F8-(E-Mail Removed)...
> hi,
> is it possible to lable data points on a scatter chart not with the x or y
> values but with a thrid column from the spreadsheet. e.g. the following
> example, time is plotted on the x axis and value on the y and I'd like the
> data points labeled a,b,c ...
>
> label time value
> a 1 1
> b 2 4
> c 3 9
> d 4 16
> e 5 25
> f 6 36
> g 7 49
> h 8 64
> i 9 81
> j 10 100
> k 11 121
> l 12 144
> m 13 169
>



 
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
Data Labels- POssible to show data value and data label together? kippers Microsoft Excel Charting 1 1st Apr 2009 01:33 PM
is it possible that the data values shown on the data labels be in a duifferent range tweety127 Microsoft Excel Programming 0 7th Jun 2006 10:16 PM
Setting hover data labels to cells other than source data =?Utf-8?B?RGFycmVu?= Microsoft Excel Charting 1 24th Jan 2006 10:20 AM
Setting hover data labels to cells other than source data =?Utf-8?B?RGFycmVu?= Microsoft Excel Misc 0 24th Jan 2006 08:31 AM
Data Labels/Axis Labels Jane Microsoft Excel Charting 5 31st Mar 2004 04:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:34 AM.