How to make a funnel chart in an Excel tutorial

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.