Reading Time: minutes remaining

How to Create a Funnel Chart to Represent a Diminishing Flow of Data

Jason Morrell

by Jason Morrell 
January 24, 2022

Funnels are commonly used to represent a diminishing flow.

A classic example is filtering candidates for a vacant job position.

Consider the following data. There are 200 applicants, of which 50 get invited to interview, 20 receive a second interview & assessment and 2 get hired.

How to set up your data before you create your funnel chart

1. How to create a funnel chart in Excel

To create a funnel chart to represent this data

1.  Set up your data in two columns like the example shown above.

2.  Ensure that the numerical data is sorted in descending order (use the Data tab | Z-A icon).

3.  Select a single cell in your data to allow Excel to select the entire range or select the specific data range you wish to use.

4.  Click the Insert tab.

Click the Waterfall, Funnel, Stock, Surface, or Radar Chart icon in the Charts group, then choose Funnel.

Alternatively, click Recommended Charts | All Charts tab | Funnel Chart.

Where to find the Funnel chart amongst the Chart types

Your funnel chart will look similar to this:

A funnel chart showing stats at different stages of a job application process

2. How to change the text colour

To change the text colour:

1.  Click any data label, go to the Home tab and select a suitable font colour.

3. How to overlay the data labels on the bars

To put the data labels on the funnel bars instead of to one side (if there is sufficient room:

1.  Click on the top-right edge of the chart.

2.  Choose Data Labels | More Data Label Options, then tick Category Name.

3.  Click once on the existing axis labels and hit Delete.

I hope you found plenty of value in this post. I'd love to hear your biggest takeaway in the comments below together with any questions you may have.

Have a fantastic day.

Jason Morrell blog signature
About Jason Morrell

About the author

Jason Morrell

Jason Morrell is a professional trainer, consultant and course creator who lives on the glorious Gold Coast in Queensland, Australia.

He helps people of all levels unleash and leverage the power contained within Microsoft Office by delivering training, troubleshooting services and taking on client projects. He loves to simplify tricky concepts and provide helpful, proven, actionable advice that can be implemented for quick results.

Purely for amusement he sometimes talks about himself in the third person.


more from

Office Mastery logo
Read More
How to Consolidate Data in Excel: 2 Easy Ways to use Excel’s Consolidation Tool
Read More
Excel Screen: A Beginners Tour


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}