Comparing data

[Alex Hammerstein]

Hi

I have worksheet with the following columns
A: month-year in Jul-09 format. This data goes back 18 months
B: Staff member Name
C: Number calls received
D: Average time taken to deal with each call

What I am trying to do is to create a chart which will allow me to compare
the results for one member of staff against the average for the other
members of staff for each month and for the whole period.

Is this possible please, and how would I go about it? I guess I will need
more than one chart.

Many thanks

Alex

 

[Carl Witthoft]

Hi

I have worksheet with the following columns
A: month-year in Jul-09 format. This data goes back 18 months
B: Staff member Name
C: Number calls received
D: Average time taken to deal with each call

What I am trying to do is to create a chart which will allow me to compare
the results for one member of staff against the average for the other
members of staff for each month and for the whole period.

Is this possible please, and how would I go about it? I guess I will need
more than one chart.

Many thanks

Alex

The only tricky part is generating the averages for all staffers
*except* the one of interest. You should start by reading up on
functions like SUMIF and other conditional database tools. Roughly
speaking, the mean number of calls received for all other workers for a
given month might look something like

=SUMIF( B:B ,<>"Joe Jones",C:C)