How to Create a Funnel Chart in Excel 2016

  • MORE

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.

excel funnel chart

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.

excel funnel chart data2. Click the Insert tab.

excel funnel insert

3. Click Insert Waterfall or Stock Chart > Funnel.

excel funnel insert2

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.

Add a comment