Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can this adjusted GPA formual be accomplised? | Excel Discussion (Misc queries) | |||
create a userform to populate a diagram with the forms info | Excel Discussion (Misc queries) | |||
display cell value in msgbox formatted as % | Excel Discussion (Misc queries) | |||
Move a diagram from Excel to Visio? | Charts and Charting in Excel | |||
Date format collapses diagram | Excel Discussion (Misc queries) |