{"id":265847,"date":"2024-03-13T20:07:10","date_gmt":"2024-03-13T19:07:10","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=265847"},"modified":"2026-10-28T14:27:10","modified_gmt":"2026-10-28T13:27:10","slug":"grafico-de-funil-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/funnel-chart\/","title":{"rendered":"Gr\u00e1ficos de funil explicados (guia completo)"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>When you want to illustrate your sales funnel data, what could be better than a funnel chart? In fact, you can use them to illustrate any multi-stage process where the numbers decrease with each stage. In addition to the sales funnel, these charts are often used to represent the recruitment funnel, order fulfillment, and website traffic engagement.<\/p>\n<p>In this guide, you will learn what a funnel chart is and what it\u2019s used for, as well as how to create one in Google Sheets. While Microsoft Excel has a built-in funnel chart type, you&#8217;ll need a few extra steps if you want one in Google Sheets. Fortunately, they\u2019re very easy steps. You have detailed instructions on how to set up the data and customize the standard stacked bar chart into a funnel chart. You also have examples showing how to create a sales funnel chart and a recruitment funnel chart.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-a-funnel-chart&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What is a funnel chart?<\/h2>\n<p>Funnel charts provide a high-level view of a multi-stage process, where the measured value decreases with each stage. Each stage is represented by a bar, starting with the initial total value at the top. Each bar is smaller than the previous one, making the chart look like a funnel.<\/p>\n<p>While the length or width of these horizontal bars changes according to the value, their height is equal. The values used are usually the totals for each stage, so the \u2018steps\u2019 between stages are quite large. If you have very detailed data for each stage, you can create a funnel chart that uses trapezoids instead of bars so that the bottom of a stage matches the top of the next stage. However, be careful how you divide the stages and substages, as you may get a distorted view of your data.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-a-funnel-chart-used-for&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What is a funnel chart used for?<\/h2>\n<p>The funnel chart type best illustrates multi-stage processes where values decrease with each stage. Ideally, these processes should have more than three stages; otherwise, a pie or bar chart is more suitable. For example, funnel charts are an excellent way to illustrate the sales funnel or recruitment funnel stages.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-create-a-funnel-chart-in-google-s&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to create a funnel chart in Google Sheets?<\/h2>\n<p>Since Google Sheets does not offer a built-in option for funnel charts, you will need to make some adjustments to a standard <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-create-a-bar-chart-in-google-sheets\/\">stacked bar chart<\/a>. This will require creating a helper column with data, which you will later hide on the chart itself. Follow the steps below to set up your data, insert the stacked bar chart, and finally, customize it to look like a funnel chart.<\/p>\n<h3>1. Set up the data<\/h3>\n<p>First, you must set up your data and add a helper column.<\/p>\n<p><strong>1. <\/strong>Open Google Sheets and list your stages and the corresponding values.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-stage-data.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 five stages listed in column A with their values in column B&#8221; title_text=&#8221;Five stages listed in column A with their values in column B&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>Insert a helper column to the left of the column with the values.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-insert-helper-column.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 right-click menu on column B with Insert 1 column left&#8221; title_text=&#8221;Right-click menu on column B with Insert 1 column left&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>Type an equals sign and an opening parenthesis, then select the highest value using <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/absolute-cell-reference\/\">absolute referencing<\/a>. You could also use the MAX function, but if the data is appropriate for a funnel chart, the highest value should be the first.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-highest-value.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 helper column formula starting with =($C$1&#8243; title_text=&#8221;Helper column formula starting with =($C$1&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>Add a minus sign and select the value for stage one (in this case, it&#8217;s the highest value), but using relative instead of absolute referencing. Close the parenthesis.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-current-value.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 formula =($C$1-C1) in the helper column&#8221; title_text=&#8221;Formula =($C$1-C1) in the helper column&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5. <\/strong>Divide the result by two and press \u2018Enter\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-divide-by-two.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 formula =($C$1-C1)\/2 in cell B1&#8243; title_text=&#8221;Formula =($C$1-C1)\/2 in cell B1&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6. <\/strong>Grab the fill handle and drag it down to the last stage.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-copy-formula.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 helper formula filled down to B5 with values 0 to 255&#8243; title_text=&#8221;Helper formula filled down to B5 with values 0 to 255&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>2. Insert bar chart<\/h3>\n<p>Since Google Sheets has no built-in funnel chart type, you\u2019ll need to build on a standard stacked bar chart.<\/p>\n<p><strong>1. <\/strong>Select all three columns and go to Insert &gt; Chart.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-insert-chart-menu.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 data selected and Insert menu open with Chart&#8221; title_text=&#8221;Data selected and Insert menu open with Chart&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>In the \u2018Chart editor\u2019, check that the chart type is \u2018Stacked bar chart\u2019 with \u2018Standard\u2019 stacking.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-stacked-bar-chart.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 Chart editor set to Stacked bar chart with Standard stacking&#8221; title_text=&#8221;Chart editor set to Stacked bar chart with Standard stacking&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>3. Customize funnel chart<\/h3>\n<p>As mentioned, you\u2019ll need to make some adjustments to your chart to turn it into a funnel chart.<\/p>\n<p><strong>1. <\/strong>Under \u2018Customize\u2019 in the \u2018Chart editor\u2019, go to \u2018Series\u2019 and select the data from the helper column: &#8216;Bar 1&#8217;. Change the bar\u2019s color to match the background color; in this case, I have chosen white.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-hide-helper-series.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 Series Bar 1 fill color set to white, leaving a funnel of red bars&#8221; title_text=&#8221;Series Bar 1 fill color set to white, leaving a funnel of red bars&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>Select \u2018Bar 2\u2019 from the drop-down list and check the box that says \u2018Data labels\u2019. Under \u2018Position\u2019, select \u2018Center\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-data-labels.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 Bar 2 series with Data labels checked and Center position&#8221; title_text=&#8221;Bar 2 series with Data labels checked and Center position&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>Click on \u2018Legend\u2019 to expand the options and select \u2018None\u2019 under \u2018Position\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-remove-legend.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 Legend position set to None in the Chart editor&#8221; title_text=&#8221;Legend position set to None in the Chart editor&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>Under \u2018Gridlines and ticks\u2019, uncheck the box that says \u2018Major gridlines\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-remove-gridlines.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 Gridlines and ticks with Major gridlines unchecked&#8221; title_text=&#8221;Gridlines and ticks with Major gridlines unchecked&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5. <\/strong>To hide the horizontal axis, change the \u2018Text color\u2019 to match the background color.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-hide-horizontal-axis.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 Horizontal axis text color set to white&#8221; title_text=&#8221;Horizontal axis text color set to white&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6. <\/strong>Finally, you can add a title for your chart under \u2018Chart &amp; axis titles\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-add-title.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 chart title 5-Stage Funnel Chart typed in Chart &#038; axis titles&#8221; title_text=&#8221;Chart title 5-Stage Funnel Chart typed in Chart &#038; axis titles&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;funnel-chart-examples&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Funnel chart examples<\/h2>\n<p>Below are two typical examples of funnel charts and the type of data with which you can use them: the sales funnel and the recruitment funnel.<\/p>\n<h3>Sales funnel<\/h3>\n<p>Follow the steps below to create a funnel chart based on your sales conversion data.<\/p>\n<p><strong>1. <\/strong>Set up your data and add the helper column, as shown in the previous section.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-sales-data.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 sales stages from prospects to purchased with a helper column&#8221; title_text=&#8221;Sales stages from prospects to purchased with a helper column&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>Select the data and go to Insert &gt; Chart.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-sales-insert-chart.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 sales data selected and Insert menu open with Chart&#8221; title_text=&#8221;Sales data selected and Insert menu open with Chart&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>Ensure that the standard \u2018Stacked bar chart\u2019 is selected.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-sales-stacked-bar.webp&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 sales data as a standard stacked bar chart in the Chart editor&#8221; title_text=&#8221;Sales data as a standard stacked bar chart in the Chart editor&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>Follow the instructions in the previous section to customize the chart and turn it into a funnel chart.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-sales-funnel.png&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 finished Sales Funnel Chart from 300 prospects to 25 purchases&#8221; title_text=&#8221;Finished Sales Funnel Chart from 300 prospects to 25 purchases&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Recruitment funnel<\/h3>\n<p>Follow the steps below to create a funnel chart based on your recruitment process data.<\/p>\n<p><strong>1. <\/strong>Add the helper column to your recruitment funnel data, as shown in an earlier section.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-recruitment-data.png&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 recruitment stages from potential to hired with a helper column&#8221; title_text=&#8221;Recruitment stages from potential to hired with a helper column&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>Select the three columns of data and go to Insert &gt; Chart.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-recruitment-insert-chart.png&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 recruitment data selected and Insert menu open with Chart&#8221; title_text=&#8221;Recruitment data selected and Insert menu open with Chart&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>Select the \u2018Stacked bar chart\u2019 and choose \u2018Standard\u2019 stacking.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-recruitment-stacked-bar.png&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 recruitment data as a standard stacked bar chart&#8221; title_text=&#8221;Recruitment data as a standard stacked bar chart&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>Customize your recruitment funnel chart, as shown in an earlier section.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/funnel-chart-google-sheets-recruitment-funnel.png&#8221; alt=&#8221;Funnel chart Google Sheets \u2014 finished Recruitment Funnel Chart from potential candidates to hired&#8221; title_text=&#8221;Finished Recruitment Funnel Chart from potential candidates to hired&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>Funnel charts provide a simple but effective illustration of how values decrease as a multi-stage process advances. You can use them to show your sales conversion data, your order fulfillment data, or your recruitment data. The more detailed and structured your data is, the more clearly you can identify potential bottlenecks in your processes. If your funnel numbers live in several spreadsheets, <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo<\/a>, an AI-powered data automation platform, can bring them into one sheet so your funnel chart stays up to date.<\/p>\n<p>You now know what a funnel chart is and what types of data it\u2019s usually used to illustrate. You also know that, unlike Microsoft Excel, Google Sheets doesn&#8217;t have a built-in funnel chart type, but you have step-by-step instructions on how to set up the data and add a helper column, insert a stacked bar chart, and customize it to turn it into a funnel chart.<\/p>\n<p>Check out the guides below to learn more about creating different types of charts and graphs in Google Sheets.<\/p>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/waterfall-chart-google-sheets\/\">How to create a waterfall chart in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-make-a-pie-chart-in-google-sheets\/\">How to make a pie chart in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/project-management-processes\/how-to-create-a-gantt-chart-in-google-sheets\/\">How to create a gantt chart in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-make-a-line-graph-in-google-sheets\/\">How to make a line graph in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/golayer.io\/blog\/google-sheets\/how-to-make-a-graph-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">How to make a graph in Google Sheets (step-by-step)<\/a><\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Guia do gr\u00e1fico de funil no Google Sheets: aprenda o que \u00e9 um gr\u00e1fico de funil e crie um a partir de um gr\u00e1fico de barras empilhadas com uma coluna auxiliar, com exemplos de vendas e recrutamento.<\/p>","protected":false},"author":2,"featured_media":265870,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-265847","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/265847","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=265847"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/265847\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/265870"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=265847"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=265847"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=265847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}