How to Make a Clustered Column Chart in Excel

A clustered column chart is one of the most effective ways to compare different items across several categories right inside your spreadsheet. Instead of just showing a single data point, it groups bars side-by-side, making it easy to see performance, spot trends, and find outliers at a glance. This guide will walk you through exactly how to set up your data, create the chart in Excel, and customize it to tell a clear and persuasive story.

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?

Think of a regular column chart (or bar chart) where you have one bar for each category. Now, imagine you have sub-categories you want to compare within each main category. A clustered column chart places the bars for these sub-categories right next to each other, forming "clusters." This visual grouping is perfect for comparing performances side-by-side.

For example, instead of just charting "Total Sales per Quarter," you could use a clustered column chart to show "Sales per Product Line for each Quarter." Each quarter would be a cluster on the horizontal axis, and within each cluster, you'd have separate columns for "Product Line A," "Product Line B," and "Product Line C."

When should you use a clustered column chart?

• Comparing performance over time: Track the monthly sales of different products, website traffic from unique channels (like organic, social, and direct), or ad spend across various campaigns over several quarters.
• Comparing parts of a whole across groups: Show survey results from different demographic groups answering the same set of questions or compare budget allocation vs. actual spending for different departments.
• Categorical data comparison: Compare inventory levels for different product types across several warehouse locations.

The key is having at least two categorical variables - one for the main grouping (the clusters) and another for the individual columns within each cluster.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Prepare Your Data in Excel

Before you even click the "Insert Chart" button, the most important step is setting up your data correctly. A well-organized table is the foundation of a great chart. Messy data leads to a confusing chart every time.

Your data should be arranged in a simple table with clear headers. The first column or first row should contain the categories that will form your main clusters, and the adjacent columns or rows should contain the sub-categories you want to compare.

Let's use a business example: tracking quarterly unit sales for three different software products. Here’s how you would structure the data:

In this table:

• Column A (Quarter) represents the main categories that will appear on the horizontal (X) axis.
• Columns B, C, and D (the product names) are the different data series. Their bars will be clustered together for each quarter.
• The numbers are the values that will determine the height of each column.

Data-Prep Tips:

• Clear Headers are Non-Negotiable: Make sure every column and row that you intend to plot has a clear, concise header. Excel uses these to create the legend and axis labels automatically.
• No Blank Rows or Columns: Ensure there are no completely empty rows or columns in the middle of your data set. This can confuse Excel and cause it to select only a portion of your data.
• Keep It Tidy: Your analysis table should be separate from any raw data. This makes it easier to select the correct range for charting without including unnecessary information.

Step-by-Step Guide to Creating Your Chart

With an organized data table ready to go, creating the actual chart takes just a few clicks. Follow these steps to bring your chart to life.

Step 1: Select Your Data

Click and drag your cursor to select the entire data range you want to include in the chart. In our example, you would highlight cells A1 through D5. Make sure you include the row and column headers - Excel is smart enough to use them for labels.

Step 2: Insert the Chart

Navigate to the Insert tab on Excel's top ribbon. In the Charts group, you'll see a small icon that looks like a column chart. Click it. A dropdown menu appears with several chart options. Under the 2-D Column section, the very first option is Clustered Column. Click on that icon.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Voilà! Your Chart Appears

Excel will instantly place a basic clustered column chart onto your worksheet. It will automatically assign colors to each data series (Alpha Suite, Beta Tools, and Gamma Platform), create a vertical (Y) axis for the sales values, and use your quarter labels for the horizontal (X) axis.

What you have now is a functional chart, but it's not yet a great chart. The next steps involve customizing it for maximum clarity and impact.

Customizing Your Chart to Tell a Better Story

The default Excel chart is a good start, but a few tweaks can turn it from a simple data visualization into a powerful communication tool. When you click on your chart, two new tabs called Chart Design and Format appear in the ribbon. These are your control centers for customization.

Give Your Chart a Descriptive Title

"Chart Title" is not good enough. Your title should tell the viewer exactly what they are looking at. Click on the default chart title and replace it with something specific and informative.

