A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Quality/ Productivity diagram



 
 
Thread Tools Display Modes
  #1  
Old January 31st, 2006, 11:47 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old January 31st, 2006, 12:04 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old January 31st, 2006, 06:55 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 02: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


All times are GMT +1. The time now is 04:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.