Help with variables for chart

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

Hi,

I'm hoping someone can point me to a tutorial or helpsite with information
as I can't seem to find any.

I set up a basic Access database to record stats for my team (it's a contact
centre). However, I've now found that the Agent PC's don't have Access,
just Excel and Word, so I'm trying to put together something similar.

What I had: The Agent chooses a start and end day for their stats. This
displays all the data for that time (incoming calls answered, talk time,
wrap, idle) and creates a chart for each stat. In addition, it also
includes the average for the whole team as well, so the Agent can see how
they are performing against the team average.

I want to create something similar in Excel but, to be honest, I have no
idea how to create a chart that takes dates from two cells, the name of the
Agent (or their ID), collects their stats but also the average of the teams
and then uses that data in the graph.

Can anyone direct me by any chance. Hope the above makes sense.

With thanks in advance,

Charlie
 
Could you clarify what you want in a sample graph? I'm not clear what you
want the graph to look like and what the source data for that graph would
be.
 
Barb Reinhardt said:
Could you clarify what you want in a sample graph? I'm not clear what you
want the graph to look like and what the source data for that graph would
be.
Click to expand...

My apologies - you're right.

There would be 4 graphs (one each for calls taken, wrap, idle and talktime).

X axis - Date (as chosen by Agent - they only want to see specific data)
Y axis - Figure from 1 upto highest figure for current stat in chart

On each chart would be a line graph with the following lines:
1) The daily stat for the Agent.
2) The average daily stat for the whole team.
3) The benchmark that the Agent should be hitting.

(example at: http://www.geocities.com/charles_dunhill/chart.gif )

However, it needs to be variabe, so that each agent will be able to choose
their name from a list, choose a start and end date and that the average
column would be automatically worked out by the chart (eample of how data
will be stored is at http://www.geocities.com/charles_dunhill/data.gif )

Hope that makes more sense. :)

Cheers!

Charlie
 
Charles -

In this article I show how to set up a dynamic chart that lets a user select what
data to chart by date using scrollbars.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

On this web page I show how to use a dropdown or listbox to select which series to plot.

http://peltiertech.com/Excel/Charts/ChartByControl.html

The trick is in how the dynamic ranges are defined.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Jon Peltier said:
Charles -

In this article I show how to set up a dynamic chart that lets a user select what
data to chart by date using scrollbars.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

On this web page I show how to use a dropdown or listbox to select which series to plot.

http://peltiertech.com/Excel/Charts/ChartByControl.html

The trick is in how the dynamic ranges are defined.
Click to expand...

Jon, these are excellent. Thanks for taking the time to post them, it's
appreciated.

Cheers.

Charlie
 
Back
Top