Create a graph

**hcubed63** · 01-07-2011, 07:55 PM

Hi

I am trying to create a graph with the information in the attached PDF, but don't know how to get around something.

There are some questions that require either a yes or a no. Then there is a question that says Which one? I would like to insert the resort they had visited and that to display in the graph. But if they have visited more than one how do I do it.

Any help would be greateful.

**ryantaylor** · 01-07-2011, 08:09 PM

Do you need to visualise the outcome of each question? If so, I'd create a separate graph for each question. The Y/N would be best displayed in a pie chart for example.

**hcubed63** · 01-07-2011, 08:12 PM

Hi

Thanks for that, I have attached my sheet, but how would you set this up?

**hcubed63** · 01-07-2011, 08:34 PM

How can I make a pie chart from this please:
How did you hear about us Website Friend Seniors Paper Signage
4 2 1 1 5

**6StringJazzer** · 01-07-2011, 11:18 PM

See attached. You could do one chart for all the Yes/No questions, but you should have a different chart for each one of the other types of questions, like in my example. The type of chart may vary with the type of question/answers.

I also had to fix your counting formulas. You had circular references.

Hopefully this gives you some ideas.

EDIT: I don't recommend pie charts for this type of thing, though it's somewhat a matter of taste. They aren't as readable as bar charts.