How to Make a Bar Graph in Google Sheets with ChatGPT

Making a bar graph in Google Sheets is already pretty easy, but using ChatGPT as your co-pilot can speed up the process and help you visualize data you don't even have yet. From generating realistic sample data for mock-ups to helping you structure complex information, blending AI with spreadsheets is a smart way to create clear, effective charts. This tutorial guides you through using ChatGPT to generate and format data, then walks you step-by-step through creating and customizing a perfect bar graph 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

Why Bother Using ChatGPT for a Google Sheets Graph?

Before we jump into the "how," let's quickly touch on the "why." While it might seem like an extra step, pairing ChatGPT with Google Sheets unlocks a few powerful advantages. It's not just about a single chart, it’s about making your entire data visualization process faster and smarter.

• Instant Data Generation: Need to create a dashboard mockup for a client or practice your charting skills? Ask ChatGPT to generate a realistic dataset on any topic. This is far better than using generic "Data A, Data B" placeholders.
• Data Cleaning and Structuring: If you have messy, unstructured data, you can paste it into ChatGPT and ask it to format it into a clean table that’s ready for Google Sheets. This alone can save immense amounts of time.
• Get Expert Advice: Not sure which type of graph is best for your data? Describe what you're trying to show to ChatGPT. It can suggest whether a vertical column chart, a horizontal bar chart, a stacked bar chart, or something else entirely would be most effective.
• Troubleshoot on the Fly: When Google Sheets isn't cooperating - maybe it’s misreading your labels or ordering things incorrectly - you can describe the problem to ChatGPT and get specific, step-by-step instructions on how to fix it.

Generating Your Data with ChatGPT

Let's start by creating a dataset from scratch. The key to getting useful data from ChatGPT is to give it a specific role and clear instructions. Imagine you're a marketing manager for a small e-commerce brand and need to create a simple chart showing monthly sales.

Here’s a prompt you could use:

Act as a marketing analyst for a small e-commerce business. Please generate a simple table showing monthly sales revenue for 2023. The table should have two columns: "Month" and "Sales Revenue (USD)". Make the revenue figures realistic, showing some typical e-commerce trends like a holiday sales peak.

In a few seconds, ChatGPT will produce a neatly formatted table. It will look something like this:

Here is the sample monthly sales data for 2023:

The beauty of this is that the data makes sense. You can see the revenue ticking up toward the end of the year, peaking in November and December. Now, let’s get this data into 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

Formatting the Data in Google Sheets

This part is simple. Just highlight the entire table ChatGPT generated and copy it (Ctrl+C or Cmd+C). Then, open a new Google Sheet and paste it (Ctrl+V or Cmd+V) into cell A1. Google Sheets typically handles the formatting well, separating the text into the correct columns. If it pastes everything into one column, use the "Data > Split text to columns" feature and choose the "|" symbol as a separator.

Quick tips for best results:

• Make sure your headers in row 1 are simple and clear.
• Ensure the numbers in the "Sales Revenue (USD)" column are formatted as currency or numbers, not plain text. You can do this by selecting the column and going to Format > Number > Currency.

Your sheet is now prepped and ready for charting.

Step-by-Step Guide: Making Your Bar Graph in Google Sheets

With your data perfectly organized, creating the bar graph itself is a straightforward visual process. Google Sheets is quite intuitive here, but knowing your way around the Chart editor will allow you to make your graphs look professional and easy to read.

Step 1: Select Your Data

Click and drag your mouse to highlight the entire dataset, including the headers. In our example, you would select cells A1 through B13. Including headers tells Google Sheets what to label your axes and legend, which saves you a step later.

Step 2: Insert Chart

With your data selected, navigate to the main menu and click Insert > Chart. A chart will instantly appear on your spreadsheet, along with a "Chart editor" pane on the right-hand side.

Google Sheets is great at guessing what kind of chart you want. Based on our data, it will likely default to a vertical column chart (often colloquially called a bar chart), which is exactly what we're looking for to show changes over time.

Step 3: Choose the Right Chart Type

If Google Sheets didn’t select the correct chart type, a horizontal bar chart instead of a vertical one, you can easily fix this in the Chart editor.

Under the "Setup" tab, look for the "Chart type" dropdown menu. Here you'll find dozens of options. For our purpose, either a Column Chart (vertical bars) or a Bar Chart (horizontal bars) works well. Column charts are usually better for showing data over time (like our monthly sales), while horizontal bar charts are great for comparing discrete categories, especially when category names are long.

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 4: Customize Your Graph Like a Pro

A default chart gets the point across, but a well-customized chart tells a story. The "Customize" tab in the Chart editor is where the magic happens. Let's cover a few key options to elevate your graph.

Chart & Axis Titles

Giving your chart a clear, descriptive title is rule number one. Click on the "Chart & axis titles" section. For the "Title text," change it to something more descriptive than "Sales Revenue vs. Month." A better title would be "2023 Monthly Sales Revenue." You can also add titles for your horizontal (X-axis) and vertical (Y-axis) axes here, like "Month" and "Revenue in USD," respectively.

Series

This is where you control the look of the actual bars. You can change their color to match your company's branding, add data labels to show the exact value on top of each bar, or add a trendline to visualize the overall growth pattern throughout the year.

Legend

Our current chart is simple and doesn't really need a legend, as we only have one data series ("Sales Revenue"). But if you were comparing multiple data series (e.g., "Online Sales" vs. "In-Store Sales"), the legend would be critical. You can control its position (top, bottom, right, etc.) or remove it entirely if it's not needed.

Gridlines & Ticks

Charts can sometimes feel cluttered. Under "Gridlines and ticks," you can adjust or remove the faint horizontal lines running across your chart. Reducing the number of gridlines or making them a lighter color can make your data stand out more and give the chart a cleaner, more modern look.

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

Level Up: Grouped vs. Stacked Bar Charts

What if you need to display more complex data? Say you want to break down your total sales into "Online Sales" and "In-Store Sales." ChatGPT can help generate that data, and Google Sheets can visualize it with more advanced chart types.

First, go back to ChatGPT with a simple follow-up prompt:

That's great. Now, can you modify the previous table? Instead of one "Sales Revenue" column, create two columns: "Online Sales (USD)" and "In-Store Sales (USD)". Make sure the sum of these two columns for each month equals the original total sales revenue.

Copy and paste the new, three-column dataset into your Google Sheet. When you create a chart with this data selected, Google Sheets will automatically create a grouped bar chart (also called a side-by-side bar chart). This is perfect for directly comparing the performance of each channel month-to-month.

If you want to focus on the total monthly revenue while still showing the contribution of each channel, a stacked bar chart is an excellent choice. In the Chart editor, under "Setup," simply select the "Stacked column chart" option. This will stack the online and in-store sales on top of each other, giving you a clear visual of both the parts and the whole for each month.

Final Thoughts

Marrying the convenience of a tool like ChatGPT with the straightforward charting capabilities of Google Sheets creates a fast and effective workflow. You can now generate ideas, create sample data, and build professional-looking charts in a fraction of the time, whether you're building a report, a presentation deck, or a personal dashboard.

As helpful as this method is, it still requires manual steps like copying data and re-creating charts every time you need an update. At Graphed, we automate this entire process. You connect your live data sources like Google Analytics, Shopify, or your CRM just once, and then use simple, conversational language to have entire dashboards built for you in seconds. Your metrics stay auto-refreshed, so you're always looking at real-time performance without ever getting stuck in spreadsheet-land again.