Office Software Thread, Basic question for a someone: creating graphs from data in a column. How do you do it in Technical; Hi
Ok my knowledge of Excel is virtually nil. I am using Excel 2010 and have recently compiled a survey. ...
11th June 2010, 10:06 PM #1
Basic question for a someone: creating graphs from data in a column. How do you do it
Ok my knowledge of Excel is virtually nil. I am using Excel 2010 and have recently compiled a survey. Now the survey has finished and I have my answers I am now able to export this survey into a CSV file and now I have a number of different column which represent the various questions in the survey compiled and below this i have in each row the answers from each respondent.
2 things I want to establish. Let me create an example of a typical question with the answers:
What version of Office do you use at home?
So imagine I have different options selected for each person who conducted the survey in rows going down. I have about 100 rows. My knowledge of formulas but know I have to use the count formula so what I wish to do is for Excel to calculate the total number of answers and put this into a row at the bottom of the table alongside with the name of the answer as a reference. I then want to create some sort of graph with each set of answers. I am aware on how to create the graph I just need help on the first part and how best to do this.
What would be best and easiest way for me to do this?
Someone is going to look at this question and laugh because I bet its really easy to do. If anyone can offer advice on good websites as a reference guide, that would be really handy also.
IDG Tech News
11th June 2010, 10:23 PM #2
This should help you out if I've understood your needs
Excel Spreadsheets for Beginners: The CountIF Function
Last Post: 26th March 2009, 08:38 PM
By Wildebeaste in forum How do you do....it?
Last Post: 10th February 2009, 09:31 AM
By deudonne in forum Network and Classroom Management
Last Post: 3rd December 2008, 07:14 PM
By pooneej in forum Thin Client and Virtual Machines
Last Post: 9th May 2008, 02:36 PM
Last Post: 6th March 2006, 08:56 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)