Sales Funnel Management ExcelFunnel Management Excel
This is how you generate a Sales Funnel Chart in Excel
In this article we explain how to generate a funnel diagram in Excel. It can be made in 5 easy increments with a batch ed graph. You can download the Excel spreadsheet that was used to generate this diagram free of charge below. A funnel diagram? The funnel diagram is similar to a beam diagram, but the beams are centred to produce a funnel form.
This example shows the funnel diagram showing how many clients are in each phase of our sales pipelines at a given point in tim. Use a funnel diagram to find out why? Ok, besides this good cause the funnel graphic can help to give the readers a visible image of the steps in the production line.
For the sales pipelines, we begin with many clients in level 1 (first contact), but only a small proportion of these clients make it to level 5 (close) where the sale takes place. The centring of the beams on the plotter surface gives the impression of a funnel form.
They may not always give an accurate hopper form like this, but the centring of the beams makes the hopper operation clearer and more explainable. Funnel diagram can be generated in 5 easy increments with a batched Gantt diagram. A " Distance piece " row that centres the beams is included in the stacking Gantt diagram.
Datas for this range of spacers are generated using a straightforward equation and then displayed as the first range on the stapled rod. In this case we modify the fill colour of the line so that it is translucent so that the observer only sees the funnel details. Or, simply copy the Funnel Chart Example leaf into your own files and modify the information to make it your own.
First, you need to insert a table with equations to the right of your table name. Using this equation, you build a distance piece that centers each beat according to the greatest number in your record. Distance piece formula: It finds the MAX number in the datarow, deducts the amount in the actual datarow, and divide it by 2. Once we have these two datarows, we choose the dates and build a stacked Gantt Chart.
The first time the graph is generated, the catagories are displayed in the reverse order as they appear on the page. Each category is now displayed in the same order as it appears on the page. The next step is to adjust the width of the beams so that the boundaries meet.
That gives the graphic a rather funnel-shaped appearance. Modify the gap width to 0% in the serial option. Ensure that the fill colour of the distance strip is translucent. As a result, it becomes hidden to the readers and only the funnel itself appears. Modify the fill colors in the Serial settings to No fill.
Now you can reformat the diagram and delete the additional garbage. The Excel spreadsheet will add many additional items (grid lines, legend, etc.) that are not needed for this type of display. These are the things I have done to reformat the diagram: Modify the fill colour and edge colour of the funnel strips. Modify the charts caption (including the date or date range of the data).
Attach the captions to the funnel strips and centre them. You can copy the Funnel Diagram Example worksheet directly into your Excel spreadsheet and modify the dates. In the above example, the sales counting information was used for different phases of a sales pipe.
You can also use the funnel diagram for this: The funnel diagram can also be used for display: Which further applications are there for the funnel diagram?