One of Excel’s best features is the ability to illustrate your data with charts. Sometimes, this data will include processes and values relating to those processes. A funnel graph is a great way to visualize these. Let’s learn how to make a funnel graph in Microsoft Excel.
How to Make a Funnel Graph in Excel
Funnel graphs get their name from how they draw data. Steps and values are stacked in a descending shape, just like the shape of a real funnel. To make a funnel graph in Excel, you’ll need to format your data in a hierarchy fashion.
Let’s consider a simple process designed to track how many people finish a certain project. Predictably, as the process progresses, some people will exit before completing the tasks. This is a classic descending hierarchy, and it’s perfect for a funnel graph.
Begin by typing data onto an Excel worksheet as shown in the example below. As you can see, the values in each row are decreasing.
Once you’ve finished inputting the data, it’s time to add the funnel graph. Begin by clicking and dragging to select the range of data, which is A1:B5 here. Then, find the Insert tab on Excel’s ribbon and click on it.
In the Charts group in the center, find the Waterfall dropdown button. Clicking to open it, you’ll see a variety of options available to you. The one you want is listed second: Funnel.
Click Funnel, and Excel will add the funnel graph to your spreadsheet. From here, you can click and drag to move it around your sheet. Plus, you can add customized features like chart titles and more.
As you can see, funnel graphs are a great way to illustrate processes with multiple steps. They’re easy to add in Excel, and bring visual clarity to your work.