How to create funnel-shaped charts in Excel, Outlook, PowerPoint and Word 2016

Funnel chart displays values ​​across multiple stages in a process. For example, you can use funnel charts to show the number of sales prospects at each stage in a sales plan. Usually, the values ​​decrease, creating the order of bars that look like a funnel.

Note: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you are using the latest version of Office.

How to create funnel-shaped charts in Excel, Outlook, PowerPoint and Word 2016 Picture 1

Create funnel charts in Excel 2016

1. Set your data as the example above. Use a column for process stages and another column for values.
2. Select data.
3. Click Insert> Insert Waterfall or Stock chart> Funnel .

How to create funnel-shaped charts in Excel, Outlook, PowerPoint and Word 2016 Picture 2

Tip: In Excel 2016, 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:

How to create funnel-shaped charts in Excel, Outlook, PowerPoint and Word 2016 Picture 3

Create funnel charts in Excel 2016 on Mac

1. Set your data as the example above. Use a column for process stages and a column for values.
2. Select data.
3. On the ribbon, click the Insert tab, then click the waterfall icon, then select Funnel .

Tip: In Excel 2016 for Mac, 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 the tabs will appear on the ribbon.

Create funnel charts in Excel 2016 on Android

1. Set your data as the example above. Use a column for process stages and a column for values.
2. Select data.
3. Click Insert> Chart> Funnel .

Create funnel charts in Outlook, PowerPoint and Word 2016

1. Click a space in the email, presentation, or document notification.

2. Click Insert> Chart> Funnel .

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

Tip: At the top of the data window is the Edit Data button in Microsoft Excel. Click this button if you want more space to work with 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. Enter the names of the stages in cells A2, A3, etc.

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

8. Click Select Data .

Note: In PowerPoint, you may have to let 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 data column.

9. In the data, click and drag to select both columns: stages and values. When you're done, the dashed lines will 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 open Excel to edit data, close the Excel window.

See more:

1. Some tools to help create online charts
2. How to create graphs, charts in Google Sheets
3. 8 types of Excel charts and when you should use them