How to Create a Funnel Chart in Excel 2016
Funnel charts are often used in sales, marketing, and other departments to show data through different stages in a process, such as prospective clients moving through the sales pipeline. A recent update to Office 2016 makes it dead simple to create a funnel chart in Excel.
This new feature is available for Office 365 subscribers.
1. Select your data in Excel. It should have a row for each stage of the process and a column for the values.
2. Click the Insert tab.
3. Click Insert Waterfall or Stock Chart > Funnel.
Excel will insert the funnel chart for you. Double-click in the chart to format the bars and other design elements of the funnel chart, or go to the Design and Format tabs to quickly customize the chart's appearance.