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

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.


Choose a Seminar and Save $10:

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small> Basics

Microsoft® Excel® Basics

Mar. 22

Central Time Zone

Mar. 23

Eastern Time Zone

Mar. 27

Central Time Zone

Mar. 28

Eastern Time Zone

Mar. 30

Pacific Time Zone

Apr. 3

Eastern Time Zone

Apr. 4

Pacific Time Zone

Apr. 5

Central Time Zone

Apr. 11

Eastern Time Zone

Apr. 12

Pacific Time Zone

Apr. 13

Central Time Zone

Apr. 17

Central Time Zone

Apr. 19

Eastern Time Zone

Apr. 20

Pacific Time Zone

Apr. 24

Pacific Time Zone

Apr. 25

Central Time Zone

Apr. 27

Eastern Time Zone

May. 1

Eastern Time Zone

May. 2

Pacific Time Zone

May. 4

Central Time Zone

May. 8

Central Time Zone

May. 10

Pacific Time Zone

May. 11

Eastern Time Zone

May. 15

Pacific Time Zone

May. 16

Eastern Time Zone

May. 18

Central Time Zone

May. 22

Central Time Zone

May. 24

Pacific Time Zone

May. 31

Eastern Time Zone

Jun. 1

Central Time Zone

Jun. 5

Eastern Time Zone

Jun. 7

Pacific Time Zone

Jun. 8

Central Time Zone

Jun. 12

Central Time Zone

Jun. 13

Pacific Time Zone

Jun. 15

Eastern Time Zone

Jun. 20

Eastern Time Zone

Jun. 21

Central Time Zone

Jun. 22

Pacific Time Zone

Jun. 26

Pacific Time Zone

Jun. 27

Central Time Zone

Jun. 28

Eastern Time Zone

Jul. 5

Eastern Time Zone

Jul. 10

Eastern Time Zone

Jul. 11

Pacific Time Zone

Jul. 13

Central Time Zone

Jul. 17

Central Time Zone

Jul. 18

Eastern Time Zone

Jul. 19

Central Time Zone

Jul. 20

Pacific Time Zone

Jul. 24

Central Time Zone

Jul. 26

Pacific Time Zone

Jul. 27

Eastern Time Zone

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>: Beyond the Basics

Microsoft® Excel®: Beyond the Basics

Mar. 23

Central Time Zone

Mar. 24

Eastern Time Zone

Mar. 28

Central Time Zone

Mar. 29

Eastern Time Zone

Mar. 31

Pacific Time Zone

Apr. 4

Eastern Time Zone

Apr. 5

Pacific Time Zone

Apr. 6

Central Time Zone

Apr. 12

Eastern Time Zone

Apr. 13

Pacific Time Zone

Apr. 14

Central Time Zone

Apr. 18

Central Time Zone

Apr. 20

Eastern Time Zone

Apr. 21

Pacific Time Zone

Apr. 25

Pacific Time Zone

Apr. 26

Central Time Zone

Apr. 28

Eastern Time Zone

May. 2

Eastern Time Zone

May. 3

Pacific Time Zone

May. 5

Central Time Zone

May. 9

Central Time Zone

May. 11

Pacific Time Zone

May. 12

Eastern Time Zone

May. 16

Pacific Time Zone

May. 17

Eastern Time Zone

May. 19

Central Time Zone

May. 23

Central Time Zone

May. 25

Pacific Time Zone

Jun. 1

Eastern Time Zone

Jun. 2

Central Time Zone

Jun. 6

Eastern Time Zone

Jun. 8

Pacific Time Zone

Jun. 9

Central Time Zone

Jun. 13

Central Time Zone

Jun. 14

Pacific Time Zone

Jun. 16

Eastern Time Zone

Jun. 21

Eastern Time Zone

Jun. 22

Central Time Zone

Jun. 23

Pacific Time Zone

Jun. 27

Pacific Time Zone

Jun. 28

Central Time Zone

Jun. 29

Eastern Time Zone

Jul. 6

Eastern Time Zone

Jul. 11

Eastern Time Zone

Jul. 12

Pacific Time Zone

Jul. 14

Central Time Zone

Jul. 18

Central Time Zone

Jul. 19

Eastern Time Zone

Jul. 20

Central Time Zone

Jul. 21

Pacific Time Zone

Jul. 25

Central Time Zone

Jul. 27

Pacific Time Zone

Jul. 28

Eastern Time Zone

Advanced Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>-Macros, PivotTables, Charts and More

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

Mar. 22

Pacific Time Zone

Mar. 30

Central Time Zone

Mar. 31

Eastern Time Zone

Apr. 4

Central Time Zone

Apr. 13

Eastern Time Zone

Apr. 17

Pacific Time Zone

Apr. 21

Central Time Zone

Apr. 26

Eastern Time Zone

Apr. 27

Pacific Time Zone

May. 1

Central Time Zone

May. 2

Pacific Time Zone

May. 10

Eastern Time Zone

May. 11

Central Time Zone

May. 17

Central Time Zone

May. 18

Eastern Time Zone

May. 23

Pacific Time Zone

Jun. 2

Eastern Time Zone

Jun. 7

Eastern Time Zone

Jun. 9

Central Time Zone

Jun. 13

Pacific Time Zone

Jun. 19

Central Time Zone

Jun. 20

Eastern Time Zone

Jun. 29

Pacific Time Zone

Jul. 5

Pacific Time Zone

Jul. 10

Central Time Zone

Jul. 14

Eastern Time Zone

Jul. 20

Eastern Time Zone

Jul. 25

Central Time Zone

Related Charts Articles

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Categories

2 Comments