Advanced Excel Funnel Chart - Advanced Excel Charts

What is Advanced Excel Funnel Chart?

Funnel chart is used to visualize the progressive reduction of data as it passes from one phase to another. Data in each of these phases is represented as different portions of 100% (the whole). Like the Pie chart, the Funnel chart does not use any axes either.

For example, in a sales pipeline, there will be stages as shown below.

Prospects → qualified prospects → Proposals → Negotiations → final sales.

Typically, the values decrease gradually. Many prospects are identified, but a part of them are proven and even lesser qualify for Proposals. A still lesser number come for negotiations and in the end, there is only a handful of deals which are won. this will make the bars resemble a funnel.

What is a Funnel Chart?

The Funnel chart indicates a method that starts on the initial state and ends with a final state, where it is noticeable in what stages the fall out happens and through what importance. If the chart is also combined with research information, meaning quantified measurements of just how many items are lost at each step of the sales or order fulfillment process, then the Funnel chart illustrates where the biggest bottlenecks are in the process.

Unlike a real funnel, not everything that is poured in at the top flows through to the bottom. The name only refers to the shape of the chart, the purpose of which is illustrative.
Advanced Excel - Funnel Chart


Another variant of Funnel chart is where the data in each of those phases is represented as different portions of 100% (the whole), to show at what rate the changes occur along the Funnel.

Like the Pie chart, the Funnel chart does not use any axes either.

Advantages of Funnel Charts

Funnel chart can be used in various scenarios, including the following −

  • To allow executives to see how effective the sales crew is in turning a sales lead into a closed deal.
  • A Funnel chart can be used to display web site visitor trends. it can display visitor page hits to the home page on the top, and the other areas, for e.g. the web site downloads or the people interested in buying the product will be proportionally smaller.
  • Order fulfillment funnel chart with the initiated orders on top and down to the bottom the orders introduced to satisfied customers. It shows how many there are still within the process and the percentage cancelled and returned.
  • Another use of Funnel chart is to display sales by each salesperson.
  • Funnel chart can also be used to evaluate Recruitment process.
  • Funnel chart can also be used to analyze the order fulfillment process.

Preparation of Data

Place the data values in a table.

Advanced Excel - Funnel Chart

Step 1 − Insert a column in the table as shown below.


Advanced Excel - Funnel Chart


You will get the following data. You will use this table to create the Funnel chart.

Advanced Excel - Funnel Chart

Creating a Funnel Chart

Following are the steps to create the Funnel chart −

Step 1 − Select the data and insert a Stacked Bar chart.


Advanced Excel - Funnel Chart


Step 2 − Right click on the Shift Bars (blue color in the above chart) and change Fill color to No Fill.

Advanced Excel - Funnel Chart

The chart looks as shown below.

Advanced Excel - Funnel Chart

Step 3 − Design the chart as follows.

  • Right click on the Vertical Axis.
  • Select Format Axis from the dropdown list.
  • Click AXIS OPTIONS in the Format Axis pane.
  • Check the box – Categories in reverse order.

Advanced Excel - Funnel Chart

Step 4 − fine tune the chart as follows.

  • Deselect Legend in Chart elements.
  • Change the Chart title.
  • Right click on the orange Bars.
  • Select format data series.
  • Change the gap Width to 0% in the series options.

Advanced Excel - Funnel Chart

Step 5 − Select Data Labels in Chart Elements.

Advanced Excel - Funnel Chart


Your Sales Pipeline Funnel chart is ready.

Formatting a Funnel Chart

Step 6 − Make the chart more appealing as follows

  • Click on the Chart Elements.
  • Deselect Horizontal Axis.
  • Deselect Gridlines.
  • Right click on the Bars.
  • Select Format Data Series from the dropdown list.
  • Click on Fill & Line under SERIES OPTIONS in the Format Data Series pane.
  • Click on Gradient fill under the Fill option.
  • Set Gradient stops.

Advanced Excel - Funnel Chart


Step 7 − Click on Solid line under BORDER. Select Color as black.

Advanced Excel - Funnel Chart

Your formatted Funnel chart is ready.

Advanced Excel - Funnel Chart

Aesthetic Funnel Chart

Now that you understood the fundamentals of Funnel chart, you can proceed to create an aesthetic Funnel chart that actually looks like a Funnel as follows −

Step 1 − Start with the original table of data.

Advanced Excel - Funnel Chart

Step 2 − Select the data and insert a 3-D Stacked Column chart.

Advanced Excel - Funnel Chart

Step 3 − Design the chart as follows.

  • Right click on the Columns.
  • Select Format Data Series.
  • Click on SERIES OPTIONS in the Format Data Series pane.
  • Select Full Cone under Column shape.

Advanced Excel - Funnel Chart

Step 4 − Fine tune the chart as follows.

  • Click the Design tab on the Ribbon.
  • Click Switch Row / Column.
  • Right click on the Vertical Axis and select Format Axis from the dropdown list.
  • Click AXIS OPTIONS in the Format Axis pane.
  • Check the box – Values in reverse order.

Advanced Excel - Funnel Chart

Step 5 − Deselect all the Chart Elements

Advanced Excel - Funnel Chart


Step 6 − Right click on the Bars and select Format Data Series from the dropdown list.

Step 7 − Click on SERIES OPTIONS in the Format Data Series pane and type 50% for Gap Depth under SERIES OPTIONS.

Advanced Excel - Funnel Chart

Step 8 − Format your chart with details as follows.

  • Select Data Labels in Chart Elements.
  • Place them and format them.
  • You can choose Call Out option for the Data Label of the bottom part.
  • Give a Chart Title.

Advanced Excel - Funnel Chart
Your Funnel chart is ready.


All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Advanced Excel Charts Topics