How to Make a Clustered Column Chart

A clustered column chart is one of the most effective ways to compare different sets of data side-by-side. Instead of looking at a separate chart for each category, this chart type groups them together, making it easy to spot trends and identify top performers at a glance. We’ll show you exactly when to use a clustered column chart, some design best practices, and step-by-step instructions for creating one in Excel, Google Sheets, Power BI, and Tableau.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly Is a Clustered Column Chart?

A clustered column chart (also known as a grouped bar chart) uses vertical bars to represent different data points, grouping bars that belong to the same category next to each other. This "clustering" makes visual comparisons intuitive. Each cluster represents a category from the horizontal axis, and the different colored bars within each cluster represent a secondary categorical variable.

Imagine you manage a small coffee shop and you want to compare the sales of three popular drinks - Lattes, Cappuccinos, and Americanos - over four quarters. A clustered column chart would show a cluster of bars for each quarter. Within the "Q1" cluster, you’d see three bars: one for Latte sales, one for Cappuccino sales, and one for Americano sales. This setup immediately lets you see which drink sold best in Q1 and how it stacks up against the others.

The main purpose is direct comparison. You can quickly answer questions like:

• Which product line performed the best in Q4?
• How did user acquisition from Google Ads compare to Facebook Ads last month?
• Which sales region had the highest revenue for Product A vs. Product B?

This side-by-side arrangement is far clearer than a stacked column chart when you need to see the precise value of each sub-category, rather than just their contribution to a total.

Graphed

Still Building Reports Manually?

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

Watch the Demo

When to Use a Clustered Column Chart

Clustered column charts are versatile, but they shine brightest in specific scenarios. Use them when you need to make direct comparisons between different items across multiple categories or time periods.

• Comparing Metrics Across Segments: Let’s say you’re analyzing website traffic. A clustered column chart is perfect for comparing metrics like Sessions, Pageviews, and Bounce Rate across different Traffic Sources (e.g., Organic Search, Social Media, Direct).
• Tracking Performance of Different Products or Services: Just like the coffee shop example, you can use these charts to track the sales, revenue, or customer satisfaction scores of different products on a quarterly or monthly basis.
• Analyzing Survey Results: They are great for visualizing survey responses. You could compare how different age demographics (e.g., 18-25, 26-35, 36-45) responded to a question on a scale of "Very Dissatisfied" to "Very Satisfied."
• Comparing Performance Over Short Time Intervals: When looking at monthly or quarterly data, clustered columns make it easy to see how different series are trending relative to each other. For longer time series, however, a line chart is often a better choice.

How to Make a Clustered Column Chart: Step-by-Step

Creating a clustered column chart is fairly straightforward in most data tools. The key is to organize your data correctly first. Here's how to do it in some of the most popular platforms.

Creating a Clustered Column Chart in Excel

Excel is the go-to for many, and creating this chart type takes just a few clicks. The most important step is setting up your data table properly.

1. Organize Your Data Arrange your data so that your main categories are in the first column, and the different series you want to compare are in the headers of the subsequent columns. For our coffee shop example, the table would look like this:

2. Select Your Data Range Click and drag your mouse to highlight the entire table, including the headers (from cell A1 to D5 in this case).

3. Insert the Chart With your data selected, navigate to the Insert tab on the Ribbon. In the Charts group, click the Insert Column or Bar Chart icon (it looks like a small bar chart). A dropdown menu will appear. Under the "2-D Column" section, select the first option, which is Clustered Column.

4. Customize Your Chart Excel will instantly generate the chart. Now, you can clean it up:

• Add a Chart Title: Click on "Chart Title" and type something descriptive, like "Quarterly Drink Sales."
• Adjust the Legend: Excel automatically creates a legend based on your column headers ("Lattes Sold," etc.). You can move it or format it by clicking on it.
• Format the Axes: Right-click the vertical or horizontal axis to open the "Format Axis" pane, where you can change the number formatting, scale, and font.
• Change Colors: Click on a bar series to select all bars of that color. Then, right-click and choose "Format Data Series" to change the fill color.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Creating a Clustered Column Chart in Google Sheets

