+ Reply to Thread
Results 1 to 5 of 5

Thread: Spreadsheet Data to chart/graph help

  1. 05-06-2009, 11:26 PM #1
    confusedredhead
    confusedredhead is offline
    Registered User
    Join Date
    05-06-2009
    Location
    providence, ri
    MS-Off Ver
    MS Office Excel 2007
    Posts
    3

    Unhappy Spreadsheet Data to chart/graph help

    So here's the deal. I surveyed 100+ people at my internship, a written survey which i collected over a few weeks. What I did was then enter all 107 of the answers to each multiple choice question in a spreadsheet...such as age range, ***, $amount spent, number of items purchased, etc. now what I'm confused about is how to interpret that information and how i would go about charting and graphing it. i'm lost beyond belief. any help would be appreciated.
    Attached Files Attached Files
    Last edited by confusedredhead; 05-06-2009 at 11:50 PM. Reason: add file
    Reply With Quote Reply With Quote
  2. 05-06-2009, 11:36 PM #2
    mubashir aziz
    mubashir aziz is offline
    Valued Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    458

    Re: Spreadsheet Data to chart/graph help

    It will be better to attach a sample file
    Reply With Quote Reply With Quote
  3. 05-06-2009, 11:50 PM #3
    confusedredhead
    confusedredhead is offline
    Registered User
    Join Date
    05-06-2009
    Location
    providence, ri
    MS-Off Ver
    MS Office Excel 2007
    Posts
    3

    Re: Spreadsheet Data to chart/graph help

    I just added one!
    Reply With Quote Reply With Quote
  4. 05-07-2009, 03:04 AM #4
    mubashir aziz
    mubashir aziz is offline
    Valued Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    458

    Smile Re: Spreadsheet Data to chart/graph help

    I"ve just added a summary sheet, Pivot Table & Pivot Chart. you have both options with you and can play with chart as per your wish ...
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  5. 05-07-2009, 08:16 AM #5
    confusedredhead
    confusedredhead is offline
    Registered User
    Join Date
    05-06-2009
    Location
    providence, ri
    MS-Off Ver
    MS Office Excel 2007
    Posts
    3

    Re: Spreadsheet Data to chart/graph help

    Oh my gosh that is so amazing. I'm such a dummy when it comes to this stuff. your help is greatly appreciated
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0