Funnel charts in many cases are used in sales, marketing, along with other departments to exhibit data through different stages in a process, for example prospects moving with the sales pipeline. A current update to Office 2016 makes it dead simple to produce a funnel chart in Excel.

This new feature is available for Office 365 subscribers.

1. Select your data in Excel. It ought to have a row for each stage of the process and a column for that values.

2. Click the Insert tab.

3. Click Insert Waterfall or Stock Chart > Funnel.

Excel will insert the funnel chart for you. Double-click within the chart to format the bars along with other elements of design from the funnel chart, or go to the Design and Format tabs to quickly customize the chart's appearance.