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.
Create funnel charts in Excel 2016
- Set your data as the example above. Use a column for process stages and another column for values.
- Select data.
- Click Insert> Insert Waterfall or Stock chart> Funnel .
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:
Create funnel charts in Excel 2016 on Mac
- Set your data as the example above. Use a column for process stages and a column for values.
- Select data.
- 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
- Set your data as the example above. Use a column for process stages and a column for values.
- Select data.
- 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:
- Some tools to help create online charts
- How to create graphs, charts in Google Sheets
- 8 types of Excel charts and when you should use them
You should read it
- Instructions for creating charts on PowerPoint
- How to create a chart in Word 2016
- How to draw a map chart on Excel
- Instructions for inserting, drawing and creating charts in Word 2007
- How to create 2 Excel charts on the same image
- How to draw a pie chart in Excel 2016
- How to create an effect for an Excel chart in PowerPoint
- Instructions on how to create charts in Excel professional
May be interested
- Instructions for creating interactive charts in Excel with INDEX functionexcel makes it easy to create clear, concise charts from your raw data. however, sometimes the graphs create static and not interesting. so the following article will introduce a simple method to help you turn static excel charts into dynamic charts.
- How to draw charts in Exceldrawing diagrams on excel are basic and often done, when displaying data based on tables or comparing figures together.
- How to create PDF files from Word, Excel, Powerpoint files simply and quicklyhow to create pdf files from word, excel, powerpoint files simply and quickly. due to the needs of the work sometimes you need to convert word, exel, powerpoint file formats to pdf format because of the advanced features of the pdf format. so how to create
- Tips on how to copy charts from Excel to Word while maintaining the formatexcel and word are two software in microsoft's microsoft office suite. most users regularly use these two software. do you know how to copy charts from excel to word with the format intact? read this article for instructions on how to do it!
- Instructions on how to draw diagrams in Wordthe use of drawing models in word content will help readers more generalize and better understand the content, as well as increase the content of the content.
- How to draw a Gantt chart in PowerPointa gantt chart is a bar chart that shows the schedule of a project, used for intelligent project management.
- Office 2016 Preview for Mac: supports OneDrive, Retina screenoffice 2016 for mac includes updating applications including word, excel, powerpoint, onenote and outlook. the modernized interface with riboon toolbar is redesigned more intuitive, easier to access, and helps users quickly find tools to manipulate as desired. refreshed task pane interface for locating, resizing or rotating graphics
- Create and insert Word 2016 chartscharts are tools you can use to convey information in graphical form. using the chart in the document will help you illustrate numerical data such as comparisons or trends for readers to understand better. let's learn how to create and edit charts in word 2016 below!
- The most detailed instructions on drawing, creating, and inserting charts in Word 2013charts in word 2013 help you present data in a visual, easy-to-understand way. if you don't know how to do it, this article, tipsmake will guide you in detail on how to draw, create and insert charts.
- How to circle answers in Word, Excel, PowerPointto circle the answer in word, excel, powerpoint is very simple, you can use the symbol tool or draw a circle in the content you are editing.