ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data Labels (https://www.excelbanter.com/charts-charting-excel/47152-data-labels.html)

Peter R Knight

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


Jon Peltier

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





All times are GMT +1. The time now is 10:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com