How to Create a Pyramid Diagram

Table of Contents

What is a Pyramid Diagram

When you have an ordered list of step names or descriptions, one convenient way to display it graphically is using a Pyramid Diagram. Some other way to do it is with a pie-based Target Diagram.

Each textual information is represented within a segment of the same approximate size. Remark that using a numeric column instead will cause each segment’s size to adjust accordingly. This is a less restrictive diagram, as most of the charts require numeric columns.

Steps to Create a Pyramid Diagram

Start Visual Xtractor or Data Xtractor. Connect to a database. Create or design a SQL query. Run the query and check the results.

  1. Display and enable the Chart query builder.
  2. Select a textual column as Funnel ChartsPyramid chart.

Pyramid Diagram Demo Queries

Look for the ready-to-use Pyramid Diagram generated query under the Queries > Demo Queries > Charts > Funnel Charts folder. Click on the “add demo queries” command link, if not there.

Pyramid Diagram
Generated demo queries must work for any database, with no restriction. They use constant values generated on-the-fly and your database SQL engine, but do not depend on data from your tables, and never alter your database in any way.

Customize your Pyramid Diagram

  1. Show data labels outside.
  2. Switch to 3D, to get a different view and drawing styles.
  3. Show the pyramid segments exploded or not.
  4. You may also click on legend items to hide or show back some segments.
  5. Collapse the legend, as long as all labels appear on the chart anyway.
  6. Or you can make it multi-color.

Custom Pyramid Diagram


  • Creating a Pyramid Diagram in Data Xtractor or Visual Xtractor is fast and trivial: set any data column with textual information as Pyramid, and that’s it!
  • All builtin powerful features of these chart type are common to most other charts: filtering series through the legend items, interactivity, monochrome or grayscale colors, rich axis and data label selections etc.
  • Switch to another builtin chart theme, or customize your own, for any possible color or other styles.