The process in Google Sheets is quite similar to Excel, revolving around the Chart editor tool.

1. Prepare Your Data Set up your data in the same format as you would for Excel, with main categories in the first column and series in the subsequent columns.

2. Select the Data Highlight your table, including the row and column headers.

3. Insert a Chart Go to the menu and select Insert > Chart. Google Sheets will often default to the correct chart type, but if it doesn't, the Chart editor pane will appear on the right side of your screen.

4. Select the Right Chart Type In the Chart editor, under the Setup tab, find the "Chart type" dropdown. Scroll down to the "Column" section and select the icon for a standard Column chart (not the stacked one).

5. Customize and Refine Switch to the Customize tab in the Chart editor to make adjustments:

• Chart & axis titles: Expand this section to set titles for your chart, horizontal axis, and vertical axis.
• Series: Change the color of each data series (Lattes, Cappuccinos, Americanos) individually.
• Legend: Choose the position of your legend (top, bottom, right).
• Gridlines and Ticks: Add or remove gridlines for better readability.

Creating a Clustered Column Chart in Power BI

For more interactive, dashboard-focused analysis, Power BI is an excellent tool.

1. Load Your Data Use the Get Data option on the Home ribbon to load your data into Power BI Desktop.

2. Choose the Visualization In the Visualizations pane, click the icon for the Clustered column chart.

3. Drag and Drop Your Fields Select your chart on the canvas, then drag fields from the Fields pane into the appropriate wells:

• Axis: Drag your primary category, e.g., "Quarter."
• Legend: Drag the "Drink Type" field.
• Values: Drag the measure like "Units Sold."

Power BI will aggregate and display the chart. If your data is not already in the correct format, you may need to unpivot it in Power Query to get separate "Quarter," "Drink Type," and "Sold" columns.

4. Format the Chart Use the paintbrush icon in the Visualizations pane to customize colors, labels, titles, and axes.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Creating a Clustered Column Chart in Tableau

Tableau simplifies creating clustered columns through its drag-and-drop interface.

1. Connect to Your Data Connect Tableau to your data source, Tableau will assign fields as Dimensions (categorical) and Measures (numeric).

2. Build the Basic Chart Drag your main categorical field (e.g., "Quarter") to the Columns shelf. Drag your measure (e.g., "Sales") to the Rows shelf.

3. Create the Clusters To generate clusters, drag the "Drink Type" dimension onto the Color card in the Marks pane. Tableau will split each bar into colored segments, creating the clustered effect.

Common Mistakes to Avoid

A good chart is easy to read, a bad one creates confusion. Here are some pitfalls to watch out for:

• Too Much Data: A clustered chart gets cluttered if you compare more than 3-4 series or have dozens of categories. Consider breaking it up or choosing a different visualization.
• Unclear Legends: Always include a clear legend so viewers understand what each color represents.
• Not Starting the Y-Axis at Zero: The vertical axis should start at zero to avoid misleading differences.
• Poor Color Choices: Use distinct, accessible colors that are easy to differentiate.

Final Thoughts

The clustered column chart is a fantastic tool for comparing different data series side-by-side. Grouping related data points into clusters provides clear, immediate insight into performance across categories. Following the steps for Excel, Google Sheets, Power BI, or Tableau will help you create precise, insightful visuals for your reports and dashboards.

Of course, building charts manually, especially with data from multiple platforms like Google Analytics, Facebook Ads, and your CRM, can be time-consuming. At Graphed, we’ve connected directly to these sources so instead of building charts, you can ask questions directly. You can tell our AI analyst, "Create a clustered column chart comparing new users from Google and Facebook by month for the last quarter," and get a live, interactive chart instantly — no setup or formatting required.