ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Quality/ Productivity diagram (https://www.excelbanter.com/charts-charting-excel/68434-quality-productivity-diagram.html)

KrunoG January 31st 06 10:47 AM

Quality/ Productivity diagram
 
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



KrunoG January 31st 06 11:04 AM

Quality/ Productivity diagram
 
ok, I've made it with the ChartLabeler plug_in.

but is there another way?


"KrunoG" wrote in message
...
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





Jon Peltier January 31st 06 05:55 PM

Quality/ Productivity diagram
 
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/
_______


"KrunoG" wrote in message
...
ok, I've made it with the ChartLabeler plug_in.

but is there another way?


"KrunoG" wrote in message
...
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








All times are GMT +1. The time now is 12:48 AM.

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