#1   Report Post  
Peter R Knight
 
Posts: n/a
Default Data Labels

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

  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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" wrote in message
...
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
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing thwe width of data labels? Howard Charts and Charting in Excel 2 July 12th 05 07:26 AM
"Bring to Front" Data Labels? Rob Charts and Charting in Excel 2 April 3rd 05 04:59 PM
Is there a way of attaching data labels from a text range to dat. Peter Sailing by Charts and Charting in Excel 3 March 31st 05 02:25 PM
VBA to change size of data labels? Jason Weiss Charts and Charting in Excel 2 March 24th 05 08:24 PM
Using data as data labels cheekymonkey Excel Discussion (Misc queries) 1 February 18th 05 11:07 PM


All times are GMT +1. The time now is 05:56 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"