Which chart will do what I want? I Clarified My Question...

  • Thread starter Thread starter Ginger
  • Start date Start date
G

Ginger

I noticed I was not getting any replies from you gurus. I
attached the file this time so you can maybe see what I am
talking about. I know this can be done, my question is
how? I'm sure I need to set my data up differently, maybe
even put it into Access and try to generate charts from
excel that way?
Basically, I have data that I can't get plotted the way I
want: salesnumbers representing my sales staff as my data
series, with multiple item performance results based on a
form they turn in weekly. I want to plot the performance
data for each salesperson against each other each week,
another chart showing their performance against each other
in each category over time (by week). Like this:

Sales Guy No. 1 give me the following data:
5 office calls
6 jobsite calls
10 plant calls
15 telephone calls

Sales Guy No. 2 gives me this data:
6 office calls
2 jobsite calls
21 plant calls
30 telephone calls

Every week these guys give me data for these same
categories. I need to show the trends for each sales guy
over the weeks, and also compare their data. So, I have
2 "category" axes (1:sales guys 1 and 2; 2:office,
jobsite, plant and telephone calls), and two value axes
(1: time (by week scale); 2:data scale 0-30)).

Does this help clarify this question?
 
If you set up your data like this:

Date Name Item Qty
3/5/2004 Fred Office Calls 5
3/5/2004 Fred Jobsite Calls 6
3/5/2004 Sam Office Calls 6
3/5/2004 Sam Jobsite Calls 2

you can create a pivot table and pivot chart from the data. There are
instructions and links here:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

Experiment with different layouts, to find the ones that present your
data most effectively. For example, put Name in the page area, date in
the row area, item in the column area, and Qty in the data area. To view
results for one salesperson, select a name from the Name dropdown.
 
Back
Top