Insert A Funnel Chart In Excel 365

Insert Funnel Chart

A new chart has arrived in Microsoft Excel 365 which is the Funnel Chart. What does the Funnel Chart represents? It shows values across multiple stages in a process. We use this Chart Type to show progressively smaller stages in a process. We can also use this Chart Type when Data Values show progressively decreasing proportions. We can use a Funnel Chart to show the number of sales at each stage in a sales pipeline. Usually the values decrease slowly, allowing the bars to look like a Funnel. In order to create a Funnel Chart in Microsoft Excel 365, all you have to do is to continue reading.

First, we must have all the necessary data inserted in our Worksheet as shown in the image below.

Table in Excel

Once the necessary data is in our Worksheet, we must select the data that we want to visualize with a Funnel Chart, as shown in the image below. We must use one Column for the Stages in Process, and another Column for the Values.

Selected Data

Once the data is selected, we must select the Insert tab and then we must locate the area of the ribbon named Charts as shown below. Once the Charts area is located we select the Funnel Chart.

Funnel Chart

Immediately a Funnel Chart has been inserted in our Worksheet as shown in the image below. Once the Funnel Chart is inserted and it remains selected, the Design and Format tab appear on our ribbon. The Design tab is activated, where with the use of the commands available we can Modify the Funnel Chart.

Funnel Chart

Below you can check out the video describing How to Create A Funnel Chart in Microsoft Excel 365.

Advertisements

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on January 17, 2017, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Insert A Funnel Chart In Excel 365.

Comments are closed.