How do I Create Questionnaire Graph Results With Software?

Written by alisa hewitt
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How do I Create Questionnaire Graph Results With Software?
You can use computer software to create graphs from tabulated questionnaire data. (computer with sales chart on screen image by patrimonio designs from

Graphs and charts add eye-catching visual elements to reports and projects. Using software is an efficient way to create a variety of chart types to present data that is visually appealing to your audience. Charts and graphs add emphasis to important information, drawing audience attention and enhancing understanding. Using Microsoft Excel, Open Office Calc, or a create a graph website to create graphs also allows you to make changes to your data set and save new versions of your graphed data.

Skill level:


  1. 1

    Tabulate the data for each of the questions from the questionnaire. Using a blank copy of the questionnaire, write the total number of each response received from the completed questionnaires. For example, if you have a question with answer choices "A", "B", and "C," write on your blank questionnaire how many people answered "A," "B," or "C."

  2. 2

    Create a graph from your tabulated questionnaire data in Microsoft Excel, a proprietary software program that has features that create graphs. The program allows you to enter the data for each question on a new worksheet and use the "Charts" feature to select the data and graph type for each graph you would like to generate. Graph types include pie chart, bar graph, line graph, area graph and scatter graph.

  3. 3

    Enter your tabulated data for each question on a blank worksheet in OpenOffice Calc, an open-source software program. By selecting the "Chart Wizard," you can generate graphs corresponding to your data. Available graph types include pie chart, bar graph, line graph, bubble graph, and combination graphs.

  4. 4

    Create graphs from your date at The National Center for Education Statistics website, which has a free "Create-a-Graph" tool to create graphs. This tool walks you through each step in creating a graph and includes prompts for entering the data and formatting the chart results. Graphing options include bar graph, pie chart, line graph, area graph, or XY graph.

Tips and warnings

  • When selecting the information for the graph when using Microsoft Excel or OpenOffice Calc, select all of the data entered for each question so your chart displays properly.
  • The website tool allows you to save each individual graph, but if your data set changes, you must recreate the graph to incorporate the new or changed data.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.