+ Reply to Thread
Results 1 to 1 of 1

Survey data (text) from a site; Questions copied to their own individual tab; chart

  1. #1
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2016
    Posts
    14

    Survey data (text) from a site; Questions copied to their own individual tab; chart

    I am having trouble with how to perform this task in Excel. Any help would be GREATLY appreciated.

    We have a subscription to a popular website that helps us make forms/surveys and it also stores the data/responses for each form. We can see the results through the website in the form of an Excel spreadsheet. One particular form is a survey. In this survey, we have a rating scale. SA=Strongly Agree, A=Agree, D=Disagree, SD=Strongly disagree, N/A=Not Applicable. What I would like to do is to take each column (each column is a question; there are up to 68 questions; there are multiple surveys with different numbers of questions), and copy it to a tab in Excel. Then I want to create a pie graph using that data so it can be easily understood. I would like to put the graph in the same tab as its respective question/data. Here is an example of questions asked:

    I believe my child’s school provides a caring and supportive environment. SA A D SD
    I believe my child feels safe and secure at school. SA A D SD
    I believe my child’s school provides academically challenging content. SA A D SD

    I have attached a screen shot of some of sample data.

    So, each question is a column in the results we got back. Each respondent is a row with their respective answers.

    I guess I am asking how I say to Excel, “For each question, I want to move that column (question) to a tab within the spreadsheet, and I want you to count up all of the SAs, As, Ds, SDs, and N/As and make a pie chart.”

    Not all of the questions will be used in making charts as the first seven questions are background characteristics of the person being surveyed.
    Is this possible with Excel?
    Attached Images Attached Images

+ 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. Pivot Table Survey Data Multiple Questions, 5 Responses, Calculated Feilds
    By MysticGenius in forum Excel Charting & Pivots
    Replies: 20
    Last Post: 07-17-2019, 11:34 PM
  2. Pivot Table Survey Data Multiple Questions, 5 Responses
    By mydragonstalents in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-20-2013, 06:15 AM
  3. [SOLVED] Analyzing survey data using chart
    By debaser in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-09-2012, 08:58 PM
  4. Site Questions
    By guile in forum Excel General
    Replies: 1
    Last Post: 09-22-2005, 04:05 AM
  5. Replies: 0
    Last Post: 05-17-2005, 10:06 AM

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