How to Make a Funnel Chart in Google Sheets
A funnel chart is used to visualize different phases of a sales process. The purpose of a funnel chart is to represent the amount of revenue for each stage. A funnel chart makes it easy for readers to understand the bottlenecks in the sales process.
In this article, you’ll learn a step-by-step guide about how to make a funnel chart in Google Sheets and EdrawMax Online.
How to make a funnel chart in Google sheets
Enable Google Spreadsheets in the browser on your computer and click on the “Blank” tab to open a Google spreadsheet.
Insert your data values in the sheet for which you want to create a funnel chart google sheets. You can see the sample data inserted into the sheet in the below image.
To create a funnel chart in google sheets for your data, you’ll need to use a stacked bar chart. You can make the base bars transparent to give a visual of a funnel chart.
Now create a helper column which we’ll make transparent after on. You can see a sample helper column in the below image.
Now, insert a chart. Click the Insert tab and then select the Chart. From the Chart Editor, set the Chart Type to Stacked Bar Chart. See the chart in the below image.
Now, we need to remove the helper bars to give a visual of a funnel chart. To make the helper column bars transparent, double-click on a blue bar. Then, the chart editor will appear. From the chart editor, go to the Color tab and set the color to none. You can see in the below image.
When you set the color of Helper Columns to None, the base bars will disappear, and we’ll have a funnel chart as a result. Here’s our funnel chart in the below image.
Now, a final step is to save our funnel chart to the computer. To download the funnel chart to your computer, click the File tab, then go to the Download option and select the format you want.
How to make a funnel chart in EdrawMax
Log in to your EdrawMax account and start to make a funnel chart for free. Go to the Marketing tab and find Funnel Charts on the right panel wit the pre-made templates.
When you click the Funnel Charts tab, many templates will appear in the lower section. Either you can choose a template or create a new funnel chart from scratch, click on the template, or the large + icon to open the EdrawMax Online editor.
To create a funnel chart from scratch, go to the Symbol Library, click Marketing, and mark the Funnel. Then click OK from the dialogue box. Now, the Funnel symbols will be accessible in the right library pane.
Now, drag and drop a Funnel symbol from the Symbol Library to the editor window. Then, you’ll be able to edit the symbol. Click on the sample text in the symbol and replace the content with the stages of the sale process.
How to Export an Edraw Chart as a common chart
After you have created your funnel chart in EdrawMax, you can export it to your computer in different formats. From the Export menu, select any format you want for your funnel chart. You can export your Edraw chart to cloud storage like Dropbox and Google Drive as well. You can see different formats from the Export menu in the below picture.