• Bad Title: Chart Title
• Good Title: Quarterly Unit Sales Performance
• Great Title: 2023 Unit Sales by Product Line

Add or Format Data Labels

Data labels display the exact value on top of or inside each column, which saves your audience from having to estimate values from the Y-axis. This is especially helpful in presentations.

1. Select your chart. A small plus sign (+) icon, called Chart Elements, will appear on the upper-right side.
2. Click the (+) icon and check the box for Data Labels.
3. You can click the little arrow next to "Data Labels" for more options on where to place them (e.g., Center, Inside End, Outside End). "Outside End" is usually the cleanest choice.

Clarify Your Axes

Your chart needs clear axis labels to provide context. The vertical axis shows the magnitude (what's being measured), and the horizontal axis shows the categories. Click the (+) icon again and check the box for Axis Titles. Two text boxes will appear. Click on each one to edit:

• Vertical (Value) Axis Title: Change this to "Units Sold" or "Sales Revenue ($)."
• Horizontal (Category) Axis Title: You might use "Quarter" or "Time Period."

Use Color Thoughtfully

The default colors Excel picks are random. Be more intentional with your color choices to guide the viewer's eye.

• Changing the whole color palette: Go to the Chart Design tab and click Change Colors to quickly apply a new, professional color scheme.
• Changing a single series: To change the color for just one product, click on any of its columns. This will select all columns for that series. Then, go to the Format tab, click Shape Fill, and choose a new color. This is excellent for highlighting your most important product or calling out a competitor.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Reposition the Legend

The legend tells the viewer what each color represents. Excel might place it at the bottom or on the right. If it's taking up too much space or feels awkwardly placed, move it. Click the (+) icon, hover over Legend, and choose a new position like Top or Right.

Best Practices & Common Mistakes to Avoid

Creating a chart is easy. Creating an effective chart requires a bit more thought. Here are some tips to keep in mind.

Best Practices:

• Keep it Clean: Clustered column charts can get crowded quickly. As a rule of thumb, try to limit yourself to four or five sub-categories (data series) per cluster. If you have more, the chart might become hard to read, and you should consider a different chart type, like a stacked column chart or a line chart.
• Order Your Data Intentionally: If the order of your columns doesn't matter (e.g., product names instead of a time sequence), consider arranging them in descending or ascending order. This makes it much easier to see which item is the top or bottom performer.
• Use Contrasting Colors: Make sure the colors for your series are distinct enough to be easily differentiated, especially for people with color vision deficiency. Avoid using very similar shades of blue right next to each other.

Common Mistakes to Avoid:

• Too Many Categories: Don't try to plot 52 weeks on a single clustered column chart. It will turn into an unreadable "skyscraper jungle." For long time-series data, a line chart is almost always a better choice.
• A Misleading Y-Axis: By default, Excel's value axis starts at zero. Resist the temptation to change this unless you have a very specific reason. Starting the axis at a higher value can visually exaggerate minor differences between data points, creating a misleading picture.
• Forgetting About an Endpoint: Don't just make a chart, make a point. What is the one thing you want your audience to take away from this visual? Customize your title, colors, and annotations to hammer that single point home.

Final Thoughts

Mastering the clustered column chart in Excel is a fantastic skill that allows you to present comparative data in a format that is intuitive and easy to digest. By carefully preparing your data, using Excel’s charting tools, and applying thoughtful customizations, you can create professional visuals that clearly communicate your findings and lead to better decisions.

While creating charts in Excel is powerful, it often involves a lot of manual work - downloading CSVs, cleaning data, and rebuilding reports on a weekly or monthly basis. At Graphed we decided to automate this entire process. Instead of manually arranging data tables, you can connect your data sources (like Shopify, Google Analytics, or Salesforce) and just describe the chart you need in plain English. For example, simply ask, "create a column chart of Shopify sales by product for each quarter this year," and our AI data analyst builds a live, interactive dashboard that updates automatically, helping you surface insights in seconds, not hours.