The Funnel chart (Funnel chart) lets you add a sequential chart showing the connected stages of a process. Each stage will decrease and should contain a subset of the previous stage. The decrease is gradual, giving the chart an ever narrower funnel.
Funnel charts show values across multiple stages in a process. They can represent anything that is decreasing in size. The funnel chart shows a process that starts at 100% and ends with a lower percentage. Each chart segment represents the value of a specific item and can influence the size of other segments. The Funnel chart is included in the Visualization bundle.
- The chart requires one dimension and one measure.
- Unlike bar charts, funnel chart segments are centered to create a funnel shape.
- A chart with increasing stages instead of decreasing is a pyramid graph.
When to use it
The funnel chart is useful to illustrate the stages of a process and the overall decrease of each step, for example:
- Represent a sales process showing the amount of potential revenue for each stage.
- Illustrate the number of sales prospects at each stage in a sales pipeline, i.e. the process from prospective customer to made purchase.
- Identify potential problem areas and bottlenecks of a sales process.
- Communicate a sales process to new team members and vendors.
- Illustrate website visitor trends – from visitor homepage hits to other areas, for example downloads, etc.
- Show order fulfillment with initiated orders at the top, followed by for example, orders in delivery, delivered, canceled and returned.
- Showing the flow of information from top secret to unclassified.
- Representing knowledge areas from general knowledge to expert knowledge.
Creating a funnel chart
You can create a funnel chart on the sheet you are editing.
- The dimension decides how it should be grouped in segments. By default, dimension values are displayed in descending order by measure value.
- The measure is the value that decides the size of each segment.
Do the following:
- In the advanced edit mode assets panel, open Custom objects > Visualization bundle and drag a Grid chart object to the sheet.
- Click the top Add dimension button and select the target dimension (usually target market) of the chart.
- Click the Add measure button to select the measure (what is to be measured) of the chart. Once dimensions (dimension label) and measure (value label) have been selected the funnel chart displays automatically (in color) in the chart field.
- Click Done to revert to the main display field.
- Click applicable region under Region. The chart field will update displaying chosen parameters and details.
Dimension, measure and region details will continue to display in the chart field even when reverting to Edit mode.
Changing the appearance of the chart
You can customize your chart with one or more features.
You can set the shape of the funnel with Appearance > Presentation > Funnel Mode.
The area of each item is proportionate to the measure. Only the height of the individual segment is affected - not the overall chart or contents.
The height of each item is proportionate to the measure. Only the height of the individual segment is affected - not the overall chart or contents.
The width of the upper edge is proportionate to the maximum value of the measure. The top segment is always 100% and the following segments are relative in size to the first. The lowest segment is rectangular. This affects the shape of the funnel and each segment has its individual slope.
The measure only orders the segments with largest value at the top. The ordering is fixed so the shape of the funnel is not affected.
You can choose how to color the funnel chart by changing the Appearance > Colors setting from Auto to Custom.
You can use a single color for the entire funnel chart by selecting Single color in Colors.
Color by dimension
You can also color your entire funnel chart by dimension by selecting By dimension in Colors. There are two gradient color schemes available:
- 12 colors
- 100 colors
You can also select to keep persistent colors with Persistent colors.
Color by measure
You can color your funnel chart by measure by selecting By measure in Colors. The measure of the chart is selected as default, but you can change it under Select measure. This measure must be unlinked before a new can be selected. You can also change the measure using an expression in the Expression editor ().
You can choose between four color schemes. It is also possible to reverse the colors.
- Sequential gradient
- Sequential classes
- Diverging gradient
- Diverging classes
You can also set a color range for your chart based on your measure by setting Range to Custom. Set the range in Range > Min and Range > Max. You can use a number or an expression that evaluates as a number.
Color by expression
You can color your funnel chart by measure by selecting By expression in Colors. You can color it in two ways.
- The expression evaluates as a valid CSS color to color the chart. The expression is a color code should be checked.
The chart is colored by the expression value according to a color scheme. The expression is a color code should be unchecked.
You can also set the range of the colors.
Funnel chart elements are automatically sorted from largest to smallest. You can change the sort order in the properties pane. Go to Sorting, and drag your dimensions and measurements into the desired order.
Styling and formatting
The position and order of labels for dimension and measure values can be displayed in different ways. You can for example hide the dimension value or display measures as values or as a percentage.
You can choose if you want to show the dimension label or not with Appearance > Presentation > Dimension label
You can choose how to show value labels for each segment by setting Appearance > Presentation > Value labels to Custom.
- None hides the value labels.
- Share displays the values as percentage.
- Values displays the actual measure values.
For information about general limitations, see Limitations.