Excel Graphs ughhh

SAS

Can't get enough of FH
Joined
Dec 23, 2003
Messages
1,004
After crashing excel many times and even resorting to the paper clip help, I think what I'm about to suggest can't be done, although I am no excel whiz so probably just missing something obvious :(

Take the image below:

graphproblem.jpg


The scatter graph at work will contain over 1000 + people and the graph shows points plotted over a diagonal trendline. However if I hover over a point it does not displayed the name of the person (in column A). Is there some way to make each point display the name of the person in this way?

Any help would be apperciated :)
 

Jupitus

Old and short, no wonder I'm grumpy!
Staff member
Moderator
FH Subscriber
Joined
Dec 14, 2003
Messages
3,362
check PMs SAS
 

TdC

Trem's hunky sex love muffin
Joined
Dec 20, 2003
Messages
30,925
hmm, if I do a row of names and random numbers, and select both as source for a scattergraph it works.
sequence1, point "andrew" (6; 903)
 

SAS

Can't get enough of FH
Joined
Dec 23, 2003
Messages
1,004
Tried that tdc but the x axis has to be "kph" and the y "tph". :(
 

TdC

Trem's hunky sex love muffin
Joined
Dec 20, 2003
Messages
30,925
aha I see mate. well, that's the limit of my excel know-how :( good luck then!
 

Users who are viewing this thread

Top Bottom