How to Make a Distribution Graph in Google Sheets

Looking at the average of your data, like average order value or average time on page, only tells you part of the story. To truly understand your numbers, you need to see their shape - how they are spread out. Creating a distribution graph, also known as a histogram, is the best way to do this. This guide will walk you through, step-by-step, exactly how to build one in Google Sheets to uncover deeper insights from your data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Understanding Your Data's Shape: What's a Distribution Graph?

A distribution graph takes your list of numbers and groups them into equal ranges, called "bins" or "buckets." It then shows you how many data points fall into each bucket with a simple column chart. Think of it like sorting a big bucket of Legos by color, the distribution graph just shows you how many bricks of each color you have. It instantly reveals the underlying pattern of your data set.

Why bother? Because the shape tells you a story that a single average never can:

• See the concentration: Are most of your customers placing orders around $50, or are the order values all over the map?
• Spot the outliers: Do you have a few unusually large orders or a handful of sessions that lasted for hours? These outliers can skew your averages.
• Identify the pattern: Does your data form a symmetric "bell curve," or is it skewed heavily to one side? This can inform your marketing or product strategy.

For example, if you analyze the distribution of your customer purchase values, you might find that while your average order is $60, the vast majority of your customers actually spend between $20 and $40. That simple insight could change how you approach everything from ad spend to promotions.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Get Your Data Ready for Graphing

Before you can make a chart, you need a single column of raw numerical data. This could be anything from a list of sale amounts from your Shopify export, session durations from Google Analytics, or scores from a customer satisfaction survey. For our example, we'll use a list of customer "Order Values," located in Column A.

Step 2: Visualize Your Data with a Histogram Chart (The Easy Way)

Google Sheets has a fantastic built-in tool that can create a distribution graph for you in just a few clicks. This method is fast, easy, and perfect for getting a quick look at your data's shape.

Making a Quick Histogram

1. Select the entire column of your raw data. In our example, click the header for Column A to select all the "Order Value" data.
2. Navigate to the top menu and click Insert > Chart.
3. The Google Sheets Chart editor will open on the right. It will likely default to another chart type, but you can change it. Under the "Chart type" dropdown, scroll down to the "Other" section and select Histogram chart.

Instantly, Google Sheets will analyze your data, choose bucket sizes for you, and generate a histogram. You now have a distribution graph showing how frequently different order values appear in your data.

Customizing Your Buckets and Bins

Google's default bucket sizes are usually pretty good, but you might want more control. For instance, you may want to group order values in neat, $10 increments instead of the $9.1 increments Google chose automatically.

1. With your chart selected, open the Chart editor and click on the Customize tab.
2. Expand the Histogram section.
3. Here you'll find a key setting: Bucket size. Change "Auto" to any number you want. Let's enter 10 to group our data into bins of $10 (0-10, 10-20, 20-30, etc.).
4. You can also check the box for Show item dividers to add a border between the bars, making the chart a bit easier to read.

After adjusting the bucket size, your chart now tells a clearer story. You can easily see that the most frequent purchase amount is between $40 and $50, with very few purchases occurring over $90.

An Alternative Method: Building a Graph from a Frequency Table

The built-in histogram is excellent for speed, but sometimes you need more granular control over your bins or want to use the frequency data for other calculations. In this case, you can first build a frequency table and then create a standard column chart from it. This gives you absolute control over how your data is grouped and displayed.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Create a Frequency Distribution Table

A frequency distribution table is just a simple two-column list: one column for your bin labels and another for counting how many values fall into that bin.

Set Up Your Bins

First, decide on the ranges you want to use. You need a column to define the lower bound of each bin and another for the upper bound. For our order value data, let's stick with increments of $10.

In a blank area of your sheet, create three columns: "Bin Lower," "Bin Upper," and "Frequency." Fill out the lower and upper bounds for your ranges.

Use the COUNTIFS Formula to Tally Your Data

Now, we'll use a formula to count how many data points from Column A fall into each bin. The COUNTIFS function is perfect for this, as it lets you count cells that meet multiple criteria (in our case, being greater than or equal to the lower bound AND less than or equal to the upper bound).

1. Click into the first cell of your "Frequency" column (cell E2 in our example).
2. Type the following formula and press Enter:

=COUNTIFS($A:$A, ">="&C2, $A:$A, "<="&D2)

Let's quickly break this down:

• $A:$A refers to our raw data in the "Order Value" column. The dollar signs lock the reference so it doesn't change when we drag the formula down.
• ">="&C2 is our first condition. It checks for values that are greater than or equal to the value in cell C2 (our lower bin limit).
• "<="&D2 is our second condition. It checks for values that are less than or equal to the value in cell D2 (our upper bin limit).

After you press Enter, click the cell with the formula and drag the small blue square at the bottom-right corner down to apply the formula to the rest of your bins. Now you have a completed frequency table!

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Create a Column Chart From Your Table

With your frequency table prepared, making the chart is straightforward.

1. First, create bin labels that combine the lower and upper bounds, like "0-10," "11-20," etc., in a "Bin Label" column.
2. Select your "Bin Label" column and your "Frequency" column. Hold down Command (on Mac) or Ctrl (on PC) to select non-adjacent columns.
3. Go to Insert > Chart.
4. Google Sheets should automatically create a Column Chart. If it doesn't, select it from the Chart editor dropdown.

This is a standard column chart. To make it look more like a traditional histogram where the bars touch or nearly touch, you can adjust the gap width.

Adjust Histogram Appearance

1. In the Chart editor, go to the Customize tab.
2. Expand the Series section.
3. You'll see a slider for Gap width. Reduce it from the default down to 0% or 10% for a classic histogram look.

What Your Distribution Graph is Telling You

Once you have your graph, you can analyze its shape to understand your data better. Here are a few common patterns you might see:

• Normal Distribution (Bell Curve): A symmetrical mound in the middle with tails that taper off evenly on both sides. This signifies that most of your data points are clustered around the average. Many natural phenomena, like human height, follow this pattern.
• Skewed Right (Positively Skewed): The "hump" of the chart is on the left, with a long "tail" of less frequent values stretching to the right. A great example of this is income data, most people have a similar income, while a few have extremely high incomes that create the long tail.
• Skewed Left (Negatively Skewed): The opposite of a right skew, with the hump on the right and a long tail to the left. You might see this in test scores where most students performed very well, but a few low scores pull the tail to the left.
• Bimodal Distribution: A chart with two distinct peaks. This often indicates your data is coming from two different groups. For example, if you charted restaurant traffic over a day, you'd likely see a peak at lunch and another at dinner.

Final Thoughts

Crafting a distribution graph in Google Sheets is a simple but incredibly powerful way to move beyond basic averages and see the complete picture of your data. Whether you use the speedy built-in histogram chart or opt for the manual control of a frequency table, the process helps you uncover the patterns and stories hidden in your numbers.

While building these charts in Google Sheets is a fantastic skill, we know that manually creating reports can eat up valuable time, especially when you're juggling data from multiple sources like Google Analytics, Shopify, and your CRM. We built Graphed to solve this by letting you create dashboards and interactive reports using simple, plain English. Instead of wrestling with formulas, you can just ask, "Show me the distribution of order values from Shopify last quarter," and get a live, interactive chart in seconds, allowing you to focus on the story your data is telling - not the busywork of building it.