making graphs in excell




I have just compiled some data from a questionnaire and i would now like to
make some graphs from it. I want to show the data responses for each
question separately. I also have 3 differing factors for each question - 3
types of people who answered the question; 3 types of place they work in and
3 types of level they work at. I haven't got a clue how to do this and i am
banging my head on the desk!! I was told to enter each entry as 1 or leave
it blank. If you understand this and could help me you will be my saviour!



Mike Middleton

Alexis -

If your data are arranged in standard "database" format, you should be able
to use the Pivot Table features to prepare summaries. Then use Pivot Charts
or "manual" bar or column charts to display the summarized results.

("Database" format for questionnaire results would typically be one row for
each respondent and one column for each question.)

- Mike

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel plugin to make graphs look better 0
graphs in Excel 1
Excel graphs 1
Excel Graphing 4
Excel graph problem 6
configurable graphs in excel 1
Excel 2003 Graphs 2
Graph Creation in Excel 3