ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Seperate data set for labels? (https://www.excelbanter.com/charts-charting-excel/162395-seperate-data-set-labels.html)

Lee Suring

Seperate data set for labels?
 
How do you use a different data set for labels than the one which the data is
plotted on the graph with? For example, say you plotted a Distance vs. time,
but you wanted to put the city, state at each of those points? How could you
do this, with XP or Vista please.



David Biddulph[_2_]

Seperate data set for labels?
 
Not a native Excel feature, but these add-ins are the usual recommendations:
Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com


For a small number of points you can do it manually by replacing the label
text of distance or time with your text.
--
David Biddulph

"Lee Suring" <Lee wrote in message
...
How do you use a different data set for labels than the one which the data
is
plotted on the graph with? For example, say you plotted a Distance vs.
time,
but you wanted to put the city, state at each of those points? How could
you
do this, with XP or Vista please.






All times are GMT +1. The time now is 08:05 PM.

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