How to Make a Comparison Bar Graph in Google Sheets

Comparing different sets of data is essential for finding out what’s working and what isn’t. A comparison bar graph is one of the clearest ways to show that relationship visually, and Google Sheets makes it surprisingly simple to create one. This tutorial will guide you step-by-step through setting up your data, building the chart, and customizing it to deliver a clear, impactful message.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Comparison Bar Graph?

You’ve surely seen them everywhere. A comparison bar graph, often called a grouped bar chart, uses bars lined up side-by-side to compare values across multiple categories. Instead of a single bar for each item on your axis, you have two or more, allowing for a direct visual A/B test without forcing your audience to squint at a table of numbers.

For instance, you could use a comparison bar graph to:

• Compare the monthly sales of two different products.
• Track website page views from Google versus Facebook over several quarters.
• Show the performance of different email campaigns based on open rates or click-through rates.
• Visualize survey results, such as comparing "Satisfied" versus "Unsatisfied" customer responses across different store locations.

The power is in that side-by-side layout. A viewer can instantly see which group is performing better in each period. It’s the perfect chart for telling a story of competition, growth, or change between two or more subjects.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Setting Up Your Data for a Perfect Chart

The single most important step in creating a great chart is organizing your data properly first. If your data isn't structured correctly, Google Sheets can get confused and produce a chart that doesn't make sense. For a comparison bar graph, you need a simple, clean table.

Your first column should always represent your primary categories - this is what will be displayed on your main axis (usually the horizontal x-axis). These are the constant “buckets” you're comparing topics across, such as months, product names, or ad platforms.

Each column after that should represent a different data series you want to compare on the chart. Let's use a practical example. Say we want to compare the online revenue generated by our Google Ads and Facebook Ads campaigns for the first quarter of the year.

This is how you would set up your data table in Google Sheets for the best results:

Key Data Formatting Tips

• Always Use Headers: Include clear, descriptive headers in the very first row. In our example, they are "Month," "Google Ads Revenue," and "Facebook Ads Revenue." Google Sheets will automatically use these headers to create a legend and suggest axis titles, saving you time later.
• Keep Data Types Consistent: Make sure the data in each column is the same format. If you're tracking revenue, use the currency format. If it's something like website visits, stick to a number format. Avoid mixing text and numbers within your data columns, which can lead to errors.
• Avoid Empty Gaps: To avoid confusing the software, maintain a solid block of data without any completely empty rows or columns in the middle.

How to Make a Comparison Bar Graph: Step-by-Step

With your data correctly formatted, creating the graph itself takes just a few clicks. Follow these steps.

Step 1: Select Your Data

Click and drag your mouse to highlight the entire data table, including your headers. In our example, you’d select cell A1 down to C4.

Step 2: Insert the Chart

With your data highlighted, navigate to the Google Sheets menu bar at the top of the screen and click Insert, then select Chart from the dropdown menu.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Choose the Right Chart Type

Google Sheets is pretty smart and will usually default to the correct chart type for comparison data - a Column chart. The Chart editor pane will appear on the right side of your screen. If Sheets guessed a different chart (like a line or pie chart), simply click the dropdown menu under Chart type and select either a Column chart for vertical bars, or a Bar chart for horizontal bars.

For what we’re doing here, you’ll see our two data series - Google Ads and Facebook Ads - displayed as side-by-side bars for each month. Success!

Just be sure you haven't selected a "Stacked" bar chart. A stacked chart places values on top of each other, which is useful for showing parts of a whole, but not for direct side-by-side comparison.

Customizing Your Graph for Maximum Clarity

The default chart is functional, but a few quick tweaks in the customization menu will make it far more professional and easier to understand. Double-click anywhere on the chart area to bring back the Chart editor sidebar, and this time, click on the Customize tab at the top.

Here are the most valuable adjustments you can make:

1. Chart & Axis Titles

A good chart should be understandable on its own, and that starts with its titles. Be specific and clear.

1. In the Customize tab, click on Chart & axis titles.
2. Under Title text, change the generic default title to something that tells a complete story, like "Q1 Digital Ad Revenue: Google vs. Facebook."
3. Next, select Vertical axis title from the dropdown and type in "Total Revenue ($)" to add context to your numbers. Your horizontal title is likely correct already, thanks to your "Month" header.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Series Colors and Labels

This section controls the appearance of your data bars.

1. Expand the Series menu. You’ll see options for both of your data sets ("Google Ads Revenue" and "Facebook Ads Revenue").
2. Select one, and use the Color picker to change its fill color. Differentiating them clearly is important. A common practice is using brand colors - for instance, a blue for Google and a different blue for Facebook.
3. While you're here, consider checking the box for Data labels. This will display the exact value on top of or inside each bar, saving people from having to trace lines over to the vertical axis to estimate a value.

3. Legend Position

The legend tells the viewer what each color represents. You can move it around to improve the chart's layout and readability.

1. Go to the Legend section in the Customize tab.
2. Use the Position dropdown menu to move it. While "Auto" works okay, explicitly setting it to "Top" or "Bottom" often gives the chart a cleaner, more organized look.

4. Gridlines and Ticks

Finally, your graph's background can sometimes feel cluttered with too many lines. Under the Gridlines and Ticks section, you can tidy this up.

1. Select Vertical axis from the dropdown menu.
2. Here, you can reduce the number of gridlines or change their color to a fainter gray, helping the colored bars stand out more. If you added data labels, you might not even need the gridlines at all.

Final Thoughts

By arranging your data thoughtfully and making a few key customizations, you can create a comparison bar graph in Google Sheets that tells a crystal-clear story. This kind of visualization quickly turns plain numbers into actionable insights, helping you and your team see performance trends and make better decisions.

While dashboards in Google Sheets are useful, they can become time-consuming to maintain, especially when you need to constantly pull in information from apps like Google Analytics, Shopify, or HubSpot. At Graphed, we automate all of that manual reporting work. You can connect your data sources in seconds and simply ask in plain language - like "create a bar chart comparing Google Ads and Facebook Ads monthly revenue for this quarter" - to get a real-time dashboard built for you instantly.