How to Create an Excel Funnel Chart

If you work in sales, marketing or any department that uses/receives reports from Business Intelligence software, you’re probably familiar with the Sales Funnel Chart. If you are looking to create a funnel chart of your own, you might find that it’s a bit of a trick. Excel gives you the tools to create the iconic upside-down pyramid, but not without some effort.

In addition, Microsoft changed the way you set the shape of a column chart in Excel 2013.

The following will show you how to create a funnel chart in both Excel 2007-2010 and 2013. To follow using our example, download Excel funnel chart.xlsx

Create a Funnel Chart in Excel 2007-2010
Images in this section were taken using Excel 2010 on Windows 7

  • Highlight the data that you want to incorporate into your chart. This example uses # of accounts in the pipeline.
  • On the Insert tab, select a basic 100% stacked pyramid from the Column dropdown button.

How to Create an Excel Funnel Chart - Image 1

  • Select the data series by clicking on any datapoint.
  • On the Design tab, click the Switch Row/Column button in the Data group.

How to Create an Excel Funnel Chart - Design Tab

  • Right-click on the pyramid and select 3-D Rotation from the fly-out menu.
  • Change the X and Y Rotation to 0o.

How to Create an Excel Funnel Chart - Rotation 0

  • Right-click on the Vertical Axis and select Format Axis from the fly-out menu.
  • Check the Values in reverse order checkbox and you have your funnel chart.

How to Create an Excel Funnel Chart - Values in Reverse

Create a Funnel Chart in Excel 2013
Images in this section were taken using Excel 2013 on Windows 7

  • Highlight the data that you want to incorporate into your chart.
  • On the Insert tab, select a basic 3-D Stacked Column chart.

How to Create an Excel Funnel Chart - Image 1 2013

  • Right-click on any series columns and select Format Data Series from the fly-out menu. This will open the Format Data Series pane.
  • Select Full Pyramid from the Column shape options.

How to Create an Excel Funnel Chart - Column Shape 2013

  • Select the data series by clicking on any datapoint.
  • On the Design tab, click the Switch Row/Column button in the Data group.

How to Create an Excel Funnel Chart - Design Tab 2013

  • Right-click on the pyramid and select 3-D Rotation from the fly-out menu.
  • Change the X and Y Rotation to 0o in the 3-D Rotation section of the Format Chart Area pane.

How to Create an Excel Funnel Chart - 3D Rotation 2013

  • Right-click on the Vertical Axis and select Format Axis from the fly-out menu.
  • Check the Values in reverse order checkbox on the Format Axis pane and you have your funnel chart.

How to Create an Excel Funnel Chart - Values in Reverse Order 2013

Once you have your excel funnel chart funneling your data in the right direction, you can clean up the chart labels and titles and adjust the design as needed.

Hint! If your chart is not based on a specific set of data or is only needed to convey an idea instead of numbers, it might be simpler to use a Pyramid SmartArt graphic.

How to Create an Excel Funnel Chart - SmartArt Graphic

Local Seminars Related to this Topic:

Related Charts Articles

Categories

Monthly Archives

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *