Reader small image

You're reading from  Building Interactive Dashboards in Microsoft 365 Excel

Product typeBook
Published inFeb 2024
PublisherPackt
ISBN-139781803237299
Edition1st Edition
Tools
Right arrow
Author (1)
Michael Olafusi
Michael Olafusi
author image
Michael Olafusi

Michael Olafusi is a 9x Microsoft Most Valuable Professional (MVP) and a business intelligence consultant. He is the lead consultant and founder of MHS Analytics Inc. in Canada and UrBizEdge Limited. He has been consulting for clients across North America, Europe, and Africa on data analysis, business intelligence, and financial modeling for the past 10 years. Outside of his consulting business, he is a member of Rotary and the Southern Cruisers Riding Club (SCRC) Chapter 373. He is a proud member of the Canadian Red Cross friendly calls volunteer team. He is also a faculty member at WorldQuant University, USA.
Read more about Michael Olafusi

Right arrow

Funnel chart

A funnel chart is a niche chart showing the linearly linked stage performance for a metric. A classic example is the use of a funnel chart by marketing teams to show sales funnel conversion performance.

Figure 8.42 is an example of a funnel chart showing the sales conversion for a multi-stage marketing campaign:

Figure 8.42 – Funnel chart showing the performance of an email marketing campaign

Figure 8.42 – Funnel chart showing the performance of an email marketing campaign

Funnel charts are easy to create and easy to understand even for non-sophisticated users. The trick is to ensure that you are using it to show insights about linked processes where each process will always have a value that is not greater than its preceding process.

That brings us to the end of funnel charts. We will move on to another chart.

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Building Interactive Dashboards in Microsoft 365 Excel
Published in: Feb 2024Publisher: PacktISBN-13: 9781803237299

Author (1)

author image
Michael Olafusi

Michael Olafusi is a 9x Microsoft Most Valuable Professional (MVP) and a business intelligence consultant. He is the lead consultant and founder of MHS Analytics Inc. in Canada and UrBizEdge Limited. He has been consulting for clients across North America, Europe, and Africa on data analysis, business intelligence, and financial modeling for the past 10 years. Outside of his consulting business, he is a member of Rotary and the Southern Cruisers Riding Club (SCRC) Chapter 373. He is a proud member of the Canadian Red Cross friendly calls volunteer team. He is also a faculty member at WorldQuant University, USA.
Read more about Michael Olafusi