Thursday, March 10, 2016

Funnel Charts for 2016

One of the latest additions to Excel 2016 is the ability to create Funnel Charts. This worthy new chart is excellent for illustrating processes that incrementally become narrowed or more focused as each stage is completed. In the illustration below, I am showing how business “Funnels” into an insurance company.

It should be noted, of course, that this feature is only available if you have an Office 365 subscription and you have updated it recently.
Here are the Simple Steps for Inserting a Funnel Chart:
1.   Set up your data similar to the above illustration, using one column for the process steps and the other for the amounts
2.   Select you data in the table you have created
3.   Click Insert > Recommended Charts > Funnel

That’s all there is to it!  I am confident that this new chart will be useful for a great many of us in the future.  Funnel Charts – Very Cool!

No comments: