Plotting Data

bchaillou

Hello

I've got a question about plotting data on either access or excel.

This is what is buggin me.

I've got a series of data fields that needs to be plotted

Their values are coming from a questionaire within Access from option
box
marks. (1,2,3,4)

1 being the best and 4 being the worst value that the users answer.

-->Greeting
-->Response
-->Response delay
-->Response time
-->Response Quality

Im trying to plot these values by agreement ID so the data is to be
looked
at by rows.

were I'm getting tripped up is that if I have two values of the same
number
in the same field.

IE --> greeting == 1,1,3,2 there are always four responses. I get the
repetin g values ploted twice when I am looking to have them added
together
That is that I would like Access or Excel tell the person looking at
the
chart that there was 2 number 1 responses for that value.

I am looking for this output

|
|
|
|
|
|
|
| *
| * * * *
|---------------
1 2 3 4

Instead of this output.

|
|
|
|
|
|
|
|
| * * * * *
|-----------------
1 2 3 4 1

Thanks for your help

Nov 13 '05 #1

bchaillou

Anyone help please

Thanks

Nov 13 '05 #2

rizzyboy

What you want is a histogram of the data. Excel has a wizard for doing
this. The technique involves defining "bins" that will keep the count
of data that belongs in that bin. Since your responses are numbers,
you can directly define the bins as 1, 2, 3, and 4.

Having said this, I never cared for Excel's histogram wizard, so I
wrote my own routines for creating bins and counting the data that fell
into them.

HTH,
Tom R

bc*******@hotmail.com wrote:

Anyone help please

Thanks

Nov 13 '05 #3

bchaillou

Thanks I'll give that a go.

Bertrand

Nov 13 '05 #4