{"id":41696,"date":"2025-10-06T08:36:43","date_gmt":"2025-10-06T08:36:43","guid":{"rendered":"https:\/\/wpdatatables.com\/?p=41696"},"modified":"2025-10-27T16:00:09","modified_gmt":"2025-10-27T16:00:09","slug":"google-forms-results-graph","status":"publish","type":"post","link":"https:\/\/wpdatatables.com\/google-forms-results-graph\/","title":{"rendered":"How to Create Charts from Google Forms\u2019 Results &#038; Publish on Your Website?"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Ever had a mountain of survey responses staring back at you, daring you to make sense of them? Yeah, me too.&nbsp;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">But here&#8217;s a secret: <\/span><b>it\u2019s easier than you thought to create charts from those Google Forms results and publish them on your website.<\/b><span style=\"font-weight: 400;\"> Stick around, because by the time we finish this chat, you&#8217;ll wield the power to morph numbers and checkboxes into insight-popping visuals.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">We&#8217;re diving deep how to make the most of your survey responses and create charts that tell the story &#8211; directly from Google forms. It&#8217;s like painting, but your colors are the <\/span><b>Google form results representation<\/b><span style=\"font-weight: 400;\"> from real people.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">From crafting <\/span><b>pie charts<\/b><span style=\"font-weight: 400;\"> that would make a baker jealous to <\/span><b>bar graphs<\/b><span style=\"font-weight: 400;\"> that stand tall, this read is your ticket to the <\/span><b>data visualization<\/b><span style=\"font-weight: 400;\"> league.<\/span><\/p>\n<p><!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class=\"ez-toc-list ez-toc-list-level-1 \"><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/google-forms-results-graph\/#How_to_Create_Charts_from_Google_Forms_Results\">How to Create Charts from Google Forms\u2019 Results?<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/google-forms-results-graph\/#Analyzing_Form_Results_in_Google_Sheets\">Analyzing Form Results in Google Sheets<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/google-forms-results-graph\/#How_to_Create_Google_Form_Charts_and_Publish_them_on_Your_Website\">How to Create Google Form Charts and Publish them on Your Website?<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/google-forms-results-graph\/#How_to_Create_Google_Forms_Pie_Chart_with_wpDataTables\">How to Create Google Forms Pie Chart with wpDataTables?<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/google-forms-results-graph\/#How_to_Create_Google_Forms_Bar_Chart_with_wpDataTables\">How to Create Google Forms Bar Chart with wpDataTables?<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/google-forms-results-graph\/#FAQ_on_How_to_Create_Results_Charts_from_Google_Forms\">FAQ on How to Create Results Charts from Google Forms<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"#\" data-href=\"https:\/\/wpdatatables.com\/google-forms-results-graph\/#Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Create_Charts_from_Google_Forms_Results\"><\/span>How to Create Charts from Google Forms\u2019 Results?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\/\", \n  \"@type\": \"HowTo\", \n  \"name\": \"How to Create Charts from Google Forms\u2019 Results?\",\n  \"description\": \"Learn how to create charts from Google Forms results and publish them on your website. Turn survey responses into graphs, pie charts, and bar charts directly from Google Forms or Google Sheets.\",\n  \"totalTime\": \"PT10M\",\n  \"estimatedCost\": {\n    \"@type\": \"MonetaryAmount\",\n    \"currency\": \"USD\",\n    \"value\": \"0\"\n  },\n  \"tool\": [{\n    \"@type\": \"HowToTool\",\n    \"name\": \"Google Sheets\"\n  },{\n    \"@type\": \"HowToTool\",\n    \"name\": \"Google Forms\"\n  },{\n    \"@type\": \"HowToTool\",\n    \"name\": \"wpDataTables\"\n  }],\n  \"step\": [{\n    \"@type\": \"HowToStep\",\n    \"text\": \"To generate a report from the survey results, use types of questions that provide a quantifiable and consistent variation of data.<\/p>\n<p>For better analysis, it is helpful to make answering possible in one of the following ways. Choose from multiple-choice, linear scale, checkbox, or a drop-down list.<\/p>\n<p>Providing a set of possible answers enables faster processing of survey responses.<\/p>\n<p>Using the Short Answer format yields high variability in data. This makes it harder to measure and analyze.\",\n    \"image\": \"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ques.jpg\",\n    \"name\": \"Step 1: Select appropriate question types\"\n  },{\n    \"@type\": \"HowToStep\",\n    \"text\": \"After saving the Google forms responses in a Google spreadsheet, it's time to set the data range. Naming a range of cells makes it easier to create formulas.<\/p>\n<p>The first row of the sheet shows the questions in the survey form. Each question occupies a single column.<\/p>\n<p>For this step, it\u2019s necessary to name each column. For example, if the question in the first cell of the column is How old are you?, then name it Age.<\/p>\n<p>To name a range:\nHighlight the question or column to graph by clicking the letter of the column.\nOn the menu bar, go to 'Data' then click 'Named ranges'.\nType in the name of the range.\nClick 'Done'.\",\n    \"image\": \"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm.jpg\",\n    \"name\": \"Step 2: Name data range\"\n  },{\n    \"@type\": \"HowToStep\",\n    \"text\": \"In Column A, list down all the possible answers or Google forms responses to the question highlighted in the first step. Make sure that all the responses listed are the exact responses appearing in the Google Form.\",\n    \"image\": \"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm2.jpg\",\n    \"name\": \"Step 3: List down responses in a new sheet\"\n  },{\n    \"@type\": \"HowToStep\",\n    \"text\": \"In Google Sheets, the \u2018countif\u2019 function returns a conditional count across a specific range. This means it counts how many times a certain data occurred.<\/p>\n<p>This function is very useful. It will count how many respondents chose a specific response in the selected range.<\/p>\n<p>The formula for \u2018countif\u2019 uses the named range for reference (from the first sheet). It also uses the cell address of the response to count (from the new sheet). Insert the \u2018countif formula\u2019 in the first cell of Column B. Once entered, Google Sheets will offer to apply the formula in the following rows.<\/p>\n<p>If the auto-fill option doesn't appear:<\/p>\n<p>Select the cell that has the \u2018countif\u2019 formula.\nHover over the tiny box at the bottom right corner of the cell. The mouse cursor should turn into a plus (+) sign.\nWith the plus sign, click the bottom right corner of the cell and drag it down across the rows as needed. It will automatically fill in the cells with the \u2018countif\u2019 formula.\",\n    \"image\": \"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/count.jpg\",\n    \"name\": \"Step 4: Use the \u2018countif\u2019 Function\"\n  },{\n    \"@type\": \"HowToStep\",\n    \"text\": \"After using the \u2018countif\u2019 function, there should now be a new set of data. Use this to create a Google forms results graph.<\/p>\n<p>Highlight all data in columns A and B.\nGo to the menu bar and click 'Insert'.\nSelect 'Chart'. The 'Chart Editor' will appear on the right-side column. On the 'Setup' tab, choose the type of chart appropriate for the data. For this example, use a column graph or pie chart.\",\n    \"image\": \"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch1.jpg\",\n    \"name\": \"Step 5: Create a chart from Google forms\u2019 results\"\n  },{\n    \"@type\": \"HowToStep\",\n    \"text\": \"On the Chart Editor, go to the 'Customize' tab. One can now customize the chart style, the format for axis titles, legends, gridlines, and ticks.\",\n    \"image\": \"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu1.jpg\",\n    \"name\": \"Step 6: Customize the chart\"\n  }]    \n}\n<\/script><\/p>\n<h3><b>Step 1: Select appropriate question types<\/b><\/h3>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41701 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ques.jpg\" alt=\"Step 1: Select appropriate question types\" width=\"800\" height=\"758\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ques.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ques-300x284.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41701 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20758%22%3E%3C%2Fsvg%3E\" alt=\"Step 1: Select appropriate question types\" width=\"800\" height=\"758\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20758%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ques.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ques-300x284.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ques.jpg\"><\/p>\n<p>To generate a report from the survey results, use types of questions that provide a <strong>quantifiable<\/strong> and <strong>consistent variation of data<\/strong>.<\/p>\n<p>For better analysis, it is helpful to make answering possible in one of the following ways. <strong>Choose from multiple-choice<\/strong>, <strong>linear scale<\/strong>, <strong>checkbox<\/strong>, or a <strong>drop-down list<\/strong>.<\/p>\n<p>Providing a <strong>set of possible answers<\/strong> enables faster processing of survey responses.<\/p>\n<p>Using the Short Answer format yields <strong>high variability in data.<\/strong> This makes it <strong>harder to measure and analyze<\/strong>.<\/p>\n<h3><b>Step 2: Name data range<\/b><\/h3>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41703 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm.jpg\" alt=\"Step 2: Name Data Range for Google forms results graph\" width=\"800\" height=\"596\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm-300x224.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41703 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20596%22%3E%3C%2Fsvg%3E\" alt=\"Step 2: Name Data Range for Google forms results graph\" width=\"800\" height=\"596\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20596%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm-300x224.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm.jpg\"><\/p>\n<p>After saving the Google forms responses in a Google spreadsheet, it&#8217;s time to <strong>set the data range<\/strong>. <strong>Naming a range of cells <\/strong>makes it easier to create formulas.<\/p>\n<p>The first row of the sheet shows the questions in the survey form. Each question occupies a single column.<\/p>\n<p>For this step, it\u2019s necessary to name each column. For example, if the question in the first cell of the column is &#8220;How old are you?&#8221;, then name it &#8216;Age&#8217;.<\/p>\n<p>To name a range:<\/p>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41705 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm1.jpg\" alt=\"Naming range\" width=\"800\" height=\"534\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm1.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm1-300x200.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41705 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20534%22%3E%3C%2Fsvg%3E\" alt=\"Naming range\" width=\"800\" height=\"534\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20534%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm1.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm1-300x200.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm1.jpg\"><\/p>\n<ol>\n<li><strong>Highlight the question or column<\/strong> to graph by clicking the letter of the column.<\/li>\n<li>On the menu bar, go to <strong>&#8216;Data&#8217;<\/strong> then click <strong>&#8216;Named ranges&#8217;<\/strong>.<\/li>\n<li><strong>Type in the name<\/strong> of the range.<\/li>\n<li>Click <strong>&#8216;Done&#8217;<\/strong>.<\/li>\n<\/ol>\n<p>Remember, the name of the range can <strong>only<\/strong> contain <strong>alphanumeric characters<\/strong> and <strong>underscores.<\/strong> It <strong>cannot begin <\/strong>with a number.<\/p>\n<p>It <strong>must not <\/strong>have any<strong> spaces<\/strong> or <strong>punctuations<\/strong> or <strong>go beyond 250 characters<\/strong>. The words <strong>&#8220;True&#8221; <\/strong>and<strong> &#8220;False&#8221;<\/strong> are not valid, and nor are the <strong>&#8220;A1&#8221; <\/strong>and <strong>&#8220;R1C1&#8221; syntax<\/strong>.<\/p>\n<h3><b>Step 3: List down responses in a new sheet<\/b><\/h3>\n<p><noscript><img decoding=\"async\" class=\"wp-image-41707 size-full alignleft\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm2.jpg\" alt=\"Listing Down Responses to a New Sheet\" width=\"800\" height=\"580\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm2.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm2-300x218.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"wp-image-41707 size-full alignleft lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20580%22%3E%3C%2Fsvg%3E\" alt=\"Listing Down Responses to a New Sheet\" width=\"800\" height=\"580\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20580%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm2.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm2-300x218.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm2.jpg\"><\/p>\n<ul>\n<li><strong>Create a new sheet<\/strong> in the spreadsheet by clicking <strong>&#8216;Add Sheet&#8217;<\/strong> or<strong> the cross icon<\/strong> at the bottom left corner of the sheet.<\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41709 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm3.jpg\" alt=\"All answers from Google forms\" width=\"800\" height=\"408\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm3.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm3-300x153.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41709 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20408%22%3E%3C%2Fsvg%3E\" alt=\"All answers from Google forms\" width=\"800\" height=\"408\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20408%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm3.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm3-300x153.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/nm3.jpg\"><\/p>\n<ul>\n<li>In Column A,<strong> list down all the possible answers<\/strong> or Google forms responses to the question highlighted in the first step. Make sure that all the responses listed are <strong>the exact responses<\/strong> appearing in the Google Form.<\/li>\n<\/ul>\n<h3><b>Step 4: Use the \u2018countif\u2019 Function<\/b><\/h3>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41711 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/count.jpg\" alt=\"Using countif function in Google Sheets to help create Google forms charts\" width=\"800\" height=\"357\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/count.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/count-300x134.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41711 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20357%22%3E%3C%2Fsvg%3E\" alt=\"Using countif function in Google Sheets to help create Google forms charts\" width=\"800\" height=\"357\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20357%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/count.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/count-300x134.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/count.jpg\"><\/p>\n<p><strong>In Google Sheets, <\/strong>the \u2018countif\u2019 function returns a <strong>conditional count<\/strong> across a specific range. This means it counts <strong>how many times a certain data occurred<\/strong>.<\/p>\n<p>This function is very useful. It will count how many respondents chose a specific response in the selected range.<\/p>\n<p>The formula for \u2018countif\u2019 uses the <strong>named range<\/strong> for reference (from the first sheet). It also uses the <strong>cell address of the response to count<\/strong> (from the new sheet).<\/p>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41713 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co1.jpg\" alt=\"Explaination of countif formula\" width=\"800\" height=\"262\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co1.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co1-300x98.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41713 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20262%22%3E%3C%2Fsvg%3E\" alt=\"Explaination of countif formula\" width=\"800\" height=\"262\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20262%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co1.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co1-300x98.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co1.jpg\"><\/p>\n<p>It starts with &#8216;=countif&#8217; syntax. Then the named range and the cell address separated by a comma and enclosed within parentheses.<\/p>\n<p>As an example, it should look something like this: <strong>=countif(Age, A1)<\/strong>.<\/p>\n<p><strong>Insert the \u2018countif formula\u2019<\/strong> in the first cell of Column B. Once entered, Google Sheets will offer to apply the formula in the following rows.<\/p>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41715 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co2.jpg\" alt=\"Inserting countif formula\" width=\"800\" height=\"304\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co2.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co2-300x114.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41715 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20304%22%3E%3C%2Fsvg%3E\" alt=\"Inserting countif formula\" width=\"800\" height=\"304\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20304%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co2.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co2-300x114.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/co2.jpg\"><\/p>\n<p>If the auto-fill option doesn&#8217;t appear:<\/p>\n<ol>\n<li><strong>Select the cell<\/strong> that has the \u2018countif\u2019 formula.<\/li>\n<li><strong>Hover over the tiny box<\/strong> at the bottom right corner of the cell. The mouse cursor should turn into a <strong>plus (+) sign<\/strong>.<\/li>\n<li>With the plus sign, <strong>click the bottom right corner of the cell<\/strong> and <strong>drag it down<\/strong> across the rows as needed. It will <strong>automatically fill in<\/strong> the cells with the \u2018countif\u2019 formula.<\/li>\n<\/ol>\n<h3><b>Step 5: Create a chart from Google forms\u2019 results<\/b><\/h3>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41717 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch1.jpg\" alt=\"Creating a chart from Google Form results\" width=\"800\" height=\"631\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch1.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch1-300x237.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41717 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20631%22%3E%3C%2Fsvg%3E\" alt=\"Creating a chart from Google Form results\" width=\"800\" height=\"631\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20631%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch1.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch1-300x237.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch1.jpg\"><\/p>\n<p>After using the \u2018countif\u2019 function, there should now be a new set of data. Use this to create a Google forms results graph.<\/p>\n<ul>\n<li><strong>Highlight all data<\/strong> in columns A and B.<\/li>\n<li>Go to the menu bar and click<strong> &#8216;Insert&#8217;<\/strong>.<\/li>\n<li>Select <strong>&#8216;Chart&#8217;<\/strong>. The <strong>&#8216;Chart Editor&#8217;<\/strong> will appear on the right-side column.<\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41719 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch2.jpg\" alt=\"Editing chart created from Google forms results\" width=\"800\" height=\"476\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch2.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch2-300x179.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41719 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20476%22%3E%3C%2Fsvg%3E\" alt=\"Editing chart created from Google forms results\" width=\"800\" height=\"476\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20476%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch2.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch2-300x179.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/ch2.jpg\"><\/p>\n<ul>\n<li>On the<strong> &#8216;Setup&#8217; tab<\/strong>, <strong>choose the type of chart<\/strong> appropriate for the data. For this example, use a column graph or pie chart.<\/li>\n<\/ul>\n<h3><b>Step 6: Customize the chart<\/b><\/h3>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41721 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu1.jpg\" alt=\"Customizing the bar chart for Google forms\" width=\"800\" height=\"481\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu1.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu1-300x180.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41721 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20481%22%3E%3C%2Fsvg%3E\" alt=\"Customizing the bar chart for Google forms\" width=\"800\" height=\"481\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20481%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu1.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu1-300x180.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu1.jpg\"><\/p>\n<p>On the <strong>Chart Editor<\/strong>, go to the <strong>&#8216;Customize&#8217; tab<\/strong>. One can now customize the chart style, the format for axis titles, legends, gridlines, and ticks.<\/p>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41723 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2.jpg\" alt=\"Example of pie chart created from Google forms results\" width=\"800\" height=\"458\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2-300x172.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41723 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20458%22%3E%3C%2Fsvg%3E\" alt=\"Example of pie chart created from Google forms results\" width=\"800\" height=\"458\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20458%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2-300x172.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2.jpg\"><\/p>\n<p>The changes will automatically display in the Google forms results graph. Users can drag the chart away from the cells with data and place it on the other area of the spreadsheet.<\/p>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41725 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu3.jpg\" alt=\"Options to download, copy, edit, publish or delete the chart\" width=\"800\" height=\"454\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu3.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu3-300x170.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41725 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20454%22%3E%3C%2Fsvg%3E\" alt=\"Options to download, copy, edit, publish or delete the chart\" width=\"800\" height=\"454\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20454%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu3.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu3-300x170.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu3.jpg\"><\/p>\n<p>To download, copy, edit, publish or delete the chart, click the <strong>three vertical dots icon <\/strong>at the upper right corner of the chart. Then select the required command.<\/p>\n<p>Now the Google Forms results graph is ready for report.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Analyzing_Form_Results_in_Google_Sheets\"><\/span><b>Analyzing Form Results in Google Sheets<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41727 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv.jpg\" alt=\"Using pivot tables in Google Sheets to analyze Google forms' results\" width=\"800\" height=\"488\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv-300x183.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41727 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20488%22%3E%3C%2Fsvg%3E\" alt=\"Using pivot tables in Google Sheets to analyze Google forms' results\" width=\"800\" height=\"488\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20488%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv-300x183.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv.jpg\"><\/p>\n<p>Google Sheets has a variety of tools for analyzing <a href=\"https:\/\/www.jotform.com\/how-to-use-google-forms\/\" target=\"_blank\" rel=\"noopener\">Google forms<\/a> responses and other data.<\/p>\n<p>It can perform simple to complex calculations using its formulas and functions. These include sum, averages, counts, and more.<\/p>\n<p>Users can also use <strong>pivot tables<\/strong> to summarize a bulk of Google forms responses. It <strong>provides a summary of responses<\/strong> and<strong> reorganizes data<\/strong> for easier data analysis.<\/p>\n<p>To create a pivot table, click <strong>&#8216;Data&#8217;<\/strong> on the menu bar then select<strong> &#8216;Pivot table&#8217;<\/strong>.<\/p>\n<p>Google Sheets has other useful tools for generating a summary of Google forms responses. For instance, <strong><a href=\"https:\/\/wpdatatables.com\/histograms\/\">histograms<\/a>&nbsp;and pivot charts<\/strong>.<\/p>\n<p><noscript><img decoding=\"async\" class=\"alignnone wp-image-41729 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv1.jpg\" alt=\"New graph from Google forms' results\" width=\"800\" height=\"502\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv1.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv1-300x188.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41729 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20502%22%3E%3C%2Fsvg%3E\" alt=\"New graph from Google forms' results\" width=\"800\" height=\"502\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20502%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv1.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv1-300x188.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/piv1.jpg\"><\/p>\n<p>To create other types of charts, go to <strong>&#8216;Insert&#8217;<\/strong> on the menu bar then click <strong>&#8216;Chart&#8217;<\/strong>. On the <strong>Chart Editor<\/strong>, choose which type of chart to use.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Create_Google_Form_Charts_and_Publish_them_on_Your_Website\"><\/span><b>How to Create Google Form Charts and Publish them on Your Website?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Using Forminator + wpDataTables<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Using Google Forms and Google Sheets helps anyone organize surveys and analyze responses. Both make powerful statistics tools for data analysis and presentation.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">There are also other web-based tools and other methods available. These<\/span><a href=\"https:\/\/survicate.com\/blog\/google-forms-alternatives\/\"> <span style=\"font-weight: 400;\">Google form alternatives<\/span><\/a><span style=\"font-weight: 400;\"> can also build forms and create responsive tables, charts, and graphs.<\/span><\/p>\n<p><b>IvyForms<\/b><span style=\"font-weight: 400;\"> is a <\/span><b><a href=\"https:\/\/ivyforms.com\/\">WordPress form builder plugin<\/a>.<\/b><span style=\"font-weight: 400;\"> It provides an easy way to create different types of forms.<\/span><\/p>\n<p><b>wpDataTables<\/b><span style=\"font-weight: 400;\"> is a <\/span><b>WordPress table plugin.<\/b><span style=\"font-weight: 400;\"> It creates <a href=\"https:\/\/wpdatatables.com\/embed-excel-in-html\/\">responsive tables and charts from Microsoft Excel<\/a>, CSV, and PHP.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To create tables and charts from responses generated by IvyForms users need to install both plugins and use <a href=\"https:\/\/wpdatatables.com\/integrations\/ivyforms-form-builder\/\">wpDataTables &amp; IvyForms integration<\/a><\/span><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">IvyForms and wpDataTables also make a powerful combination of tools for creating surveys and data presentations. They are easy to use, free, and completely customizable. Besides IvyForms, wpDataTables also<a href=\"https:\/\/wpdatatables.com\/addons\/forminator-forms\/\">&nbsp;has free addon for Forminator<\/a>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you want to see in more detail how this works, you can check out our article on creating a<\/span><a href=\"https:\/\/wpdatatables.com\/survey-table\/\"> <span style=\"font-weight: 400;\">survey table<\/span><\/a><span style=\"font-weight: 400;\"> with Forminator and wpDataTables.<\/span><\/p>\n<p>Using Google Forms and Google Sheets helps anyone organize surveys and analyze responses. Both make powerful statistics tools for data analysis and presentation.<\/p>\n<p><a href=\"https:\/\/wpdatatables.com\/\"><noscript><img decoding=\"async\" class=\"alignnone wp-image-41733 size-full\" src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/wpdt.jpg\" alt=\"wpDataTables - tables and charts plugin\" width=\"800\" height=\"353\" srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/wpdt.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/wpdt-300x132.jpg 300w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/noscript><img decoding=\"async\" class=\"alignnone wp-image-41733 size-full lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20353%22%3E%3C%2Fsvg%3E\" alt=\"wpDataTables - tables and charts plugin\" width=\"800\" height=\"353\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20800%20353%22%3E%3C%2Fsvg%3E 800w\" sizes=\"(max-width: 800px) 100vw, 800px\" data-srcset=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/wpdt.jpg 800w, https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/wpdt-300x132.jpg 300w\" data-src=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/wpdt.jpg\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Create_Google_Forms_Pie_Chart_with_wpDataTables\"><\/span><b>How to Create Google Forms Pie Chart with wpDataTables?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><b>Step 1: Export Google Forms responses<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Open your Google Form &#8211; click on <\/span><b>Responses<\/b><span style=\"font-weight: 400;\"> &#8211;&nbsp;<\/span><b>View responses in Google Sheets<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In Google Sheets, you now have all your survey data in a structured table.<\/span><\/li>\n<\/ul>\n<h3><b>Step 2: Prepare the data<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Make sure each question\/column is clearly labeled.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">For a pie chart, you\u2019ll typically want <\/span><b>categorical data<\/b><span style=\"font-weight: 400;\"> (e.g., \u201cFavorite color,\u201d \u201cYes\/No answers\u201d)<\/span><\/li>\n<\/ul>\n<h3><b>Step 3: Create a new table in wpDataTables<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Go to your WordPress dashboard &#8211; <\/span><b>wpDataTables &#8211; Create a Table<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Choose <\/span><b>Create a table linked to an existing data source<\/b><span style=\"font-weight: 400;\"> &#8211; select your <\/span><b>Google Sheet CSV export<\/b><span style=\"font-weight: 400;\"> or upload the CSV.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">wpDataTables will automatically generate a table from your data.<\/span><\/li>\n<\/ul>\n<h3><b>Step 4: Generate the pie chart<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In wpDataTables, click on <\/span><b>Create a Chart linked to a Table<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Choose <\/span><b>Pie Chart<\/b><span style=\"font-weight: 400;\"> as the chart type.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select the table you just created as the data source.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Assign <\/span><b>labels<\/b><span style=\"font-weight: 400;\"> (categories) and <\/span><b>values<\/b><span style=\"font-weight: 400;\"> (counts or sums) for the chart.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Customize colors, labels, and legend as needed.<\/span><\/li>\n<\/ul>\n<h3><b>Step 5: Embed the pie chart<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Copy the generated <\/span><b>shortcode<\/b><span style=\"font-weight: 400;\"> from wpDataTables.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Paste it into any WordPress post or page where you want the chart to appear.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Your pie chart is now live and dynamic &#8211; updating the table automatically updates the chart.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Create_Google_Forms_Bar_Chart_with_wpDataTables\"><\/span><b>How to Create Google Forms Bar Chart with wpDataTables?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><b>Step 1: Export Google Forms responses<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Same as above: open your Form &#8211; <\/span><b>Responses &#8211; Google Sheets<\/b><span style=\"font-weight: 400;\"> &#8211; export or use CSV.<\/span><\/li>\n<\/ul>\n<h3><b>Step 2: Prepare the data<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Identify which column you want to measure (numerical or categorical counts).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Bar charts work best with <\/span><b>aggregated values<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<h3><b>Step 3: Create a new table in wpDataTables<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Create Table &#8211; Upload CSV \/ Link to Google Sheet<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ensure columns are named correctly and data types are recognized (number, string, date).<\/span><\/li>\n<\/ul>\n<h3><b>Step 4: Generate the bar chart<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click <\/span><b>Create Chart linked to a Table<\/b><span style=\"font-weight: 400;\"> &#8211; select <\/span><b>Bar Chart<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Assign <\/span><b>X-axis<\/b><span style=\"font-weight: 400;\"> (categories) and <\/span><b>Y-axis<\/b><span style=\"font-weight: 400;\"> (values).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Customize chart settings: stacked bars, orientation, colors, labels.<\/span><\/li>\n<\/ul>\n<h3><b>Step 5: Embed the bar chart<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Copy the <\/span><b>shortcode<\/b><span style=\"font-weight: 400;\"> generated by wpDataTables.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Paste it into your WordPress page or post.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Any updates in the table (manual or via Google Sheet import) reflect automatically in the chart.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"FAQ_on_How_to_Create_Results_Charts_from_Google_Forms\"><\/span><b>FAQ on How to Create Results Charts from Google Forms<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"How do I start creating graphs from Google Forms data?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Well, first up, you\u2019ve got to have some responses on your form, right? Once you've got those, head over to the 'Responses' tab in Google Forms. You'll see a summary with auto-generated graphs. For more control, click that green icon to hop into Google Sheets for some graphing action.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Can I customize the types of graphs generated from responses?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Absolutely, you bet. In Google Sheets, click on your data and look for the 'Chart' icon. From there, sky's the limit. Choose from\u00a0bar graphs\u00a0to\u00a0pie charts\u00a0and even\u00a0line graphs. Tweak them until they're telling your data's story in the clearest way possible.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What's the deal with integrating Google Forms with Google Sheets?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"It\u2019s pretty cool, actually. When you're in Google Forms, just click on that green Sheets icon, and boom \u2013 it zaps your data straight into a new sheet. This is where the magic happens. All your data, neatly organized and ripe for turning into insightful\u00a0visual data presentations.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How can I share my Google Forms results graphs?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Sharing is caring, right? If you want to share your Google Forms results\u2019 graphs on your website, wpDataTables is the answer.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Is it possible to analyze multiple-choice questions using graphs?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"For sure, multiple-choice questions are basically asking to be graphed. They\u2019re awesome for quick\u00a0data visualization. Each option gets its own slice of the pie in a\u00a0pie chart\u00a0or its own bar in a, well,\u00a0bar graph. Patterns will pop out, and you'll see what's trending in no time.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How do I display open-ended responses in a graph?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"That's a bit tricker, but here\u2019s the scoop. You might want to look into creating a word cloud for high-level vibes or tally up common phrases for a\u00a0bar graph. Honestly, it\u2019s more about spotting trends and presenting them in a\u00a0data visualization tool\u00a0like a word frequency chart.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Can I create a graph comparing responses over time?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Oh, we're getting fancy \u2013 and yes, you can. As you collect responses, you can plot them out on a\u00a0line chart\u00a0within Google Sheets. This way, you can track how responses evolve, bump up, and dip down. Time becomes your secret ingredient in the data storytelling mix.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What are some tips for making my Google Forms results graphs look professional?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Key things to keep clean - stick to a color scheme that isn't a rainbow explosion, keep fonts readable, and don't go overboard with gridlines. Remember, simplicity is your ally\u2014let your data do the talking without the flamboyant accessories.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How can I ensure my graphs accurately represent my Google Forms data?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Data integrity, important stuff. Double-check that your ranges are correct when you set up the chart. Ensure that you're not mixing apples with spaceships, and keep an eye on the scales on your axes \u2013 they should make sense for the range of data you have.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What should I do if I have too much data to display in a single graph?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Don't cram it! If you\u2019ve got loads of data, think about making a series of graphs or even a dashboard. Group related pieces together, create individual\u00a0charts\u00a0for different question sets, and give your viewers a chance to digest each bit. It's like a tapas bar \u2013 small plates, big flavors.\"\n    }\n  }]\n}\n<\/script><\/p>\n<h3 id=\"how-do-i-start-creating-graphs-from-google-forms-data-\">How do I start creating graphs from Google Forms data?<\/h3>\n<p>Well, first up, you\u2019ve got to have some responses on your form, right? Once you&#8217;ve got those, head over to the &#8216;Responses&#8217; tab in Google Forms. You&#8217;ll see a summary with auto-generated graphs. For more control, click that green icon to hop into Google Sheets for some graphing action.<\/p>\n<h3 id=\"can-i-customize-the-types-of-graphs-generated-from-responses-\">Can I customize the types of graphs generated from responses?<\/h3>\n<p>Absolutely, you bet. In Google Sheets, click on your data and look for the &#8216;Chart&#8217; icon. From there, sky&#8217;s the limit. Choose from&nbsp;<strong>bar graphs<\/strong>&nbsp;to&nbsp;<a href=\"https:\/\/wpdatatables.com\/pie-charts-guide\/\"><strong>pie charts<\/strong><\/a>&nbsp;and even&nbsp;<strong>line graphs<\/strong>. Tweak them until they&#8217;re telling your data&#8217;s story in the clearest way possible.<\/p>\n<h3 id=\"what-s-the-deal-with-integrating-google-forms-with-google-sheets-\">What&#8217;s the deal with integrating Google Forms with Google Sheets?<\/h3>\n<p>It\u2019s pretty cool, actually. When you&#8217;re in Google Forms, just click on that green Sheets icon, and boom \u2013 it zaps your data straight into a new sheet. This is where the magic happens. All your data, neatly organized and ripe for turning into insightful&nbsp;<strong>visual data presentations<\/strong>.<\/p>\n<h3 id=\"how-can-i-share-my-google-forms-results-graphs-\">How can I share my Google Forms results graphs?<\/h3>\n<p><span style=\"font-weight: 400;\">Sharing is caring, right? If you want to share your Google Forms results\u2019 graphs on your website, wpDataTables is the answer.<\/span><\/p>\n<h3 id=\"is-it-possible-to-analyze-multiple-choice-questions-using-graphs-\">Is it possible to analyze multiple-choice questions using graphs?<\/h3>\n<p>For sure, multiple-choice questions are basically asking to be graphed. They\u2019re awesome for quick&nbsp;<strong>data visualization<\/strong>. Each option gets its own slice of the pie in a&nbsp;<strong>pie chart<\/strong>&nbsp;or its own bar in a, well,&nbsp;<strong>bar graph<\/strong>. Patterns will pop out, and you&#8217;ll see what&#8217;s trending in no time.<\/p>\n<h3 id=\"how-do-i-display-open-ended-responses-in-a-graph-\">How do I display open-ended responses in a graph?<\/h3>\n<p>That&#8217;s a bit tricker, but here\u2019s the scoop. You might want to look into creating a word cloud for high-level vibes or tally up common phrases for a&nbsp;<strong>bar graph<\/strong>. Honestly, it\u2019s more about spotting trends and presenting them in a&nbsp;<strong>data visualization tool<\/strong>&nbsp;like a word frequency chart.<\/p>\n<h3 id=\"can-i-create-a-graph-comparing-responses-over-time-\">Can I create a graph comparing responses over time?<\/h3>\n<p>Oh, we&#8217;re getting fancy \u2013 and yes, you can. As you collect responses, you can plot them out on a&nbsp;<strong>line chart<\/strong>&nbsp;within Google Sheets. This way, you can track how responses evolve, bump up, and dip down. Time becomes your secret ingredient in the data storytelling mix.<\/p>\n<h3 id=\"what-are-some-tips-for-making-my-google-forms-results-graphs-look-professional-\">What are some tips for making my Google Forms results graphs look professional?<\/h3>\n<p>Key things to keep clean &#8211; stick to a color scheme that isn&#8217;t a rainbow explosion, keep fonts readable, and don&#8217;t go overboard with gridlines. Remember, simplicity is your ally\u2014let your data do the talking without the flamboyant accessories.<\/p>\n<h3 id=\"how-can-i-ensure-my-graphs-accurately-represent-my-google-forms-data-\">How can I ensure my graphs accurately represent my Google Forms data?<\/h3>\n<p>Data integrity, important stuff. Double-check that your ranges are correct when you set up the chart. Ensure that you&#8217;re not mixing apples with spaceships, and keep an eye on the scales on your axes \u2013 they should make sense for the range of data you have.<\/p>\n<h3 id=\"what-should-i-do-if-i-have-too-much-data-to-display-in-a-single-graph-\">What should I do if I have too much data to display in a single graph?<\/h3>\n<p>Don&#8217;t cram it! If you\u2019ve got loads of data, think about making a series of graphs or even a dashboard. Group related pieces together, create individual&nbsp;<strong>charts<\/strong>&nbsp;for different question sets, and give your viewers a chance to digest each bit. It&#8217;s like a tapas bar \u2013 small plates, big flavors.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p data-start=\"161\" data-end=\"445\">We\u2019ve now covered the essentials of how to create a Google Forms results graph and turn raw responses into clear, useful insights. Visualizing data with pie charts, bar graphs, or line charts makes it much easier to understand patterns and share results effectively.<\/p>\n<p data-start=\"447\" data-end=\"476\">Key things to keep in mind:<\/p>\n<ul>\n<li data-start=\"479\" data-end=\"504\">Keep your visuals clean<\/li>\n<li data-start=\"479\" data-end=\"504\">Stay accurate to your data<\/li>\n<li data-start=\"479\" data-end=\"504\">Present results with clarity<\/li>\n<\/ul>\n<p data-start=\"570\" data-end=\"712\">You now have practical ways to make your Google Forms results more meaningful.<\/p>\n<p data-start=\"754\" data-end=\"1268\">If you\u2019d like to go further, you can explore <a href=\"https:\/\/wpdatatables.com\/embed-a-chart\/\">how to embed a chart on your website<\/a>, compare different <a href=\"https:\/\/wpdatatables.com\/survey-graph-maker\/\">survey graph makers<\/a>, or dive into guides on <a href=\"https:\/\/wpdatatables.com\/survey-chart\/\">survey chart types<\/a> and <a href=\"https:\/\/wpdatatables.com\/survey-table\/\">survey tables<\/a>.<\/p>\n<p data-start=\"754\" data-end=\"1268\">For more advanced visualization, check out tutorials on <a href=\"https:\/\/wpdatatables.com\/chart-js-examples\/\">Chart.js examples<\/a>, practical tips for <a href=\"https:\/\/wpdatatables.com\/chart-designs\/\">chart designs<\/a>, or comparisons of <a href=\"https:\/\/wpdatatables.com\/types-of-charts\/\">types of charts<\/a> and <a href=\"https:\/\/wpdatatables.com\/highcharts-alternative\/\">Highcharts alternatives<\/a>. And if you\u2019re working in WordPress, our resources on <a href=\"https:\/\/wpdatatables.com\/wordpress-charts\/\">WordPress charts<\/a> will help you present data on your site without writing a line of code.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ever had a mountain of survey responses staring back at you, daring you to make sense of them? Yeah, me too.\u00a0 But here&#8217;s a secret: it\u2019s easier than you thought to create charts from those Google Forms results and publish them on your website. Stick around, because by the time we finish this chat, you&#8217;ll [&hellip;]<\/p>\n","protected":false},"author":1693,"featured_media":41737,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[455],"tags":[],"class_list":["post-41696","post","type-post","status-publish","format-standard","hentry","category-data-visualization"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Create Charts from Google Forms\u2019 Results &amp; Publish on Your Website?<\/title>\n<meta name=\"description\" content=\"Learn how to create charts from Google Forms results and publish them on your website. Turn survey responses into graphs, pie charts, and bar charts directly from Google Forms.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wpdatatables.com\/google-forms-results-graph\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create Charts from Google Forms\u2019 Results &amp; Publish on Your Website?\" \/>\n<meta property=\"og:description\" content=\"Learn how to create charts from Google Forms results and publish them on your website. Turn survey responses into graphs, pie charts, and bar charts directly from Google Forms.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wpdatatables.com\/google-forms-results-graph\/\" \/>\n<meta property=\"og:site_name\" content=\"wpDataTables - Tables and Charts WordPress Plugin\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/wpdatatables\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-06T08:36:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-27T16:00:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"516\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Tamara Jovanovic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@wpdatatables\" \/>\n<meta name=\"twitter:site\" content=\"@wpdatatables\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tamara Jovanovic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/\"},\"author\":{\"name\":\"Tamara Jovanovic\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#\\\/schema\\\/person\\\/10a1e870afba3f0ddab0b8f3c1d9837d\"},\"headline\":\"How to Create Charts from Google Forms\u2019 Results &#038; Publish on Your Website?\",\"datePublished\":\"2025-10-06T08:36:43+00:00\",\"dateModified\":\"2025-10-27T16:00:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/\"},\"wordCount\":2274,\"publisher\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wpdatatables.com\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/cu2-1.jpg\",\"articleSection\":[\"Data visualization\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/\",\"url\":\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/\",\"name\":\"How to Create Charts from Google Forms\u2019 Results & Publish on Your Website?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wpdatatables.com\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/cu2-1.jpg\",\"datePublished\":\"2025-10-06T08:36:43+00:00\",\"dateModified\":\"2025-10-27T16:00:09+00:00\",\"description\":\"Learn how to create charts from Google Forms results and publish them on your website. Turn survey responses into graphs, pie charts, and bar charts directly from Google Forms.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wpdatatables.com\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/cu2-1.jpg\",\"contentUrl\":\"https:\\\/\\\/wpdatatables.com\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/cu2-1.jpg\",\"width\":900,\"height\":516,\"caption\":\"How to create charts from Google forms results\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/google-forms-results-graph\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wpdatatables.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create Charts from Google Forms\u2019 Results &#038; Publish on Your Website?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#website\",\"url\":\"https:\\\/\\\/wpdatatables.com\\\/\",\"name\":\"wpDataTables - Tables and Charts WordPress Plugin\",\"description\":\"Tables and Charts Creator\",\"publisher\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wpdatatables.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#organization\",\"name\":\"wpDataTables\",\"url\":\"https:\\\/\\\/wpdatatables.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/wpdatatables.com\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/wpDataTable-Horizontal.png\",\"contentUrl\":\"https:\\\/\\\/wpdatatables.com\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/wpDataTable-Horizontal.png\",\"width\":4120,\"height\":756,\"caption\":\"wpDataTables\"},\"image\":{\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/wpdatatables\\\/\",\"https:\\\/\\\/x.com\\\/wpdatatables\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCR-VfulTsxPa41S1D7fFKqg\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/wpdatatables.com\\\/#\\\/schema\\\/person\\\/10a1e870afba3f0ddab0b8f3c1d9837d\",\"name\":\"Tamara Jovanovic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/66705e5dda3eb7a94ebe58da7e65e8aa63f06bad1ff620ccba26683f7d53bc7e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/66705e5dda3eb7a94ebe58da7e65e8aa63f06bad1ff620ccba26683f7d53bc7e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/66705e5dda3eb7a94ebe58da7e65e8aa63f06bad1ff620ccba26683f7d53bc7e?s=96&d=mm&r=g\",\"caption\":\"Tamara Jovanovic\"},\"description\":\"Tamara Jovanovic is an SEO Content Specialist who enjoys learning about different industries, people, and how to solve problems through content. She is curious by nature and eager to experiment with new ideas that could provide value to readers. Often she spends hours analyzing why things worked or didn\u2019t so she could be equipped with data and improve with every new task. Likes reading, learning, playing games, growing plants, and enjoying a good cup of coffee.\",\"url\":\"https:\\\/\\\/wpdatatables.com\\\/author\\\/tamara\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create Charts from Google Forms\u2019 Results & Publish on Your Website?","description":"Learn how to create charts from Google Forms results and publish them on your website. Turn survey responses into graphs, pie charts, and bar charts directly from Google Forms.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wpdatatables.com\/google-forms-results-graph\/","og_locale":"en_US","og_type":"article","og_title":"How to Create Charts from Google Forms\u2019 Results & Publish on Your Website?","og_description":"Learn how to create charts from Google Forms results and publish them on your website. Turn survey responses into graphs, pie charts, and bar charts directly from Google Forms.","og_url":"https:\/\/wpdatatables.com\/google-forms-results-graph\/","og_site_name":"wpDataTables - Tables and Charts WordPress Plugin","article_publisher":"https:\/\/www.facebook.com\/wpdatatables\/","article_published_time":"2025-10-06T08:36:43+00:00","article_modified_time":"2025-10-27T16:00:09+00:00","og_image":[{"width":900,"height":516,"url":"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2-1.jpg","type":"image\/jpeg"}],"author":"Tamara Jovanovic","twitter_card":"summary_large_image","twitter_creator":"@wpdatatables","twitter_site":"@wpdatatables","twitter_misc":{"Written by":"Tamara Jovanovic","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wpdatatables.com\/google-forms-results-graph\/#article","isPartOf":{"@id":"https:\/\/wpdatatables.com\/google-forms-results-graph\/"},"author":{"name":"Tamara Jovanovic","@id":"https:\/\/wpdatatables.com\/#\/schema\/person\/10a1e870afba3f0ddab0b8f3c1d9837d"},"headline":"How to Create Charts from Google Forms\u2019 Results &#038; Publish on Your Website?","datePublished":"2025-10-06T08:36:43+00:00","dateModified":"2025-10-27T16:00:09+00:00","mainEntityOfPage":{"@id":"https:\/\/wpdatatables.com\/google-forms-results-graph\/"},"wordCount":2274,"publisher":{"@id":"https:\/\/wpdatatables.com\/#organization"},"image":{"@id":"https:\/\/wpdatatables.com\/google-forms-results-graph\/#primaryimage"},"thumbnailUrl":"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2-1.jpg","articleSection":["Data visualization"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/wpdatatables.com\/google-forms-results-graph\/","url":"https:\/\/wpdatatables.com\/google-forms-results-graph\/","name":"How to Create Charts from Google Forms\u2019 Results & Publish on Your Website?","isPartOf":{"@id":"https:\/\/wpdatatables.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wpdatatables.com\/google-forms-results-graph\/#primaryimage"},"image":{"@id":"https:\/\/wpdatatables.com\/google-forms-results-graph\/#primaryimage"},"thumbnailUrl":"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2-1.jpg","datePublished":"2025-10-06T08:36:43+00:00","dateModified":"2025-10-27T16:00:09+00:00","description":"Learn how to create charts from Google Forms results and publish them on your website. Turn survey responses into graphs, pie charts, and bar charts directly from Google Forms.","breadcrumb":{"@id":"https:\/\/wpdatatables.com\/google-forms-results-graph\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wpdatatables.com\/google-forms-results-graph\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wpdatatables.com\/google-forms-results-graph\/#primaryimage","url":"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2-1.jpg","contentUrl":"https:\/\/wpdatatables.com\/wp-content\/uploads\/2021\/08\/cu2-1.jpg","width":900,"height":516,"caption":"How to create charts from Google forms results"},{"@type":"BreadcrumbList","@id":"https:\/\/wpdatatables.com\/google-forms-results-graph\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wpdatatables.com\/"},{"@type":"ListItem","position":2,"name":"How to Create Charts from Google Forms\u2019 Results &#038; Publish on Your Website?"}]},{"@type":"WebSite","@id":"https:\/\/wpdatatables.com\/#website","url":"https:\/\/wpdatatables.com\/","name":"wpDataTables - Tables and Charts WordPress Plugin","description":"Tables and Charts Creator","publisher":{"@id":"https:\/\/wpdatatables.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wpdatatables.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/wpdatatables.com\/#organization","name":"wpDataTables","url":"https:\/\/wpdatatables.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wpdatatables.com\/#\/schema\/logo\/image\/","url":"https:\/\/wpdatatables.com\/wp-content\/uploads\/2019\/02\/wpDataTable-Horizontal.png","contentUrl":"https:\/\/wpdatatables.com\/wp-content\/uploads\/2019\/02\/wpDataTable-Horizontal.png","width":4120,"height":756,"caption":"wpDataTables"},"image":{"@id":"https:\/\/wpdatatables.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/wpdatatables\/","https:\/\/x.com\/wpdatatables","https:\/\/www.youtube.com\/channel\/UCR-VfulTsxPa41S1D7fFKqg"]},{"@type":"Person","@id":"https:\/\/wpdatatables.com\/#\/schema\/person\/10a1e870afba3f0ddab0b8f3c1d9837d","name":"Tamara Jovanovic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/66705e5dda3eb7a94ebe58da7e65e8aa63f06bad1ff620ccba26683f7d53bc7e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/66705e5dda3eb7a94ebe58da7e65e8aa63f06bad1ff620ccba26683f7d53bc7e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/66705e5dda3eb7a94ebe58da7e65e8aa63f06bad1ff620ccba26683f7d53bc7e?s=96&d=mm&r=g","caption":"Tamara Jovanovic"},"description":"Tamara Jovanovic is an SEO Content Specialist who enjoys learning about different industries, people, and how to solve problems through content. She is curious by nature and eager to experiment with new ideas that could provide value to readers. Often she spends hours analyzing why things worked or didn\u2019t so she could be equipped with data and improve with every new task. Likes reading, learning, playing games, growing plants, and enjoying a good cup of coffee.","url":"https:\/\/wpdatatables.com\/author\/tamara\/"}]}},"_links":{"self":[{"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/posts\/41696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/users\/1693"}],"replies":[{"embeddable":true,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/comments?post=41696"}],"version-history":[{"count":18,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/posts\/41696\/revisions"}],"predecessor-version":[{"id":56361,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/posts\/41696\/revisions\/56361"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/media\/41737"}],"wp:attachment":[{"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/media?parent=41696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/categories?post=41696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wpdatatables.com\/wp-json\/wp\/v2\/tags?post=41696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}