What are Funnel Charts in Excel?

A funnel chart is a specialized chart type that demonstrates the flow of users through a business or sales process. The chart takes its name from its shape, which starts from a broad head and ends in a narrow neck. The number of users at each stage of the process are indicated from the funnel’s width as it narrows. A funnel chart helps you visualize a linear process that has sequential connected stages.

  1. Set up your data like the above example. Use one column for the stages in the process, and one for the values.
  2. Select the data.
  3. Click Insert > Insert Waterfall, Funnel, Stock, Surface or Radar chart > Funnel.