How to Create a Funnel or Pyramid Chart

Introduction

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.

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 - via the visualization menu

1. Go to Visualization > Bar > Funnel.

2. Under Inputs > DATA SOURCE > Output in 'Pages' 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, go to Inputs > OUTPUT > 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 Inputs > ROW MANIPULATIONS > Reverse rows.

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

See Also

How to Build a Brand Funnel

How to Combine Variable Sets as a Grid

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