+ Post New Thread
Results 1 to 2 of 2
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. ...
  1. #1
    ranj's Avatar
    Join Date
    Feb 2006
    Location
    Birmingham
    Posts
    732
    Thank Post
    100
    Thanked 42 Times in 32 Posts
    Rep Power
    25

    Basic question for a someone: creating graphs from data in a column. How do you do it

    Hi

    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:

    A Column

    What version of Office do you use at home?
    Office 2003
    Office 2010
    Office 2007
    Microsoft Works
    Office 2010
    Other
    Office 2007
    Office 2010

    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.



    Thanks

  2. #2

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    72
    This should help you out if I've understood your needs

    Excel Spreadsheets for Beginners: The CountIF Function

SHARE:
+ Post New Thread

Similar Threads

  1. Cacti Graphs
    By danIT in forum *nix
    Replies: 0
    Last Post: 26th March 2009, 07:38 PM
  2. Data Protection Question
    By Wildebeaste in forum How do you do....it?
    Replies: 10
    Last Post: 10th February 2009, 08:31 AM
  3. Local install access, CC3 (new to this, basic question)
    By deudonne in forum Network and Classroom Management
    Replies: 7
    Last Post: 3rd December 2008, 06:14 PM
  4. Thin client basic question
    By pooneej in forum Thin Client and Virtual Machines
    Replies: 19
    Last Post: 9th May 2008, 01:36 PM
  5. BAsic question about Shadow Copies
    By Kyle in forum Windows
    Replies: 5
    Last Post: 6th March 2006, 07:56 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •