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


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
marks. (1,2,3,4)

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

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

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

were I'm getting tripped up is that if I have two values of the same
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
That is that I would like Access or Excel tell the person looking at
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
3 Replies
Anyone help please


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.

Tom R

bc*******@hotmail.com wrote:
Anyone help please


Nov 13 '05 #3
Thanks I'll give that a go.


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.