Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default making graphs in excell

Hi

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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default making graphs in excell

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
http://www.MikeMiddleton.com

"Alexis" wrote in message
...
Hi

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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making a CSV from several collumns in excell patrick007 Excel Discussion (Misc queries) 3 August 3rd 06 03:39 PM
Pasting Graphs - making me crazy! BankC Excel Discussion (Misc queries) 1 April 25th 06 06:12 PM
Making graphs from updates... ELBeanzio Excel Worksheet Functions 2 December 1st 05 12:19 PM
Making mutiple graphs the same size merritaf Charts and Charting in Excel 1 October 29th 05 02:35 AM
making graphs ignore "blank " cells Guillermo Excel Discussion (Misc queries) 4 February 22nd 05 09:26 PM


All times are GMT +1. The time now is 04:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"