2 Different Methods to Create a Funnel Chart in Your Excel

When you need to show the information in a chart according to the values, you can create a funnel chart. Hence, you can use the two methods in this article to create such a chart.

The information in a funnel chart can show the original data in a more intuitive way than the ordinary chart. Funnel chart can also reflect data and information in a clearly way. Therefore, in such a chart, you can know the relationship of different data and information clearly. The image below shows a range of sales volume of our product in the first half year. And now we will use this example to create a funnel chart for this range.Example

In newer version of Excel, you can create a funnel chart directly. This feature is indeed very convenient. But if you use older version of Excel, you need to make additional settings. That’s because there is no direct options of funnel chart. And now you can follow the two different methods in this article below to create a funnel chart. Here we will create a funnel chart by using Excel 2010. And the steps are very easy to learn.

Method 1: Use a Stacked Pyramid Chart

In this method, you need to first insert a stacked pyramid chart and then modify it.

  1. Select the target range in the worksheet.
  2. And then click the tab “Insert” in the ribbon.
  3. Next click the button “Column” in the toolbar.
  4. In the drop-down menu, choose the “Stacked Pyramid”. Thus, the new chart will appear in the worksheet.Stacked Pyramid Chart
  5. When the chart appears, you will see the “Chart Tools” tab in the ribbon. And here click the button “Switch Row/Column” in the toolbar.Switch Row/Column
  6. Right click in the chart.
  7. In the new menu, choose the option “3-D Rotation”.3-D Rotation
  8. In the new window, change the rotation of the X and Y into “0”.Change Rotation
  9. Next close this window.
  10. And then right click the vertical axis.
  11. In the pop-up menu, choose “Format Axis”.Format Axis
  12. In the “Format Axis” window, check the “Values in reverse order”.Reverse Order
  13. Next close this window. Now come back to the worksheet, you will see the effect.
  14. After that, click “Layout” tab in the ribbon.
  15. And then click the button “Data Labels” in the toolbar.
  16. Next choose the option “Show” to add data labels for the chart.Data Label
  17. In this step, delete the gridline in this chart.
  18. And then click the tab “Layout”
  19. Here click the button “Chart Floor”.
  20. In the menu, choose the option “None” to delete the chart floor.Chart Floor
  21. And then delete the horizontal axis and vertical axis. Thus, your will get this funnel chart like the image below show.

Funnel Chart

Method 2: Insert Stacked Bar Chart

Except for the above method, you can also use the stacked bar chart in the worksheet. And here you need to filter the data and add another new column for the worksheet.

  1. Select a cell in the range.
  2. And then click the button “Sort & Filter” in the toolbar.
  3. Next click the “Filter” in the drop-down menu.Filter
  4. Now click the button in the cell B1.
  5. And then click the option “Sort Smallest to Largest” in the menu.Sort Data
  6. In C1, input the header of the new column. Here we input “Add the Additional Number” into it. You can add it according to your need.
  7. In cell C2, input the formula into it:

=($B$7-B2)/2

In this formula, we will get the additional number for each number. Thus, in the following steps, we can make sure that all the column of the sales volume series will have the same center line.

  1. And then press the button “Enter” on the keyboard.
  2. Next click the cell C2 again.
  3. In this step, double click the fill handle of this cell. Thus, you have filled this whole column.
  4. After that, select the whole range.
  5. Next click the tab “Insert” in the ribbon.
  6. Then click the button “Bar” in the ribbon.
  7. In the drop-down list, click the “Stacked Bar”.Stacked Bar
  8. And then click the button “Select Data” in the toolbar.
  9. In the “Select Data Source” window, change the order of the two legend entries.
  10. Next click “OK”.Change Order
  11. In the chart, right click the series of the column that you have added.
  12. And then in the pop-up menu, choose the “Format Data Series”.Format Data Series
  13. In the “Format Data Series” window, click the option “Fill” on the right.
  14. And then click the option “No fill” on the right.No Fill
  15. Next close this window.
  16. Now you will come back to the worksheet again. Right click another data series in the chart.
  17. And then also choose the “Format Data Series” in the menu.Another Series
  18. In the new window, change the gap width into “0”.
  19. Next close this window.Gap Width
  20. Now add the data label for this chart. Be careful that don’t add the data label for the other data series.
  21. And then delete the legend.
  22. After that, delete the horizontal axis and the gridline in this chart. Thus, you will get this new funnel chart in this worksheet.Funnel Chart

You can also make additional settings according to your need to modify this funnel chart. And both of the two methods are very easy to manipulate.

The Comparison between the Two Methods

From the above analysis, you have learned the two different methods to create an intuitive funnel chart. But there still exist differences between these two methods. When you don’t know which method you can use, you can refer to the table below.

Comparison

Use a Stacked Pyramid Chart

Insert Stacked Bar Chart

Advantages

