How to make a funnel chart in an Excel tutorial

For example, the production of a product from the beginning to the end of the listing after the ring filter set down the number of listed, Next, we take a group of examples to explain it!

The funnel chart is made by the bar graph combined with the auxiliary column, the concrete operation steps can be divided into the following several steps:

1, create placeholder auxiliary columns;

2, insert stacked bar chart;

3. Fill the placeholder with no color.

Operation Steps

1, first start the Excel table, simple to make a 5 rows of 3 columns of the table, include the link, quantity and placeholder content, in the C3 cell input formula, because the funnel diagram appears to be centered, so here first the number of links (B2) minus the number of the next link, calculate the difference is how much, Then divide by 2 so that when the columns of the placeholder auxiliary column are set to no fill, the center distribution will appear.

2. Use cell Fill method to fill the remaining data in the table, select the table area, click Insert--Bar--two-D bar chart, select the second type.

3. After inserting the chart, right-click the axis and select format axis.

4, Pop-up Format Axis dialog box, in the Axis Options tab, check the reverse category, the label and axis distance set to 100, click OK.

5, then right-click the blank area of the chart, and click Select Data from the right-click menu.

6, select the data source interface, first click down the arrow, the chart data area to move the number below, OK.

7, at this time found that the chart changes, the mouse selected these red rectangular parts, right click, set data series format.

8, switch to fill the label, check no fill, so that the red part will become no fill color, close the interface.

9, right click on the upper axis, from the right button menu to set the axis format.

10, in the Axis option label, the maximum check fixed, enter 100.

11, finally, delete some of the legend does not need the part, the funnel map is made.