Funnel charts are a type of chart, often used to represent stages in a sales process and show the amount of potential revenue for each stage. This type of chart can also be useful in identifying potential problem areas in an organization’s sales processes. 

Create a table in MS Excel like this.

Select MS Excel Table -> Insert -> Funnel Chart.
Note -> This feature is only available in latest version of Excel