1.      This method is easy to understand and manipulate.

2.      There are fewer steps in this method. When you are in a hurry to make a funnel chart, you can use this method.

1.      The length of each bar represents the actual values in the worksheet.

2.      The order in the funnel chart ranks according to the value. Thus, it will be much easier for you to analyze in such an intuitive chart.

Disadvantages

1.      The sizes of columns in this chart don’t represent the actual value in the worksheet.

2.      If you need to know the rank of those numbers, you will find it hard to see the data labels in the chart directly. Instead, you still need to refer to the original range.

1.      Compared with the first method, this method contains more steps. Thus, you are required to spend more time when using this method.

2.      If you find it difficult to understand and use this method, you can only use the first methods. Thus, you cannot know the rank of different values.

From this table, you must have a clear understanding about the two different methods. The next time when you need to create a funnel chart for your worksheet, you will know which methods you can use.

What’s the Importance of Backing up

Actually we all know the importance of backing up your essential files, especially the Excel files that contains data and information. However, the more important those files are, the greater chances there exist that they will be damaged by hackers or malicious malware. A mission of those accidents is that you need to repair your files. When you cannot get access to your files, you can consider a data disaster. In order to repair Excel xls data problem and get back all your data and information, you can use out powerful Excel recovery tool. This tool is equipped with the best technology in the world, and it can fix almost all the errors in Excel. Compared with other recovery tool, our software is indeed your first choice.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair Word docx corruption and outlook repair software products. For more information visit www.datanumen.com

2 responses to “2 Different Methods to Create a Funnel Chart in Your Excel”

  1. Now you can simply be part of any online dating site and start your seek for an ideal match. Earlier than assembly, you may even slip in the set up for an excuse to cut things quick if it is going nowhere quick. If your relation is going nicely along with your partner then there is no such thing as a harm in converting this relationship of relationship into the wedding. In the following few minutes I am going to reveal to you some frequent mistakes I see people making time and again which might be hurting their chances enormously in assembly quality people with online dating companies. Furthermore since the population of those sites is far greater than the other paid sites, your chances of meeting singles drastically enhance. There are a number of the explanation why now determined singles are transferring for the online dating arena to seek out their perfect match. Costs related to every program ought to also be clear and there should be no added prices. Married men mentioned that there is an enormous risk that the disaster will affect their family life, sixty three percents being harassed due to this.

    To meet new folks, discover dates, and probably the love of your life, move to online dating! Once you’ll join the courting site turning into a member to them, these websites will provide you more details about other singles using their online platform to discover a match like you. However with the online dating trend now you can know extra particulars about online dating. When they see you they are going to know how old you’re. The first thing it is advisable to do if you want to create that perfect account is Stop trying at all the other current profiles of members as a result of you are not them. First Date Online Dating And Enjoyable? Is it riskier than dating folks we meet “IRL” (in real life)? This will can help you make the proper assessment about your life associate! Nearly 57 [url=htttps://www.linkedin.com/in/charmingdate]charmdate.com[/url] percents of United States habitants say that they worry about results of the monetary disaster over their amorous and private life. The best online dating site critiques embody the location’s outstanding options, the customers’ private experiences, and the online dating corporations’ achievement charges.

    Anybody who knows how to meet ladies on-line will tell you that the most effective and possibly the only way to satisfy ladies are by social networking websites and online dating websites. A man who has self-worth and set expectations won’t ever struggle to attract a partner as he has a gorgeous attitude of self-assurance and confidence. At the same poll, 75 percents of those that answered, aged between 25 and 34 years are afraid that the monetary disaster will affect their feelings negatively. Their psychological situation improves when they are involved in an intimate relationship and this feeling can help too much to face the stress of the financial state of affairs. This will offer you an extra layer of safety and security when coming face-to-face with your date for the very first time. So, in case you are feeling a deep reference to somebody, you’ve got already built an impression of your companion in your mind – the reason why most actual first dates get ruined. Online dating will be laborious to learn, so be upfront about your wants, and if you like somebody, join with them as quickly as you are able to. Other WittyThumbs users can share their thoughts on what the messages you get actually imply, or how you possibly can change your individual messages to be more interesting to the recipient.

    At the tip of 2009, a really massive quantity of new users on online dating sites were registered. The pawnbrokers, the low cost retailers and online dating websites that present free relationship providers are a few of these. Apart from discovering the best singles match, many individuals produce other reasons for signing up on free online web dating websites. With electronic world we stay in it is any wonder that heaps of individuals have now turned to web for finding special somebody? This is because of the reason that lots of them are embarrassed of wanting for their particular someone by private means like assembly them in social locations like parties, occasions, and other social gatherings. Thus, what you are able to do for having success to search out special someone? A part of the attraction of apps is their simplicity: you possibly can create a profile and start matching with folks in a matter of minutes.

Leave a Reply

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