Sales Funnel Spreadsheet Template
Funnel for Sales Spreadsheet TemplateHow to create a Sales Pipeline Funnel Excel chart template
You' ve probably seen this kind of funnel diagram in Business Intelligence (BI) softwares and asked yourself how to create this kind of diagram in Excel. This article will show you how to create a funnel diagram template in Excel to display a graphic representation of a sales pipeline for use in an Executive Dashboard.
Now, before I show you how to create a Sales Funnel in Excel, I have the feeling that we need to talk about problems with this kind of graph. A lot of the sector's visualisation specialists don't like it, sorry, I should have said HATE Funnel charts. Well, especially if you are a specialist in viewing your own information, you may not like a funnel diagram or a funnel diagram because the diagram may have the power to deceive the reader.
Each section's area must not display the information in relation to other section's areas. This chart can make you think that sales in the prospect stage are much bigger than sales in the negotiating stage, although in fact they are exactly the same. Use caution when using it as a means of displaying your information.
However, many, many organisations, businesses, departments as well as units use the graph as a default to provide a pipelined or funnel effect for the information. Although this may be a poor image from a visual appearance and graphics point of view, you may be asked to produce this kind of image for your Executive Dashboard.
You should first take the initiative to speak to the rulers who are talking about the problems with this kind of map. When your customers or leaders or manager still want this as part of the company dashboard, then give them what they want. That' why you will find these types of diagrams in many popular softwares like Salesforce.com.
Let's say you are the dashboard creator for your sales organisation and this is your Excel data: Suppose your example information has a category from your sales organisation about what the sales pipe looks like for the business. There are currently 652 sales prospects in the prospect phase valued at $33.6 million.
It is the beginning of the sales lifecycle for your business and each sales chance can be at a different tier in the sales lifecycle. It is typical that in each phase of the sales process there is less and less, as business is not always a completed business. A few folks in the prospection phase can get a different opinion and not buy anything.
A further prospective sales transaction that is in the presentation phase cannot be completed because the purchaser has selected another entity to conduct the transaction. But not all sales drop out of the pipelines and your organisation may be able to compute the likely percent that a given occasion can complete at any phase of the sales lifecycle.
For this reason, companies like to see this information in a pipelined or funnel form as each step completes the next step in the lifecycle. If you don't have enough revenue in every part of the pipe, your business will have unequal liquidity because every sales is likely to have an avarage close down period from beginning to end.
Okay, that's enough about why organisations and funnel loved charting folks and the perils about what they show you. Let's look at the key points of how to create a sales funnel diagram in Excel. With the above mentioned points for our pipelines we can create the diagram.
But I don't see Sales Funnel Charart or Pipeline Charart as an Excel export for that. That'?s the good and worst of Excel. Nothing is there and made for you, but with the help of our off-the-shelf equipment you can create your own funnel or piping diagram. So, looking at the default sets of graphs available in Excel, the nearest presentation of what we're looking for is a stacked pyramid graph.
Specifically, a 100% stacked graph, since our information is 100% of the sales pipelined information and we don't try to match the information from one graph to another. The diagram of the 100% stacked polyramid can be found under the Insert Column Diagram in Ribbon option. That is what we call Basis or Sales Funnel or Sales Pipeline and here is how.
1 ) Highlight the A2:B6 information (from "Prospecting" to the negotiation value of "45") and from the Insert Ribbon pick the column menu from the graph group, then pick 100% Stack Pyramid. This is the resulting diagram: 2 ) On the graph, click the pyramid to click the row of values for the first one.
Then, choose "Switch Row/Column" from the "Design Ribbon" in the data group. This is the resulting diagram: A funnel diagram is slowly taking form. 3 ) Right-click on the diagram and choose "3D Rotation..." from the drop-down list or you can also see this as a selection from the layout bar in the background group.
We are now very near the Final Sales Funnel Charts in Excel. 5 ) Right-click the vertical axis of the graph and click "Format Axis..." from the drop-down list or you can also see this as the primary vertical axis from the layout bar in the Axis Group. and click "Values in Reversed Order" from the Axis Options dialog box.
Looks like we wanted to, now we just need to clear the graphic and give it some data labels. d) Removing the category label - Click #1 at the top of the sales funnel and hit your clear button. e) Add data labels - Click anywhere in the graphic and modify the data labels to "Show" from the layout bar in the label group.
Now your Sales Funnel for Excel should be filled in and look like this: A FREE template pattern for the sales pipe can be downloaded with directions here: