Quality/ Productivity diagram

  • Thread starter Thread starter KrunoG
  • Start date Start date
K

KrunoG

Hi!

I'm trying to make Q/P diagram based on quality and productivity evaluation
of agents in Call Centre where I work.
Therefore I would like to use a scatter chart with the data shown below:

agent quality productivity
john 5 4
mike 4 4
dave 2 5
bob 2 1
bill 3 4
jane 5 5
jill 1 3
adam 2 4
eve 2 4
rich 3 2


I've managed to put the quality on X and productivity on Y but what I'm up
to is to get the agents labeled on those coordinates. So far I only have the
coordinates when click on the marker but I would like to have an agents
names there. Is that possible at all?

Thanks in advance!

Kruno, Croatia
 
Yes, but it entails either manually changing the text of datalabels, writing
your own code to automate the process, or using the ChartLabeler or another
add-in. Excel has no in-built way to apply labels from the worksheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top