Applies ToExcel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac Outlook for Microsoft 365 for Mac PowerPoint for Microsoft 365 for Mac Excel 2024 Word 2024 Outlook 2024 PowerPoint 2024 Excel 2024 for Mac Word 2024 for Mac Outlook 2024 for Mac PowerPoint 2024 for Mac Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Excel 2021 for Mac Word 2021 for Mac Outlook 2021 for Mac PowerPoint 2021 for Mac Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Word 2019 for Mac PowerPoint 2019 for Mac Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile

Funnel charts show values across multiple stages in a process. For example, you could use a funnel chart to show the number of sales prospects at each stage in a sales pipeline. Typically, the values decrease gradually, allowing the bars to resemble a funnel.

Funnel chart showing sales pipeline; stages listed in the first column, values in the second

Note: This feature is only available in Excel for Windows if you have Office 2019, Office 2021, or if you have a Microsoft 365 subscription. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office.

  1. Set up your data like the above example. Use one column for the stages in the process, and one for the values.

  2. Select the data.

  3. Click Insert > Insert Waterfall, Funnel, Stock, Surface or Radar chart > Funnel.

    Insert a funnel chart

    Tip: In Excel, use the 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 then the Chart Tools will appear at the top of the program:Design and Format tabs for the Chart Tools

Note: This feature is only available in Excel for Mac if you have Office 2019, or if you have a Microsoft 365 subscription. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office.

  1. Set up your data like the above example. Use one column for the stages in the process, and one for the values.

  2. Select the data.

  3. On the ribbon, click the Insert tab, then click Waterfall chart icon (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 will appear on the ribbon.

  1. Set up your data like the above example. Use one column for the stages in the process, and one for the values.

  2. Select the data.

  3. Click Insert > Chart > Funnel.

Note: This feature is only available in these applications if you have Office 2019, Office 2019, or if you have a Microsoft 365 subscription. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office.

  1. Click an empty space in an email message, presentation, or document.

  2. Click Insert > Chart > Funnel.

  3. The funnel chart will appear. And, a small window with example data will appear. Change the numbers to your own.

    Tip: At the top of the data window is the Edit Data in Microsoft Excel button Edit data in Microsoft Excel button. Click this button if you want more room to work with the data.

  4. To add the names of the stages, right-click anywhere in column A, and then click Insert.

  5. Click Entire column, and then click OK.

  6. Type the names of the stages in cells A2, A3, and so on.

  7. At the top of the program window, click the Design tab.

  8. Click Select Data.

    Note: In PowerPoint, you may have to move the small data window down to see the Select Data button.

    The Select Data Source window will appear. And, dashed lines will appear around the second column of data.

  9. In the data, click and drag to select both columns: the stages and the values. When you're done, the dashed lines should surround the two columns.

  10. In the Select Data Source window, click OK to close it.

  11. Now close the data window. Or, if you opened Excel to edit your data, close the Excel window.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.