The best way for you to track your sales is to use a funnel chart. A sales funnel chart not only describes the stages of the process but also provides a conversion funnel for your new business.
And in today’s post, I’m going to show you the exact steps which you can use to create sales funnel chart in Excel. Well, not just sales you can use this funnel chart in any process.
And now, let’s get started.
Steps To Create a Sales Funnel Chart in Excel
You have the following data table for this chart template which you can download from here to follow along.
- First of all, insert a dummy data column.
- In cell B2, insert the below formula into the formula bar and drag it down.
- To set up sales funnel just select the data and insert a stacked bar chart.
- Now, you have a chart like this.
- From here, we need the following customization to transform this chart into a sales funnel chart.
- Now, select the vertical axis and change the category in reverse order. Format Axis → Axis Options → Axis Position.
- After that, select the data bar for dummy data and remove fill color and border from it.
- In the end, select data bars and change gap width to 0%. Format Data Series → Series Option → Gap Width.
- And now, you have a neat and clean funnel chart to use as a template.
Congratulations! you made it.
[Bonus Tip] Funnel Chart Using REPT Function
As I earlier said that I’m a big fan of in-cell charting. Let me show you how can we use the rept function to create a sales funnel template in Excel. Creating an in-cell sales funnel chart is simple and quick, here are the steps.
- Take data in a simple form.
- In the blank column, enter below formula and drag it down.
- And now, change the text alignment to the center for bars.
Your in-cell funnel chart is ready.
Download Sales Funnel Template
Click here to download the sample file.
Using a sales funnel chart is one of the best ways of tracking a sale process. You can also add additional things in a chart as well, like conversion rate, pending percentage, etc.
All the steps which you have used above are simple and easy to follow. And, if you don’t want to put efforts you go with an in-cell version.
I hope this tip helps you to get better at charting.
Now tell me one thing. Which method do you like the most? And, if you have any other method to create a funnel chart, please share it with me in the comment box, I’d love to hear from you. And, please don’t forget to share this tip with your friends.
More Charting Tips and Tutorials
- How to Add a Horizontal Line in a Chart in Excel
- How to Add a Vertical Line in a Chart in Excel
- How to Create a Bullet Chart in Excel
- How to Create a Dynamic Chart Range in Excel
- How to Create a Dynamic Chart Title in Excel
- How to Create a Sales Funnel Chart in Excel
- How to Create a HEAT MAP in Excel
- How to Create a HISTOGRAM in Excel
- How to Create a Pictograph in Excel
- How to Create a Milestone Chart in Excel
- How to Insert a People Graph in Excel
- How to Create PIVOT CHART in Excel
- How to Create a Population Pyramid Chart in Excel
- How to Create a SPEEDOMETER Chart [Gauge] in Excel
- How to Create a Step Chart in Excel
- How to Create a Thermometer Chart in Excel
- How to Create a Tornado Chart in Excel
- How to Create Waffle Chart in Excel
6 thoughts on “Excel Funnel Chart (Template + Steps to Create)”
It says enter formula =(MAX($I$4:$I$7)-I4)/2 – but that makes no sense at all.
Hello Sir, really this helps a lot in our day today work. I didn’t understand like how to change the color of the each chart and how to insert the buttons as you did (Q1, Q2, Q3, Q4) Can you please help me with that
In-cell chart approach is so simple and elegant. Thanks for sharing. I am yet to understand the purpose of ‘divide by 2’ in the formula. I will keep thinking.
Hey Indzara, It’s nice you found it useful.
Dividing by 2 is just a matter to decrease the width of the bar.
Got it. That’s what I thought. May be it could be a formula based on the range of data instead of ‘2’, Either way, very good tip.
Thanks Dinesh for your words.