How to Create a Versus Graph in Google Sheets

Need to compare two sets of data in a single chart? A 'versus' graph is the perfect way to visualize performance side-by-side, such as actual results against your targets or this year's sales versus last year's. Google Sheets makes it surprisingly easy to create these clear, compelling visuals. This tutorial will walk you through preparing your data, creating your chart step-by-step, and customizing it to look professional and easy to understand.

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 "Versus" Graph, and Why is it So Useful?

At its core, a "versus" graph is just a chart that places two or more data series in direct comparison, allowing you to quickly spot differences, trends, and relationships. Instead of looking at raw numbers in a table and trying to mentally calculate the differences, a visual graph shows you the story in your data instantly.

They are incredibly versatile and can be used to answer common business questions like:

• Performance vs. Goals: Are we hitting our monthly sales targets? How does our actual ad spend compare to our budget?
• Period-over-Period Comparison: How does website traffic this month compare to the same month last year? Is our revenue growing quarter-over-quarter?
• Competitive Analysis: How does our product's user growth stack up against a key competitor's?
• Campaign Performance: Which of two different ad campaigns generated more leads? How does Campaign A's ROAS (Return on Ad Spend) compare to Campaign B's?

The main benefit is clarity. A well-made comparison chart eliminates guesswork and helps you and your team make more informed decisions based on what the data is actually showing.

Step 1: Get Your Data Ready

Before you create any chart, the most important step is setting up your data correctly. A clear, organized data table is the foundation for a clear, organized chart. For a standard "versus" graph, an ideal structure includes three columns:

1. The Label/Category (X-axis): This is what you're measuring against. It is usually a time period (e.g., Day, Month, Quarter) or a category (e.g., Product Name, Sales Rep, Marketing Channel).
2. Data Series 1 (Y-axis): Your first set of numerical values.
3. Data Series 2 (Y-axis): Your second set of numerical values you want to compare against the first.

Let’s say we want to compare website sessions from 2023 with sessions from 2024 on a monthly basis. Here's how you’d structure that data in Google Sheets:

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

Tips for Preparing Your Data:

• Keep Headers Simple and Clear: Use descriptive headers like "Month," "2023 Sales," or "Actual Spend." These will automatically become the labels in your chart's legend.
• Ensure Consistency: Make sure your labels in the first column match exactly if they appear multiple times. For example, use "Jan" every time, not "Jan" and "January."
• Use Only Numerical Data: Your data series columns should contain only numbers. Avoid adding currency symbols or commas directly into the cells (you can format them later).

Step 2: Create Your Versus Graph: The Column Chart Method

The classic column chart is the most common and often most effective way to create a versus graph. Each category will have two bars side-by-side, making for an easy visual comparison. Here's how to do it:

1. Select Your Data: Click and drag your mouse to highlight the entire data set you prepared, including the column headers.
2. Insert the Chart: Go to the menu at the top of the screen and click Insert > Chart.
3. Review the Chart Editor: Google Sheets will automatically insert a chart and open the Chart editor pane on the right side of your screen. Google is quite smart and will often correctly guess that you want a Column chart for this type of data. If it suggests a different chart type, you can easily change it.
4. Choose the Right Chart Type: In the Setup tab of the Chart editor, click the dropdown menu under "Chart type" and select "Column chart." Your data will now be displayed as a series of side-by-side vertical bars for each month.

That’s it! In four steps, you have a functional versus graph comparing your two data series.

Exploring Other "Versus" Graph Formats

While a column chart is a great default, Google Sheets offers other chart types that might tell your story more effectively depending on your data.

When to Use a Bar Chart

A bar chart is essentially a column chart turned on its side. It's the better choice when you have long category labels (e.g., "Organic Search Traffic Acquisition" instead of just "Jan"), as the horizontal layout prevents the labels from overlapping or displaying awkwardly at an angle.

To switch, simply go to the "Chart type" dropdown in the Chart editor and select "Bar chart."

When to Use a Line Chart

A line chart is the best option for visualizing trends over a continuous period of time, such as daily sales over a month or stock prices over a year. It excels at showing the direction and velocity of change.

In the "Chart type" dropdown, select "Line chart." You will now see two distinct lines, one for each data series, making it easy to spot where one overtook the other, or if they are trending in the same direction.

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

Advanced Option: The Combo Chart

What if you want to compare two metrics that use completely different scales? For instance, comparing Ad Spend (in hundreds of dollars) to Website Clicks (in thousands). If you plotted them on the same axis, the "Ad Spend" bars would be tiny and practically invisible.

The solution is a Combination Chart (or Combo Chart), which allows you to use two different Y-axes.

How to Create a Combo Chart:

1. Start by creating a standard Column chart as detailed above.
2. In the Chart editor, navigate to the Customize tab.
3. Click on the Series dropdown.
4. By default, the settings for "All series" will be shown. Choose the specific series you want to move to a different axis (e.g., "2024 Revenue").
5. Under the format options for that series, look for the "Axis" dropdown. Change it from "Left axis" to "Right axis."
6. You’ll immediately see a new axis appear on the right side of your chart scaled to that data series. For even better clarity, you can also change the chart type for just that series. A common practice is to represent one series as columns and the other as a line to help distinguish between them.

This powerful technique allows for rich comparisons between two otherwise incompatible datasets in a single, easy-to-read chart.

Step 3: Customize Your Graph for Maximum Impact

A default chart gets the job done, but a few simple customizations can transform it from a basic visual into a professional, high-impact report.

All customization options are located in the Customize tab of the Chart editor.

Chart & Axis Titles

Give your chart context. Don't leave it with a generic title. Select "Chart & axis titles" to:

• Chart title: Change "2023 Sessions vs 2024 Sessions" to something more descriptive, like "Monthly Website Session Growth: 2023 vs. 2024."
• Horizontal axis title: Add a label like "Month" to the X-axis.
• Vertical axis title: Add a label like "Number of Sessions" to the Y-axis.

Colors and Legend

Colors guide the eye. Under the "Series" section, you can change the color of each data series. Use colors that provide good contrast, or match them to your company's branding.

The legend is what tells the viewer what each color represents. Under the "Legend" section, you can change its position (e.g., Top, Bottom, Labeled) to whatever best fits your chart layout.

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

Data Labels

Sometimes you want to see the exact numbers without having to hover over each bar or point. Go to "Series," choose the series you want to label, and check the box for "Data labels." Numbers will appear directly on your chart, adding a layer of precision.

Gridlines and Ticks

Under "Gridlines and ticks," you can adjust the lines running across your chart's background. Sometimes, reducing the number of vertical gridlines or changing their color to a light gray can help reduce visual "noise" and make the data bars or lines stand out more.

Final Thoughts

Building a 'versus' graph in Google Sheets is a simple yet incredibly effective way to see the story hidden in your data. By structuring your information cleanly and utilizing the Chart Editor to customize your visual, you can move beyond boring tables and create compelling reports that clearly highlight progress, performance, and key trends.

At the same time, we know that spending hours pulling data from different places - like Google Analytics for web traffic and your CRM for sales targets - just to stitch it together in a spreadsheet can be a major drain on your time. Instead of building these reports manually, what if you could just describe the chart you want and have it created for you instantly, with live data? With Graphed , you can connect all your sources (like Google Analytics, Salesforce, HubSpot, and Ads platforms) and use natural language to build real-time dashboards in seconds, allowing you to focus on the insights, not the setup.