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
Use case example: Revenue by sales channel
This funnel chart in above example shows revenue generated by an organization through each of the 5 channels, with largest revenue generating channel placed at the top and smallest at the bottom.
In this example, e-mail channel generates highest revenue which is visually indicated by height of the segment.
Also see sales funnel chart.
Formula
% Revenue from channel = (Revenue from channel / Total revenue) x 100
How to use and edit this chart template
To edit this chart template, execute following steps.
- Right click on the chart to open chart menu. Click Edit Data. This will open the linked Excel sheet (see video below).
- Enter category names for each funnel segment in cells highlighted in blue color in column A.
- Enter corresponding numeric data values in cells highlighted in blue color in column B.
- Percentage values are derived from absolute numbers.
- Close the Excel sheet.
- Height of each segment is automatically determined by its data value in relation to other segments.
- Auto placed data labels show category names, absolute values and percentage values (derived from numeric input).
- File format: PPTX. Compatible with PowerPoint 2013 and above.
