+ Reply to Thread
Results 1 to 4 of 4

Tabulating survey results

  1. #1
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    3

    Tabulating survey results

    Good Morning all,

    Another newb question that has had me headscratching for a few hours.

    Is there a way to show the results of a survey (basic y/n) as a percentage of total surveys submitted?

    I have also been charged with keeping the customer data (name/house number) visible when it's displayed as a chart?

    Any help would be gratefully received.

    Attached is a sample....sample.xls

    Excel 2003 btw...

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,626

    Re: Tabulating survey results

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and format as percent.

    The next question is realated to the same data, byt totaly different subject - would be better to those who use http://www.excelforum.com/search.php to have them on separate threads.
    Best Regards,

    Kaper

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Tabulating survey results

    With an pivot table.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Tabulating survey results

    HI,

    Find the chart.

    Punnam
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Keyword Searching in a Webpage and Tabulating the results in an Excel Sheet
    By veejar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2012, 11:56 PM
  2. tabulating survey, Stat tests, etc.
    By nikhiljo in forum Excel General
    Replies: 1
    Last Post: 07-09-2009, 08:37 PM
  3. Tabulating survey results
    By asbamba in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-03-2008, 04:07 PM
  4. Replies: 2
    Last Post: 02-21-2008, 04:24 PM
  5. tabulating and analyzing survey data
    By bob in forum Excel General
    Replies: 1
    Last Post: 02-01-2005, 08:06 PM

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