How to Create a Side by Side Bar Chart in Excel
A side-by-side bar chart is one of the clearest ways to compare data between two or more different groups. This guide will walk you through exactly how to prepare your data, create the chart in a few clicks, and customize it to make your insights easy to understand.
What is a Side-by-Side Bar Chart and When Should You Use One?
A side-by-side bar chart, known in Excel as a "Clustered Bar Chart," places bars representing different categories next to each other, grouped together. This visual grouping makes it incredibly simple to compare the performance of distinct items across the same measures.
Think about a scenario where you want to compare product sales from the current quarter against the previous quarter. You could line up a bar for "Product A - Q1" right next to "Product A - Q2," followed by a small gap, and then do the same for Product B. This immediate comparison is exactly what this chart type is designed for.
Use a side-by-side bar chart when you need to answer questions like:
- How did this year's sales figures for each product compare to last year's?
- Which marketing channel generated more leads for each campaign this month?
- How did student test scores in Math, Science, and English compare between two different schools?
The goal is always to create a clear, direct comparison between paired sets of data.
How to Prepare Your Data for a Side-by-Side Chart
Your chart is only as good as the data powering it. Before you even think about clicking the "Insert Chart" button, you need to structure your data in a way that Excel can understand. Getting this right is the most important step and will save you a lot of headaches.
Excel needs a simple, clean table format. For a side-by-side bar chart, the ideal layout looks like this:
- Column A (The Categories): The starting column should contain the items you want to compare on the vertical axis. These are your main categories, like product names, sales reps, or months.
- Row 1 (The Series/Groups): The columns to the right of your categories should contain the groups or time periods you are comparing across. These will become the different colored bars in each cluster, such as "Q1 2024," "Q2 2024," or "New York," "Los Angeles."
- The Data Body: The cells where your rows and columns intersect should contain the numerical values you want to plot.
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
Example Data Structure
Let's imagine you own an online store and you want to compare product sales from the first half of the year. Your data in an Excel or Google Sheet should be organized like this:
Notice how clean this table is. The products are listed down the first column (our categories), and the quarters are across the first row (our series). The sales figures fill in the rest of the table. There are no empty rows or columns breaking it up, and no merged cells causing confusion.
Step-by-Step Guide: Creating a Side-by-Side Bar Chart in Excel
With your data perfectly organized, creating the chart itself is quick and easy. Follow these steps.
Step 1: Select Your Data
Click on the top-left cell of your data table (in our example, the cell containing "Product"). Then, hold down the Shift key and click on the bottom-right cell (the last sales figure). This will highlight your entire data range, including the headers.
Step 2: Insert a Bar Chart
With your data highlighted, navigate to the Excel ribbon at the top of the screen. Click on the Insert tab. In the Charts group, you'll see several small icons representing different chart types.
Find and click the icon that looks like a vertical bar chart, labeled "Insert Column or Bar Chart."
Step 3: Choose the "Clustered Bar" Chart
A dropdown menu will appear with several chart options under different headings. You want to create a horizontal bar chart, so look under the "2-D Bar" section.
Hover your mouse over the first option. It will be labeled "Clustered Bar." This is Excel's term for a side-by-side chart. Click it.
Note: Be careful not to select "Stacked Bar." A stacked bar chart combines the values into a single bar, which is used to show a part-to-whole relationship, not a side-by-side comparison.
Step 4: Review Your New Chart
Just like that, Excel will instantly generate and place a chart onto your worksheet. It will automatically use your column headers ("Q1 Sales," "Q2 Sales") for the legend and your first column ("Product") for the vertical axis labels. You'll see colored bars clustered together for each product, making the comparison immediate.
Customizing Your Chart for Maximum Clarity
The default chart is a great start, but a few quick customizations can turn it from a simple visualization into a professional, compelling piece of data storytelling.
1. Add a Descriptive Chart Title
"Chart Title" is not good enough. Double-click the default title and type something clear and concise. A good title tells the viewer exactly what they are looking at.
- Bad Title: Chart Title
- Good Title: Q1 vs. Q2 2024 Product Sales Comparison
2. Add Data Labels for Precision
Sometimes you want to see the exact value of each bar without having to guess based on the axis. Click anywhere on your chart to make the Chart Design and Format tabs appear. Alternatively, you can click the green "+" button that appears to the right of the chart.
In the "Chart Elements" menu, check the box next to Data Labels. The specific sales numbers will appear next to or inside of each bar, providing viewers with precise figures at a glance.
3. Modify Colors for Better Readability or Branding
Excel's default colors are fine, but you might want to adjust them to fit your company's branding or to draw attention to a specific data series.
To change the color of a set of bars, click once on any of the bars in a series (for example, any blue bar for "Q1 Sales"). All bars in that series will be selected. Right-click on one of the selected bars, choose "Format Data Series..." from the menu, and then go to the "Fill & Line" (paint bucket icon). Here you can choose a new fill color.
4. Format the Axes
Clear axes are non-negotiable. Again, click the green "+" button next to your chart and check the box for Axis Titles. Two text boxes will appear: one below the horizontal axis and one next to the vertical axis.
Click on the horizontal axis title and label it appropriately. In our example, a good title would be "Sales ($)." The vertical axis title might not be necessary if the category labels are self-explanatory, but if you need extra context, you can add it here. A clear axis can immediately answer any viewer questions about what your units of measurement are.
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
Common Pitfalls and How to Avoid Them
Even with a process this simple, there are a few common issues people run into. Here’s what to look out for.
- Messy Data Structure: This is the number one cause of chart problems. Merged cells, blank rows within your data, or non-tabular layouts will confuse Excel. Always clean and structure your data before you begin.
- Choosing the Wrong Chart Type: It’s easy to accidentally click "Stacked Bar" instead of "Clustered Bar." If all your data is crammed into one monstrous bar per product, you’ve picked the wrong one. Simply delete that chart and re-insert the correct one.
- Too Much Clutter: If you try to compare ten different time periods for thirty different products, your chart will become an unreadable mess of tiny bars. Sometimes, less is more. For large datasets, consider filtering your data to show only the "Top 5 Products" or breaking the information into multiple charts.
Pro Tip: Switching Rows and Columns
What if you wanted to see the comparison from a different angle? Instead of grouping by product, what if you wanted to group the bars by Quarter, to see how each product performed within each period?
Excel has a one-click solution. Click your chart, and go to the Chart Design tab. Look for the "Switch Row/Column" button. Clicking this will instantly reconfigure your chart. Now, you'll have two main clusters on the vertical axis: "Q1 Sales" and "Q2 Sales," with the different products shown as colored bars within those clusters. This gives you a new perspective on the same data in seconds.
Final Thoughts
Creating a side-by-side bar chart in Excel is an effective skill for anyone looking to make data-driven comparisons. By properly setting up your data table, selecting the "Clustered Bar" chart type, and adding a few simple customizations, you can quickly build clear and professional visuals that tell a powerful story.
Often, the hardest part of building charts isn't the final clicks in Excel, but the tedious work of logging into different platforms, exporting CSV files, and manually cleaning the data. When this manual process drains your week, tools can make a huge difference. At Graphed , we automate all of that by connecting directly to your tools like Google Analytics, Shopify, and various ad platforms. You can simply ask a question in plain English, like "Compare my product sales for Q1 vs Q2," and get a live, updating dashboard in seconds, saving you from all the manual spreadsheet work.
Related Articles
AI Agents for SEO and Marketing: The Complete 2026 Guide
The complete 2026 guide to AI agents for SEO and marketing — what they are, top use cases, the best platforms, real-world examples, and how to get started.
AI Agents for Marketing Analytics: The Complete 2026 Guide
The complete 2026 guide to AI agents for marketing analytics — what they are, how they differ from automation, 10 use cases, pitfalls, and how to start.
How to Build AI Agents for Marketing: A Practitioner's Guide From Someone Who Actually Ships Them
How to build AI agents for marketing in 2026 — a practitioner guide from someone who has shipped a dozen, with the lessons that actually cost time.