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.

Check the Values in reverse order checkbox on the Format Axis pane and you have your funnel chart.

Change the X and Y Rotation to 0 o in the 3-D Rotation section of the Format Chart Area pane.

Select Full Pyramid from the Column shape options.

This will open the Format Data Series pane.

Right-click on any series columns and select Format Data Series from the fly-out menu.

On the Insert tab, select a basic 3-D Stacked Column chart.

Highlight the data that you want to incorporate into your chart.

Images in this section were taken using Excel 2013 on Windows 7

Check the Values in reverse order checkbox and you have your funnel chart.

Right-click on the Vertical Axis and select Format Axis from the fly-out menu.

Right-click on the pyramid and select 3-D Rotation from the fly-out menu.

On the Design tab, click the Switch Row/Column button in the Data group.

Select the data series by clicking on any datapoint.On the Insert tab, select a basic 100% stacked pyramid from the Column dropdown button.This example uses # of accounts in the pipeline. Images in this section were taken using Excel 2010 on Windows 7

To follow using our example, download Excel funnel chart.xlsx The following will show you how to create a funnel chart in both Excel 2007-20. In addition, Microsoft changed the way you set the shape of a column chart in Excel 2013. Excel gives you the tools to create the iconic upside-down pyramid, but not without some effort. If you are looking to create a funnel chart of your own, you might find that it’s a bit of a trick. 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. By Tepring Crocker Categories: Charts, Excel® Tags: excel funnel chart

Create pie chart in excel 2007