How to Graph Survey Results

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Graphs can make your numbers easier to understand.
Image Credit: amanaimagesRF/amana images/Getty Images

With today's digital-age attention spans, presentation is as important as the data itself. If you can't capture your reader's or audience's attention immediately, it's unlikely that you'll get your point across. Graphs are a simple and intuitive way to communicate data, provide a quick visual representation of your findings and make your data stand out. Microsoft Excel has several powerful and quick tools to graph your survey data, especially if you download the free Analysis Toolpack from Microsoft for extra analysis tools. Whether you have qualitative or quantitative data, Excel has the right graph for you.

Advertisement

Downloading the Analysis Toolpack

Video of the Day

Step 1

Click on the "File" tab in Excel and then click on "Options" from the menu.

Video of the Day

Step 2

Click on "Add-Ins" and then select "Excel Add-Ins" from the options in the Manage box.

Advertisement

Step 3

Click on "Go" to load the Available Add-Ins box.

Step 4

Check the box next to Analysis Toolpack and click on "Ok" to load extra analysis tools into Excel.

Histograms for Quantitative Data

Step 1

List all of your data in the first column of your worksheet. Place only one number into each cell.

Advertisement

Step 2

Type in your bin numbers in the second column in ascending order. Bin numbers are organizational intervals to organize your data. If, for example, your survey measures cups of coffee respondents drink per day, logical categories might be 0, 1, 2, 3, 4, 5 and 6.

Step 3

Click on "Data" at the top of Excel and select "Data Analysis" to load advanced features from the Analysis Toolpack.

Advertisement

Step 4

Select Histogram from the list and click on "Ok."

Advertisement

Step 5

Type in the cell range of your data in the Input Range box under Input. Cell ranges should be in the form A1:A50. Be sure to include all of your data in the range.

Advertisement

Step 6

Type in the cell range of your bin numbers in the same form as above in the Bin Range box, also under Input.

Step 7

Choose an output location under Output Options. You can create the histogram in the same sheet, in a new sheet or in an entirely new workbook.

Advertisement

Step 8

Check any additional format options you would like from the window and click on "Ok" to create the histogram.

Pie Charts for Qualitative Data

Step 1

Type your numerical data into a row or column in an Excel worksheet. If, for example, you're measuring attitudes toward a political initiative and the options are "I feel positively," "I feel negatively" and "I'm unsure," your numerical data would be the number of respondents that answered each. You would list all three values horizontally or vertically.

Advertisement

Advertisement

Step 2

Highlight the data you just entered.

Step 3

Click on "Insert" on the top of Excel and then click on "Insert Pie or Doughnut Chart" to load chart options.

Step 4

Select the format of pie chart you want to load it into your worksheet.

Advertisement

Step 5

Click on the chart in your worksheet and use the icons to the right to add formatting touches. Click on the icon with a plus sign to label your data slices and give the chart a title.

Advertisement

Advertisement

references