+ Reply to Thread
Results 1 to 4 of 4

Analyzing survey data using chart

  1. #1
    Registered User
    Join Date
    04-02-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2003
    Posts
    10

    Analyzing survey data using chart

    I want to make a simple chart and I went through several on-line tutorials but they all start with different setup. Mine is this:

    I'm analyzing survey data. Columns are questions, rows are answers. For instance, column A is 'gender' and rows 1-100 show either 'M' or 'F'. I want to select these rows and make a pie chart that will show that for instance 68% answers are F and 32% are M.

    Thanks in advance. BTW I'm using Excel 2003.
    Last edited by debaser; 04-02-2012 at 05:40 AM.

  2. #2
    Registered User
    Join Date
    04-02-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: simple chart question

    I don't know why was this too difficult for the forum members, but the answer is Pivot Table. I can't use Chart right away, I first need to make a Pivot Table.

  3. #3
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Analyzing survey data using chart

    It wasn't too difficult for forum members.

    Your thread title was not in compliance with the forum rules and all members helping to answer questions (at least the senior members) know to *NOT* answer threads where rule violations have been flagged, as with your thread. Obviously, as other threads get posted it pushes previous threads further down the stack and they loose some visibility which accounts, some, for your thread not getting an immediate reply.
    Last edited by Palmetto; 04-09-2012 at 08:54 PM.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  4. #4
    Registered User
    Join Date
    04-02-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Analyzing survey data using chart

    I changed the thread title as soon as I was warned - only an hour and 12 minutes after the creation of the thread. I don't believe the thread could've been pushed down so much in such little time. If the thread stayed flagged after that it means the flagging system is wrong.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1