Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
changing thwe width of data labels? | Charts and Charting in Excel | |||
"Bring to Front" Data Labels? | Charts and Charting in Excel | |||
Is there a way of attaching data labels from a text range to dat. | Charts and Charting in Excel | |||
VBA to change size of data labels? | Charts and Charting in Excel | |||
Using data as data labels | Excel Discussion (Misc queries) |