467,116 Members | 1,155 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,116 developers. It's quick & easy.

Plotting Data

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
  • viewed: 1554
Share:
3 Replies
Anyone help please

Thanks

Nov 13 '05 #2
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
Thanks I'll give that a go.

Bertrand

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Erik Lechak | last post: by
6 posts views Thread by Gerrit Holl | last post: by
7 posts views Thread by Russell E. Owen | last post: by
4 posts views Thread by skorpio11@gmail.com | last post: by
8 posts views Thread by Freddy | last post: by
7 posts views Thread by diffuser78@gmail.com | last post: by
reply views Thread by robert | last post: by
4 posts views Thread by Gouri | last post: by
reply views Thread by Helmut Michels | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.