• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Funnel Graph in Excel

August 4, 2021 by Andrew Childress
Funnel chart in Excel

One of Excel’s best features is the ability to illustrate your data with charts. Let’s learn how to make a funnel graph in Microsoft Excel.

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.

Funnel graph in Excel

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.

Funnel chart in Excel

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.

Draw a funnel in Excel

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.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:use themes in ExcelUse Themes in Excel
Next Post:Hyperlinks in Excelhyperlinks in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top