Funnel charts show values across multiple stages in a process. For example, you can use a funnel chart to show the number of sales prospects at each stage in a sales pipeline. Typically, the values decrease gradually, so the bars resemble a funnel.
Insert a funnel chart in Excel for Windows
Note
This feature is only available in Excel for Windows if you have Office 2021, or if you have a Microsoft 365 subscription. If you're a Microsoft 365 subscriber, make sure you have the latest version of Office.
Set up your data like the preceding example. Use one column for the stages in the process, and one for the values.
Select the data.
Select Insert > Insert Waterfall, Funnel, Stock, Surface or Radar chart > Funnel.
Tip
In Excel, use the Chart Design and Format tabs to customize the look of your chart. If you don't see these tabs, select anywhere in the funnel chart, and then the Chart Tools appears at the top of the program:
Insert a funnel chart in Excel for Mac
Note
This feature is only available in Excel for Mac if you have Office 2021 for Mac, Office 2024 for Mac, or if you have a Microsoft 365 subscription. If you're a Microsoft 365 subscriber, make sure you have the latest version of Office.
Set up your data like the preceding example. Use one column for the stages in the process, and one for the values.
Select the data.
On the ribbon, select the Insert tab, and then select
(the Waterfall icon) and select Funnel.Tip
In Excel for Mac, use the Chart Design and Format tabs to customize the look of your chart. If you don't see these tabs, click anywhere in the funnel chart and the tabs appear on the ribbon.
Insert a funnel chart in Excel Mobile and Excel for Android
- Set up your data like the preceding example. Use one column for the stages in the process, and one for the values.
- Select the data.
- Select Insert > Chart > Funnel.
Insert a funnel chart in Outlook, PowerPoint, or Word
Note
You can use this feature in these applications if you have Office 2021, Office 2024, or a Microsoft 365 subscription. If you're a Microsoft 365 subscriber, make sure you have the latest version of Office.
Select an empty space in an email message, presentation, or document.
Select Insert > Chart > Funnel.
The funnel chart appears. A small window with example data also appears. Change the numbers to your own.
Tip
At the top of the data window, select the Edit Data in Microsoft Excel button
. Select this button if you want more room to work with the data.To add the names of the stages, right-click anywhere in column A, and then select Insert.
Select Entire column, and then select OK.
Type the names of the stages in cells A2, A3, and so on.
At the top of the program window, select the Design tab.
Select Select Data.
Note
In PowerPoint, you might need to move the small data window down to see the Select Data button.
The Select Data Source window appears. Dashed lines appear around the second column of data.
In the data, select and drag to select both columns: the stages and the values. When you finish, the dashed lines surround the two columns.
In the Select Data Source window, select OK to close it.
Now close the data window. Or, if you opened Excel to edit your data, close the Excel window.