If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can this adjusted GPA formual be accomplised? | Chris Cred via OfficeKB.com | General Discussion | 1 | January 19th, 2006 01:59 PM |
Difficulty in editing block diagram | TechWriter | Visio | 1 | August 24th, 2005 02:08 PM |
Visio corrupting old diagrams when creating new diagram | Daniel Ekengren | Visio | 0 | May 6th, 2005 11:28 AM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
High Quality Block Diagram Stencil | dan | Visio | 2 | May 6th, 2004 05:38 PM |