How to Make a Comparison Chart in Google Sheets with ChatGPT

Building a chart in Google Sheets is a great way to see how different things stack up against each other, but getting your data organized and choosing the right options can be a drag. This tutorial shows you how to quickly create a clear comparison chart by using ChatGPT as a data-generating assistant and then walking through the steps in Google Sheets.

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 Exactly Is a Comparison Chart?

A comparison chart does just what its name suggests: it helps you visually compare values across different categories. Instead of scanning rows of numbers, you can see at a glance which category is performing best, which is costing the most, or where trends are emerging. This is incredibly useful for spotting patterns and making informed decisions faster.

For comparing distinct categories, the most common chart types are:

• Column or Bar Charts: These are the workhorses of comparison. They use the length of bars (vertical for column, horizontal for bar) to represent a value, making it instantly obvious which category is bigger or smaller.
• Grouped Column/Bar Charts: A step up, these charts group multiple bars for each category. This allows you to compare multiple metrics for the same item. For example, you could compare both sales and profit for each product line in the same chart.
• Line Charts: While often used for showing trends over time, a line chart can also be effective for comparing multiple categories across the same continuous scale (like months in a quarter).

Step 1: Get Your Data Ready in Google Sheets

Before you can make a chart, you need clean, well-structured data. Visualizations are only as good as the numbers behind them. For a comparison chart, this usually means organizing your information in columns and rows where:

• Your first column contains the categories you want to compare (e.g., Product Names, Marketing Channels, Sales Reps).
• Subsequent columns contain the numerical data (the metrics) for each of those categories (e.g., Units Sold, Website Clicks, Deals Closed).

Here’s what a simple data structure for comparing social media channel performance might look like:

Having a clear table like this is the essential foundation for building a useful chart.

Step 2: Use ChatGPT to Brainstorm and Generate Data Fast

Sometimes the hardest part is getting the data in the first place, especially if you're just trying to create a quick mock-up or don't have historical data readily available. This is where ChatGPT can save you a ton of time.

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

Brainstorming with ChatGPT

Don't know where to start? Ask ChatGPT to act as a marketing analyst and give you ideas. This helps you figure out what to compare before you even think about numbers.

Example Prompt:

"I need to create a chart comparing the effectiveness of different digital marketing channels for an e-commerce store in Q1. What are the key metrics I should use for the comparison?"

ChatGPT might give you a list like: Total Spend, ROI (Return on Investment), Website Sessions, Conversion Rate, and CPL (Cost per Lead). This gives you a perfect set of column headers for your Google Sheet.

Generating Sample Data with ChatGPT

Once you know what metrics you want, you can ask ChatGPT to fill a table with believable sample data. The key is to be very specific in your prompt and ask for a format you can easily copy and paste.

Example Prompt for Generating Data:

"Generate a table of sample performance data for 5 digital marketing channels: Facebook Ads, Google Ads, SEO, TikTok Ads, and Email Marketing.

Include these columns:

• Channel Name
• Total Spend ($)
• Website Sessions
• Leads Generated

Make the Total Spend between $1,000 and $5,000. Create 5 rows of data and format the output so I can easily copy it into Google Sheets."

ChatGPT will produce a clean table. Just highlight the text it provides, copy it (Cmd+C or Ctrl+C), and paste it directly into your Google Sheet (Cmd+V or Ctrl+V). It usually pastes cleanly, but if the formatting looks weird, try pasting with Paste special > Values only.

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

Step 3: Build the Comparison Chart in Google Sheets

Now that you have your data neatly organized, creating the chart is just a few clicks away. We’ll build a grouped column chart to compare both Website Sessions and Leads Generated for each channel.

1. Select Your Data

Click and drag your cursor to highlight all the cells containing your data, including the column headers. In our example, you would select the cells from A1 to D6.

2. Insert the Chart

With your data selected, navigate to the menu and click Insert > Chart. Google Sheets will probably analyze your data and automatically create a chart for you. It might not be the one you want, but that’s okay - we’ll fix it next.

3. Use the Chart Editor to Customize

The Chart editor sidebar will appear on the right side of your screen. This is where you control everything about your chart's appearance and the data it displays. It has two main tabs: Setup and Customize.

A. The Setup Tab

This tab controls the fundamental structure of your chart.

• Chart type: Google Sheets might guess wrong. For our example, a "Column chart" or "Stacked column chart" is a good option for comparison. Let's stick with a standard Column Chart.
• X-axis: This is what you're comparing. Sheets correctly identified our "Channel Name" column for this.
• Series: These are the numerical values being measured. Here, you’ll see "Total Spend," "Website Sessions," and "Leads Generated." Since comparing Spend (thousands of dollars) with Sessions and Leads (hundreds) on the same axis is tricky, let’s remove "Total Spend" for now by clicking the three dots next to its name and selecting Remove. Now our chart will only compare Sessions and Leads, which is much easier to read.

B. The Customize Tab

This tab is where you adjust the look and feel to make your chart more professional and easier to understand.

• Chart & axis titles: Always title your chart! Double-click the chart title to edit it, or use this section to give it a descriptive name like "Marketing Channel Performance - Q1." You can also manage titles for the horizontal (X) and vertical (Y) axes.
• Series: Here, you can change the colors of your bars. Instead of the default blue and red, you can choose colors that fit your branding or just offer better contrast. If you have several series, making each a distinct color is essential.
• Legend: The legend explains what each color represents (e.g., Blue = Website Sessions). Use this section to change its position to the top, bottom, or side to see what looks best.
• Gridlines and Ticks: Under the vertical axis dropdown, you can add minor gridlines. This can make it easier for a viewer to estimate the exact value of each bar without having to guess.

After a few tweaks in the Customize tab, your finished chart should look something like this - clear, easy to read, and professionally titled.

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

Step 4: Use ChatGPT for Formulas and Formatting

What if you want to analyze your data a bit further? ChatGPT can also act as a formula wizard, saving you from having to look up Google Sheets functions.

Let's say you want to calculate the Cost Per Lead (CPL) for each channel. This wasn't in our original data, but we can easily add it.

Example Prompt for a Formula:

"In my Google Sheet, 'Total Spend' is in column B and 'Leads Generated' is in column D. What is the formula to calculate Cost Per Lead in column E? I will put the formula in cell E2."

ChatGPT will reply with the formula:

=B2/D2

Simply type that formula into cell E2 in your Google Sheet, hit Enter, and then drag the small blue square in the corner of the cell down to apply the formula to the rest of the rows. Now you have a new metric to add to your chart or analyze separately.

Final Thoughts

Creating a good comparison chart is about having clean data and choosing the right visual settings to tell a clear story. By structuring your information in a simple table, you make it easy for Google Sheets to do the heavy lifting, and with an assistant like ChatGPT, even tasks like generating data or writing formulas become quick and painless.

Ultimately, a process like this is still a multi-step, manual effort—especially if you're doing it week after week. If you're constantly pulling data from platforms like Google Analytics, Shopify, or various ad managers, we built Graphed to remove this work completely. Instead of juggling CSV files and Google Sheets, you just connect your data sources once, then ask for the dashboard you need in plain English. Graphed builds it in seconds with live, always-updated information, letting you get straight to the insights without the setup.