A pyramid graph is a triangular chart divided horizontally into vertically stacked segments with widths representing values. It shows ordered data or hierarchies and displays conversion ratios as percentages to indicate progression between levels. You can customize it by reordering axes, ranking data, toggling conversion ratios, or reversing direction by switching to a funnel graph. The shape depends on data order in the project tree, not the icon.
In this article
The order of your data in the project tree or analysis table determines the graph’s shape, not the graph icon. The graph type controls the direction of the conversion ratio.
1. Pyramid Graph
A pyramid chart is a simple way to show ordered data or hierarchies. Like a stacked bar chart, each segment is stacked vertically. However, the height of each segment is the same, and the value of each segment, represented by its width, is usually (but not always) smaller than the segment below. The data ordered from largest to smallest gives the graph its pyramid shape.
In the example below, the axes are ordered in the project tree with the largest values at the bottom and smallest values at the top, and so the chart displays the progression upwards from awareness to trial to regular consumption.
- Select the axes - in this case a grid has been setup with the required axes that share the same element list
- Click Visualize and Harmoni defaults to a bar graph
- From the Visualize menu, select the pyramid graph icon
2. Conversion Ratio
In Harmoni, the conversion ratio displays as a percentage for each segment, showing the proportion of respondents who move from one level to the next, providing a clear visualization of each segment's performance and its influence on the overall result. The conversion ratio sits to the left of the pyramid.
Tooltip
When hovering over the conversion ratio, a tooltip displays the two elements used to calculate the ratio and the direction of flow. With the pyramid levels ordered from largest at the bottom to smallest at the top, the conversion ratios remain under 100% as each level is smaller than the level below.
In the example of Cool Nut below, 57% of respondents move from Total Brand Awareness through to Tried in the Past 3 Months, and 77% move from Tried in the Past 3 Months through to Drink Regularly. Hovering over 77% shows the tooltip with the two items used in calculating the conversion ratio.
Show/Hide
You have the option to display or hide the conversion ratio. From the drop-down menu below the pyramid graph, untick the Show Conversion Ratio option.
To reverse the conversion ratio direction shown next to the graph, click the Funnel Graph Learn more about Funnel Graphs button. The visualization will remain the same.
3. Customize Your Graph
Reordering Axes
Reorder allows you to manually change and control the order of the rows or columns. This can be necessary if you are pulling individual axes from the project tree, rather than items with a preset order.
Note: You cannot use reorder if ranking has been used.
- Drag the required axes to the analysis pane
- Use reorder to order the rows
- Click Visualize and select the pyramid graph
Learn more about Reorder.
Ranking 
You can change the order of the rows by using Rank. In the example below, the order of the axes is from smallest at the bottom to largest at the top. Use Rank to reverse the order of the axes to create the pyramid shape.
- Drag the required axes to the analysis pane
- Rank the table, in this example two clicks to rank from low to high are required
- Use the Visualize menu to select a pyramid graph
Learn more about Rank.