How to Create a Funnel Chart in Excel 2016

News
By published

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.

Microsoft Excel Tips

Melanie Pinola

Melanie was a writer at Laptop Mag. She wrote dozens of helpful how-to guides, covering both the software and the hardware side of things. Her work included topics like SSDs, RAM, Apple, Excel, OneDrive, and detailed guides for Windows users. Outside of all her useful advice, Melanie also penned a few reviews for Laptop Mag, including Android emulators that help you run apps on your PC.