One of the recent features of Excel 2016 is the ability to create Funnel Charts, which allow you to display values across multiple stages of a process. You’ll often see Funnel Charts used to represent the stages of a sales process, displaying the amount of potential revenue for each stage. It also works well to simply present sales data, which can sometimes help to pinpoint problem areas or underperforming areas.
Typically, data is presented in descending order so that the chart represents a “funnel”.
To Create a Funnel Chart
- Select that data for which you want to create a chart.
- Sort the data in descending order.
- With the data still selected, click the Insert tab on the Ribbon.
- Click the Waterfall or Stock chart icon on the Charts group of the Ribbon.
- Click the thumbnail under the Funnel section.
- To change the style of the Funnel chart, click the contextual Design tab (under Chart Tools) on the Ribbon and choose the style you want from the Chart Styles gallery.