Sales Funnel Chart with 7 Segments

Use this professional sales funnel chart PowerPoint template with 7 segments to show data in progressively decreasing proportion, with largest contributor at top and smallest at bottom.

Chart Template for PowerPoint

In this template;

  • Percentage values are derived from absolute numbers.
  • Height of each segment is automatically determined by its data value in relation to other segments.

Type

Funnel Chart

Function

Part to Whole Relationship, Trends​

How to use and edit this chart template

To edit this chart template, execute following steps.

  1. Right click on the chart to open chart menu. Click Edit Data. This will open the linked Excel sheet (see video below).
  2. Enter category names for each funnel segment in cells highlighted in blue color in column A. 
  3. Enter corresponding numeric data in cells highlighted in blue color in column B. 
  4. Percentage values are derived from absolute numbers.
  5. Close the Excel sheet.
  6. Height of each segment is automatically determined by its data value in relation to other segments.
  7. Auto placed data labels show category names, absolute values and percentage values (derived from numeric input).
  8. Restyle and customize to change text, fonts, colors etc. to match your brand guidelines, corporate identity / corporate design and preferences. 
  9. Modify the template for your own use case, industry or job function. Easily change, add or delete categories and corresponding data series, if you have more/less data than provided in this ready-to-use template.
  10. File format: PPTX. Compatible with PowerPoint 2013 and above.

Use case example: Sales funnel for lead - conversion ratio

The funnel chart in above example visualizes sales funnel of an organization in 7 stages, starting with (1) number of leads at the top, followed by (2) qualified leads (3) solution fit (4) presentations made to clients (5) client evaluations (6) negotiations and (7) number of conversions/closing at the bottom of the funnel. 

With a quick look at the chart, audience can see that of 8,357 leads received by an organization during a period, 20% (1,684 leads) resulted in conversions – an impressive lead – conversion ratio. 

The chart also shows progressive reduction of leads as the sales process progresses from one stage to next. In this example, you can see that there is a significant drop from qualified leads stage to solution fit stage, illustrating possible bottlenecks and an area of improvement.

See funnel chart template for analysis of average sales cycle length in days. 

Formula

% Lead Conversion Ratio = (Number of leads converted / Total number of leads) x 100

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest

Numbers have an important story to tell. They rely on you to give them a clear and convincing voice.

Stephen Few

Create Beautiful Custom Reports, Dashboards, Charts and Graphs in Minutes

115 Chart Templates . One time purchase . instant download