Questionnaire - Graph creation

[akhlaq768]

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?

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

Thanks in advanced