PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

CREATE FUNNEL CHART IN EXCEL

INTRODUCTION

CHARTS are the graphic representation of any data . As we know that EXCEL is a super analytical tool.

Analysis of data is the process of deriving the inferences by finding out the trends, averages etc. about different parameters.

Although the data can be presented by any type of chart but even then there are certain charts which are very suitable for a particular type of situation which makes it very easy to understand.
One such chart type is FUNNEL CHART which we will discuss in this article.
The funnel chart is a chart which looks like a funnel made up of the horizontal bars which keep on decreasing.
This chart is suitable to show any process which have a filtering process. A process in which we start with a high number and it get filtered with every next stage and we are left with the final outcome.
 
This chart is available for the Excel 2019 and higher versions only.

WHEN TO USE FUNNEL CHARTS

FUNNEL CHARTS are specially meant for presenting the processes in which the number decreases with the stages.
It can be a statement of SALES ORDERS FINALIZED which starts with the Queries, or any process which is like filtering.
The first stage is having the highest number and last or final stage is having the least.
 

BUTTON LOCATION FOR FUNNEL CHARTS

The button for funnel chart is found under the INSERT TAB under the CHARTS SECTION. The button is Insert Waterfall, Funnel, Stock, Surface or Radar chart. The location is shown in the picture below.

FUNNEL CHART IN EXCEL
EXCEL:BUTTON LOCATION FOR INSERTING FUNNEL CHARTS

STEPS TO INSERT A FUNNEL CHART IN EXCEL

EXAMPLE DETAILS

We can demonstrate the chart using an example.
We are taking the  generalized example this time. We have the data of a fictitious process in which the value decreases with every increasing stage.
STAGEVALUE
STAGE 11000
STAGE 2845
STAGE 3700
STAGE 4550
STAGE 5220
The data shows a process in which the next stage has the decreased value in comparison with the first stage.

The procedure to insert a FUNNEL chart are as follows:

STEPS TO INSERT A PIE CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.[We have already created in the form of table above]
  • Refer to our data above, we have a process having the five stages.
  • Select the complete table including the HEADER NAMES.
  • Go to INSERT TAB> CHARTS> and click the FUNNEL button under Insert Waterfall, Funnel, Stock, Surface or Radar chart  as shown in the BUTTON LOCATION above and in the following picture for reference.
  • The chart will be created and shown to you as the following figure.
 
 The complete process is shown in the animated picture below.
CREATE FUNNEL CHART EASILY
EXCEL:STEPS TO CREATE FUNNEL CHART IN EXCEL

So , we have successfully created a FUNNEL CHART in Excel.

The chart can be easily made and modified as per requirement.

We should use the chart only when a certain process fulfills our requirements as discussed in the section above.

The process should have the values decreasing otherwise the relevance of the chart will be no more.

After applying the styles  , the final chart is shown below.

EXCEL:FUNNEL CHART IN EXCEL

NOTE:CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC.

FOR ALL OTHER TASKS LIKE CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC. VISIT HERE [HOW TO CREATE A CHART IN EXCEL].

 

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: