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

I’m 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

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

can anyone help please

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)

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.

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.

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...