How to Create a Funnel or Pyramid Chart

This article describes how to go from a table containing hierarchical data...

...to a chart that shows this data either as a single funnel or pyramid. This is sometimes called a brand funnel.

Requirements

You need a table that contains data in at least one column, where the data is arranged in hierarchical order with the largest number first and the smallest last (or vice versa).

Method 1 - Using the visualization menu

1. From the toolbar, click Visualization > Bar > Funnel.

2. Under Data > Data Source > Data select the table that contains the data.

3. OPTIONAL:  Go to Chart > Data Series > Color palette and select Blues, light to dark.

4. OPTIONAL:  Go to Chart > Data Labels and select Show data labels.

Method 2 - Using an existing table

1. Select the table.
2. From the object inspector, click Visualization > Bar > Funnel.
3. OPTIONAL:  Under Chart, you can make further adjustments to the appearance of the visualization.

If your data is sorted with the largest number in the first row, your output will be a funnel.  If it's sorted with the smallest number in the first row, it'll be a pyramid. This can be swapped around by selecting Data> Row Manipulations > Reverse rows.

If your table contains multiple columns and you want to make one chart for each column, then update to Data > Visualization > Bar > Small Multiples Funnel:

Note

Important information about editing captions: 

Visualization caption edits may not be retained when a visualization with a nested table is switched back to a table. Normally, this only occurs when you double-click the caption and edit the text directly. As a workaround, we recommend using Appearance > Caption > Edit caption to edit your captions.

Next

How to Build a Brand Funnel Using R

How to Combine Variable Sets as a Grid

How to Create Top Two Category Variable(s) (Top 2 Boxes)