How to Make a Pyramid Chart in Google Sheets

Ever tried to create a pyramid chart in Google Sheets only to find the option isn't there? You're not alone. While Sheets is packed with features, a dedicated, one-click pyramid chart isn't one of them. But don't worry, you can still build a powerful pyramid chart with a bit of clever structuring and a standard stacked bar chart. This article will walk you through the entire process, step-by-step, transforming a basic bar chart into a clean, professional-looking pyramid.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Use a Pyramid Chart Anyway?

Before we get into the "how," let's quickly touch on the "why." Pyramid charts are fantastic tools for visualizing data that has a clear hierarchy or a sequential, proportional structure. They show how a whole is divided into progressive stages or levels.

You’ll often see them used for:

• Sales and Marketing Funnels: Showing the journey from initial leads down to paying customers, illustrating conversion rates at each stage.
• Market Segmentation: Breaking down a customer base from a broad market to a specific niche.
• Organizational Structures: Representing the hierarchy of a company, from executives down to individual contributors.
• Conceptual Models: Famous examples like Maslow's Hierarchy of Needs or the food pyramid are classic uses that show a foundational base supporting subsequent levels.

A pyramid chart makes it instantly obvious how the size of each category decreases (or sometimes increases) as you move through a process.

How to Build a Pyramid Chart in Google Sheets: The Step-by-Step Guide

The secret to building a pyramid chart in Google Sheets is creating a symmetrical stacked bar chart. To do this, we need to add a "dummy" or "helper" column of data that pushes our real data to the center, creating the two sides of the pyramid.

Let's use a standard marketing funnel as our example: Awareness, Consideration, Conversion, and Loyalty.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Structure Your Data Correctly

This is the most important part of the process. A normal dataset for a chart might just have two columns: Category and Value. For our pyramid, we need three.

1. Open a new Google Sheet.
2. Create three columns: Helper, Value, and Category. Note: keeping them in this exact order will make the chart creation process easier.
3. Enter your categories in the Category column. Put them in the order you want them to appear from the top of the pyramid to the bottom.
4. Enter the corresponding numbers in the Value column.

Your sheet should look like this:

Now, for the magic. We need to populate the "Helper" column. This column will contain invisible bars that center the real data. We want each "Helper" value to be just enough to push the "Value" bar perfectly to the middle.

The formula for this is based on finding the largest value in your dataset and centering all other values relative to it.

In cell A2 (the first cell of your Helper column), enter this formula:

=(MAX($B$2:$B$5)-B2)/2

Let's break that down:

• MAX($B$2:$B$5): This finds the largest value in our Value column (in this case, 1000 for "Awareness"). The $ signs lock the range, so it doesn't change when we drag the formula down.
• -B2: It subtracts the value from the current row.
• /2: It divides the result by two. This is because stacked bar charts build from the center out, so we only need half the remaining space on the left side to push the real value bar to the middle.

Click on the small blue square in the corner of cell A2 and drag the formula down to the rest of the cells in the "Helper" column. Your data should now look like this:

With our data perfectly structured, we're ready to create the chart.

Step 2: Insert the Stacked Bar Chart

1. Highlight all of your data, including the headers (from cell A1 to C5).
2. Go to the menu and click Insert > Chart.
3. Google Sheets will likely default to a column chart. In the Chart editor pane that appears on the right, under the Setup tab, find "Chart type" and select Stacked bar chart.

You should now have a chart that looks something like a pyramid, but it’s on its side and the colors are off. Let's fix that.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Customize the Chart to Look Like a Pyramid

This is where we turn our clunky bar chart into a sleek pyramid. All of these options are in the Chart editor pane, mostly under the Customize tab.

1. Make the "Helper" Series Invisible

The blue bars (or whatever default color is used for your "Helper" series) are only there for spacing. We need to make them disappear.

• In the Chart editor, go to the Series dropdown.
• Select your "Helper" data series.
• Under Color, change the fill color to None. The bars will vanish, leaving your real data perfectly centered.

2. Reverse the Pyramid Order

Pyramids should have their large base at the bottom. Our chart currently has it at the top.

• In the Vertical axis settings, check Reverse axis order.

Your chart will flip vertically, giving you the classic pyramid shape with the "Loyalty" level at the top and the "Awareness" base at the bottom.

3. Clean Up the Axes and Labels

Our pyramid looks good, but the labels are on the left side. Let's incorporate them into the chart itself.

• Under the Series dropdown, select your "Value" series.
• Scroll down and check Data labels. Your values (1000, 600, etc.) will now appear on the chart segments.
• You can change the position, font, and color here as well. "Center" is usually a good choice.
• Next, go back to Vertical axis settings. To hide the labels on the left, you can set the text color to white (or match your background color), or set the font size to the minimum, making them virtually disappear.

4. Add a Title and Final Touches

• Go to Chart & axis titles and give your chart a clear, descriptive title like "Marketing Conversion Funnel".
• To remove the legend, go to Legend and under Position, select None.
• Adjust the colors of your "Value" series to match your branding or create a gradient effect if desired.

And that's it! You now have a complete, professional-looking pyramid chart directly in Google Sheets.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

An Easier "Good Enough" Alternative: The Funnel Chart

If the steps above seem a bit much and you just need a quick visualization for a funnel, Google Sheets does have a native Funnel chart. Simply highlight your two columns (Category and Value), go to Insert > Chart, and select "Funnel chart" from the options.

This won't be a true pyramid (it's essentially a centered bar chart), but it communicates the proportional flow of a funnel very well with zero manual calculations. It's a great option when speed is more important than the exact pyramid aesthetic.

Tips for Designing Effective Pyramid Charts

• Limit the Levels: Pyramids work best with 3 to 7 levels. Too many, and it becomes cluttered and hard to read.
• Use Logical Ordering: Arrange your data from largest to smallest for a standard pyramid or smallest to largest for an inverted pyramid.
• Color Smartly: Use a gradient of a single color or contrasting colors that are easy to distinguish. Make sure the colors enhance understanding, not confuse.
• Keep Labels Short: Use concise labels to keep the chart clean and readable.

Final Thoughts

Creating a true pyramid chart in Google Sheets requires a clever workaround using a centered stacked bar chart. By adding a simple helper column and making a few key adjustments in the chart customizer, you can build compelling, hierarchical data visualizations that effectively tell a story.

This process of building helper columns and customizing charts is exactly the kind of manual work Graphed aims to eliminate. Instead of calculating formulas, connect your data sources (like Google Analytics, HubSpot, or Salesforce) and simply describe the report you need in plain English. For example, instead of going through all those steps, ask, "Create a funnel report from my HubSpot data showing leads, MQLs, and customers this quarter." Graphed instantly builds an interactive, real-time dashboard for you, saving spreadsheet-wrangling time. Check out how easy it is to get started with Graphed today.