Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: Questionnaire - Graph creation

    I am creating a questionnaire in Excel, Im using the template to populate the results.

    Im finding it difficult to produce a graph for the results.

    I want a number of graphs produced

    Graph 1 (Trust core standards)
    Questions 1 to 14

    Graph 2 (Demographics, reason for referral & consent_
    Questions 15 to 25

    Graph 3 (Nutritional Assessment)
    Questions 26 to 38

    Graph 4 (Treatment)
    Questions 39 to 41

    Is there anyway I can do this?

    Thanks in advanced
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. What kind of graph are you wanting to produce since the results are either Y/N or 1/0?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2007
    Posts
    127
    Quote Originally Posted by shades
    Howdy. What kind of graph are you wanting to produce since the results are either Y/N or 1/0?
    I just want to represent the results visually...

    i cant think of a way to produce a visual graph

    hope you can help mate

  4. #4
    Join Date
    Oct 2007
    Posts
    127
    can anyone help please

  5. #5
    Join Date
    Oct 2003
    Posts
    1,091
    Is this to quickly determine whether every item has "yes" checked? Do you want this data to be the base for the visual display or something else?

    Also, what do the colored cells mean in the column for N/A? (i.e., E13:E43)
    Last edited by shades; 02-11-08 at 15:25.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  6. #6
    Join Date
    Oct 2007
    Posts
    127
    Hi

    This questionnaire was initially in a word document, the problems with that was it didn't allow for data entry.

    So I thought i'll create it in Excel....Is this a good idea?

    The questionnaire will be sent to about 50 people to fill in.... a visual graph need to be created to represent the results.

    Firstly should i be using access for data entry? i thought it be easier to do it in excel as the creating a graph would be easier

    the colours cells mean, that the user doesn't need to fill it in, only enter a yes or no.


    Quote Originally Posted by shades
    Is this to quickly determine whether every item has "yes" checked? Do you want this data to be the base for the visual display or something else?

    Also, what do the colored cells mean in the column for N/A? (i.e., E13:E43)

  7. #7
    Join Date
    Oct 2003
    Posts
    1,091
    Okay. A few more questions: BTW, your patience is appreciated on this.

    Are you tabulating the data? (to see how many completed each item) Or is to to check for each individual response? In other words, you have data entry, and then are you keeping data for further analysis? If so, that should be on another worksheet, and the display (however you graphical present) should be another worksheet.

    As for entry, are you sending it to others to complete? If so, then Excel is really the best option. But you can use either a UserForm, or protect the Excel worksheet so that they cannot access everything else, and then prevent even movement around the worksheet itself.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  8. #8
    Join Date
    Oct 2007
    Posts
    127
    to check for each individual response....

    having it on seperate sheets is what im looking for

    i am sending it out for people to complete...

    how do i collate all the sheets together...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •