Creating a graph with existing data...clear data after save

[Guest]

I have asked this before but nobody got back to me, so i'm guessing i didn't
explain clearly enough.

My task has been to create a quiz for work collegues, i have done this and
am now trying to 'jazz it up' a bit.

I have several sheets of quesitons, and would like to create a graph to show
the results. (eg 8 out of 10 etc). the graph will be displayed on the first
page and show the results of previous attempts at the quiz.

Is there any way that i can store the results (in the form of a graph) of
the quiz when the user closes the sheet, but also clear the answers given so
that when they try again the quiz is 'refreshed' and all answers are blank.

My VBA skills are very very rusty so the more detailed the help the better.
Thanks

 

[Guest]

Are you trying to show cumulative results?

Assume we both take the quiz. I get 1, 2, 4, & 6 right and 3 & 5 wrong. You
get 2, 4, 5 & 6 right and 1 & 3 wrong do you want to show that 100% got 2, 4
& 6 right, 50% got 1 & 5 right, and 0% got 3 right? Or are you looking for
just the score of the last person to take the quiz?

I'm glad to help, but need a bit more explaination.

Mike

 

[Guest]

Sorry i should have been more clear, each person is to get a personal copy of
the test (it is a self help quiz). Therefore only the individuals score will
be recorded.

Ideally each 'run' of the quiz will be saved as a column of a the graph
using the =TODAY() function. (the series of the graph is the quiz sections)

If you need more please ask. I can strip the quiz down to let you have a
look at what i've done / trying to do. (Information contained in the quiz is
Business Confidential).

Thanks again

 

[Guest]

I think it would be helpful to see the quiz format. At the very least to see
how the results of the quiz are output. If you have a sample graph to go
with it that would help as well.

You can send the file to mike at crazybass2.com. (Replace the 'at' with @)

Mike