How to Make a Clustered Column Chart in Looker

Creating a clustered column chart in Looker Studio is a fantastic way to compare different categories of data side-by-side. Unlike a simple bar chart, this format allows you to see how multiple series perform against each other over the same period. This article will walk you through exactly how to build one, customize it for clarity, and avoid common mistakes that can make your chart confusing.

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

What is a Clustered Column Chart?

A clustered column chart (also known as a grouped column chart) displays more than one data series in vertical columns that are grouped together by category. Each cluster of columns represents a single category from the main dimension, and each column within the cluster represents a sub-category.

For example, if you're tracking website traffic, your main dimension might be "Month." Your sub-categories could be traffic sources like "Organic Search," "Paid Search," and "Direct." The resulting chart would show a cluster of three columns for January (one for Organic, one for Paid, one for Direct), another cluster for February, and so on. This immediately lets you see which traffic source was most effective each month and compare their performance directly.

When to Use a Clustered Column Chart

This chart type is incredibly useful but works best in specific scenarios. You should use a clustered column chart when your primary goal is to compare the performance of a few categories across different groups or time periods.

Here are a few common use cases for marketers, analysts, and business owners:

• Comparing Marketing Campaign Performance: Visualize clicks, conversions, or cost for different campaigns (Campaign A, Campaign B, Campaign C) on a month-by-month basis.
• Tracking Sales by Product and Region: Show revenue for different product lines (Product 1, Product 2) across several sales regions (North, South, East, West).
• Analyzing Web Traffic Sources: Display the number of sessions from different channels (Organic, Paid, Social) over the last six months.
• Monitoring Multi-Platform Social Media Engagement: Compare likes, shares, and comments across Facebook, Instagram, and X (Twitter) for each week.

The key is direct comparison. If you want to see the total sum of all categories, a stacked column chart is a better choice. But for a distinct, side-by-side comparison, the clustered chart is perfect.

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

Getting Your Data Ready for Looker Studio

Before you jump into Looker Studio, a clean and properly structured dataset is essential. Your chart won't work correctly if the data isn't set up logically. For a clustered column chart, you typically need data in one of two formats.

Format 1: The Breakdown Dimension Method (Preferred) This is the most common and flexible format. Your data should have at least three columns:

• A Dimension column (e.g., 'Month', 'Quarter', 'Region'). This will be your x-axis.
• A Breakdown Dimension column (e.g., 'Campaign', 'Product Category', 'Traffic Source'). This defines the individual columns within each cluster.
• A Metric column (e.g., 'Revenue', 'Sessions', 'Conversions'). This is the numerical value being measured, forming the y-axis.

Here’s how that looks in a simple Google Sheet:

Format 2: The Multiple Metrics Method Alternatively, your sub-categories can be in their own separate metric columns. This format is less flexible but works if your data is already aggregated this way.

Your data would look like this:

While Looker Studio can handle both, the "Breakdown Dimension" method (Format 1) is generally easier to manage and scale.

Step-by-Step Guide to Creating a Clustered Column Chart in Looker Studio

Let's build a chart using the first method with data from a source everyone can access: Google Analytics. We'll create a chart showing website sessions by device category over time.

Step 1: Open a Report and Connect Your Data

Start by opening a new, blank report in Looker Studio. Once the new report is open, you’ll be prompted to connect to data. Search for and select the Google Analytics connector. From there, you should see a sample account labeled "[Sample] Google Analytics Data" or similar. This is perfect for practice.

Select that sample account and click "Add."

Step 2: Add a Column Chart to Your Report

Once your data source is connected, go to the toolbar at the top and click on Add a chart. From the dropdown menu, select the standard Column chart (not the stacked one). Click anywhere on your report canvas to place the chart. Looker Studio will generate a simple column chart with default dimensions and metrics.

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: Configure Your Dimensions and Metrics

This is where the magic happens. With your new chart selected, a configuration panel will appear on the right side of the screen. Look for the Setup tab.

1. Set the Dimension: This field determines the labels on your x-axis. By default, Looker might put something like Session default channel group. Drag that out and find the Date dimension. Drag Date into the Dimension field. To make it more readable, click on the pencil icon next to Date and change its Type to Date & Time > Year Month. This aggregates daily data into monthly buckets.
2. Set the Breakdown Dimension: This is the key to creating the clusters. Find the dimension you want to use for the side-by-side comparison. In our case, this is Device category. Drag Device category into the Breakdown Dimension field, located just below the main Dimension field. You should see your single-column bars instantly split into clusters (likely showing desktop, mobile, and tablet).
3. Set the Metric: This is the value you’re measuring. Look for the metric like Sessions. Drag Sessions into the Metric field. Your chart now displays the number of sessions for each device category, clustered by month.

That's it! You've successfully created a clustered column chart. Now, you can customize it to make it more professional.

Customizing and Styling Your Clustered Column Chart

A well-styled chart is easier to read and understand. With your chart selected, click the Style tab in the right-hand configuration panel.

Adjusting Colors and the Legend

Looker Studio automatically assigns colors, but you can change them. Under the "Color by" section, you can either assign colors based on the Dimension order or set specific colors for each Breakdown Dimension value. For example, you can set "Desktop" to be blue, "Mobile" to green, etc.

You can also control the legend's position (top, bottom, right, or none) and alignment under the Legend section.

Adding and Formatting Data Labels

Displaying the exact values on each column can add a lot of clarity. Scroll down to the Data Labels section and check the "Show data labels" box. You can then adjust the font size, color, and even use "Compact Numbers" to shorten large figures (e.g., showing 1.5M instead of 1,500,000).

Refining the Axes

Give your audience context by cleaning up the X and Y axes.

• In the Grid section, you can change the grid color or hide it completely.
• Under the Left Y-axis and Bottom X-axis sections, you can toggle axis titles, adjust the text size, and change the intervals. This is especially helpful if your axis labels are overlapping or hard to read.

Common Pitfalls and How to Avoid Them

As you build your chart, you might run into a few common issues. Here’s what to look out for.

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

Pitfall 1: Clutter from Too Many Categories

A clustered column chart looks best with 3-5 categories in the breakdown dimension. If you add ten campaigns to a single cluster, the columns will become so thin that the chart is completely unreadable. If you have more than five categories, consider a different chart type, like a stacked bar chart or individual scorecards for each category.

Pitfall 2: Using the Wrong Data Types

Looker Studio is generally smart about identifying dates, numbers, and text, but errors can happen with imported data (like from a CSV). If your chart isn't displaying correctly, double-check that your dimension field is a Date or Text type, and your metric field is a Number type in the data source settings.

Pitfall 3: Not Sorting Your Data

By default, your clusters (the dimension on your X-axis) might appear in alphabetical or random order. To tell a better story, sort your chart by a "time" dimension in ascending order. You can find the sorting options at the bottom of the Setup tab. This helps viewers easily see trends over time.

Final Thoughts

Clustered column charts are powerful tools in any report or dashboard, perfect for comparing different categories across a shared dimension. By defining a primary dimension, a breakdown dimension, and a metric in Looker Studio, you can create insightful, easy-to-read visualizations that tell a clear story.

Of course, building great marketing and sales dashboards still takes time, even with a tool as intuitive as Looker Studio. Figuring out which dimensions and metrics to use, connecting data sources, and fiddling with visual settings adds up. We built Graphed to remove that friction completely. Instead of clicking through menus, you can just ask a question in plain English, like, "Show me a column chart comparing website sessions from desktop versus mobile for the last 6 months," and instantly get a live, interactive chart connected directly to your data.