Funnel Chart: How to Create a funnel chart in excel to visualize your data flow

Funnel Chart

Funnel Chart is a special kindly of chart which is used to visualize the progressive reduction of data when it passed from one process to another. Data in each process is represented as a different portion of 100%. There is multiple kind of analysis where it is required like the admission process for a course, recruitment funnel, product sales, etc. The values in each process are gradually decreasing.

How to create Funnel Chart in excel

First and foremost we will arrange our data in descending order. Then we will go to Insert tab Insert Waterfall, Funnel, Stock, Surface, or Radar Chart Funnel.

What is a Funnel Chart
Funnel_ Chart

After clicking the Funnel option we will get it as below.

how to use Funnel_Chart in excel
Funnel_ Chart
Continue Reading