How to Make a Chart from a Table in Google Sheets

Turning a table of raw numbers in Google Sheets into a clear, visually compelling chart is one of the best ways to uncover trends and communicate a story. Instead of making your audience squint at rows and columns, a well-designed chart can make your point in an instant. This guide will walk you through everything you need to know, from creating your first simple chart to customizing it like a pro.

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

Getting Started: Your Data Foundation

Before you even think about inserting a chart, the quality of your data table is paramount. A clean, organized table is the foundation for a useful chart. Good data hygiene in your spreadsheet will save you a lot of headaches later on.

Follow these best practices for structuring your data:

• Use Headers: Your first row should contain clear, concise headers for each column (e.g., "Month," "Website Traffic," "Conversions"). Charts use these headers to automatically create labels.
• Keep it Consistent: Ensure the data in each column is of the same type. Don't mix text, numbers, and dates within the same column. For instance, a column for revenue should only contain numbers formatted as currency.
• Avoid Empty Rows or Columns: Try not to have completely blank rows or columns in the middle of your dataset. This can confuse Google Sheets when it tries to automatically detect your data range.

Here’s an example of a well-structured table ready for charting:

Creating a Chart in 4 Simple Steps

With your data organized, creating the chart itself is surprisingly fast. Google Sheets does a great job of guessing what you want, but you always have full control to change it.

Step 1: Select Your Data

Click and drag your mouse to highlight the cells you want to include in your chart. Be sure to include the row with your column headers, as Google Sheets will use these for labels.

For our example table above, you would highlight the range A1:C5.

Step 2: Insert the Chart

With your data selected, navigate to the top menu and click Insert > Chart. Google Sheets will immediately analyze your data and create a default chart based on what it thinks is most appropriate. A "Chart editor" sidebar will also appear on the right side of your screen.

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 3: Review the Default Chart

Don't panic if the chart Google chooses isn’t exactly what you had in mind. In our example, it might default to a line chart showing Revenue and Ad Spend over time, which is actually a pretty good starting point. This initial version is just that - a starting point.

Step 4: Use the Chart Editor to Refine It

The Chart editor pane is where all the magic happens. It’s divided into two main tabs: "Setup" and "Customize."

• The Setup tab lets you change fundamental aspects of the chart, like the chart type, the data range, and which columns are used for the axes.
• The Customize tab lets you change the visual appearance, including colors, titles, labels, legends, gridlines, and more.

This panel is your command center for moving beyond a basic chart to something truly insightful.

Choosing the Right Chart for Your Data

Google Sheets provides dozens of chart types, and choosing the right one is crucial for clearly communicating your message. Here are some of the most common types and when to use them.

Column or Bar Charts

Best for: Comparing values across different categories.

Column charts (vertical bars) and bar charts (horizontal bars) are the workhorses of data visualization. If you have data showing things like sales per product, traffic by marketing channel, or revenue per region, a column chart is almost always an excellent choice. It makes it incredibly easy to see which category is highest or lowest at a glance.

Example: A column chart would be perfect for comparing the Q1 sales totals of four different salespeople.

Line Charts

Best for: Showing a trend over a continuous period of time.

Whenever your data includes a time element — days, weeks, months, quarters, or years — a line chart is your go-to. It connects data points to show the evolution of a metric, making it easy to spot upward trends, downward trends, and seasonality.

Example: A line chart is ideal for visualizing website traffic month-by-month over the last year to see growth patterns.

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

Pie Charts

Best for: Displaying the composition or proportions of a whole.

Pie charts get a bad rap, but they can be effective when used correctly. Use them only when you want to show parts of a single whole that add up to 100%. For clarity, it's best to limit a pie chart to 2-5 categories. Any more than that, and it becomes cluttered and hard to read.

Example: A pie chart works well to show the percentage breakdown of website traffic from different sources (e.g., Organic Search, Social Media, Direct, Referral).

Scatter Plots

Best for: Identifying the relationship or correlation between two different numerical variables.

A scatter plot helps you see if one variable has an effect on another. Each point on the graph represents one instance where you have a value for both variables. You can then look for a pattern to see if there's a positive, negative, or no correlation.

Example: A scatter plot could show if there's a relationship between a product's price (X-axis) and the number of units sold (Y-axis).

Customizing Your Chart for Maximum Impact

A default chart gets the job done, but a customized chart tells a story. Use the "Customize" tab in the Chart editor to refine the appearance and make your data easier to understand.

1. Chart & Axis Titles

Ditch the vague default titles. A good title should answer the question: "What am I looking at?"

• Bad Title: "Revenue"
• Good Title: "Monthly Revenue Growth for Q1 2024"

Clearly label your horizontal (X) and vertical (Y) axes so there is no ambiguity about what the values represent. Under Customize > Chart & axis titles, you can edit the main chart title, subtitle, horizontal axis title, and vertical axis title.

2. Series Formatting

This section allows you to change the colors of your bars, lines, or pie slices. You can use brand colors for a professional look or use a specific color to draw attention to a particularly important data point. You can also change the thickness of lines, add data labels directly onto the chart, or even add a trendline to a line or scatter chart to visualize the overall direction of the data.

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

3. Legend

The legend explains what each color or symbol on your chart represents. You can use the options under Customize > Legend to change its position (top, bottom, right, or none at all) and text formatting. For simple charts with only one data series, you can often remove the legend entirely to reduce clutter.

4. Horizontal & Vertical Axis

These sections give you deep control over your axes. You can:

• Set Min/Max Values: Force the axis to start or end at a specific number to provide better context. For example, you might want your vertical axis to start at zero to avoid exaggerating small changes.
• Change Number Format: If your numbers represent currency, percentages, or dates, you can apply that formatting directly here to make the chart more readable.
• Adjust Slanted Labels: If your horizontal axis labels are too long and overlap, you can angle them here to make them fit without looking crowded.

5. Gridlines and Ticks

Gridlines help guide the eye from an axis label to the corresponding data point, but too many can make a chart look busy. Under Customize > Gridlines and ticks, you can adjust the frequency of gridlines (the step) or remove them altogether for a cleaner, more minimalist design.

Final Thoughts

Transforming raw data into clear visuals in Google Sheets is a fundamental skill that helps you uncover trends and communicate your findings effectively. By starting with a clean data table, choosing the appropriate chart type, and using the robust customization options, you can create professional dashboards and reports right within your spreadsheet.

While Google Sheets is an incredible tool, the process still often starts with manually exporting CSVs and wrestling with data before you can even begin charting. That's why we built Graphed. It connects directly to your marketing and sales platforms — like Google Analytics, Shopify, and Facebook Ads — and automates the entire reporting process, giving you live dashboards that update in real-time. Instead of wrangling cells, you can just ask a question in plain English and get the chart you need in seconds, all with data you can trust.