How to Make a Column Chart in Google Sheets

A column chart is one of the quickest ways to see how different items stack up against each other. It turns rows of spreadsheet data into a clear story you can understand in seconds. This guide will walk you through exactly how to create, customize, and master column charts in Google Sheets, step by step.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly is a Column Chart?

A column chart uses vertical bars (columns) to represent and compare values across different categories. Each column's height is proportional to the value it represents, making it incredibly easy to spot highs, lows, and trends at a glance. You might see it used for:

• Comparing monthly sales figures over a year.
• Showing website traffic from different sources like "Organic Search," "Social Media," and "Direct."
• Visualizing customer survey responses for different product features.

Think of it as a way to tell a story by comparing the "how much" for several different "whats." People often use "column chart" and "bar chart" interchangeably, but there's a small difference: column charts display data in vertical columns, while bar charts use horizontal bars. They show the same data, just with a different orientation.

Before You Begin: How to Structure Your Data

The success of your chart depends entirely on how you organize your data. Google Sheets is smart, but it needs your data to be in a logical format to create a useful visualization. For a column chart, a simple two-column format is perfect.

Column 1: The Category (Your X-axis labels). This column contains the labels for what you are comparing. These will appear along the horizontal axis at the bottom of your chart. Examples include months of the year, specific product names, or sales regions.

Column 2: The Value (Your Y-axis values). This column contains the numbers corresponding to each category. These numbers determine the height of each column on the vertical axis. Examples include revenue totals, user counts, or the number of units sold.

Here’s what your data should look like:

Example: Website Traffic by Source for Q3

With data set up neatly like this, you're ready to create your chart in just a few clicks.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Create a Column Chart in Google Sheets: A Step-by-Step Guide

Making your first column chart is a straightforward process. Just follow these steps.

Step 1: Select Your Data

Click and drag your mouse to highlight the cells that contain the data you want to visualize. Be sure to include both the category labels and the value data, including the headers. Using the example above, you would highlight cells A1 through B6.

Step 2: Insert the Chart

With your data selected, navigate to the main menu and click on Insert > Chart. A chart will instantly appear on your spreadsheet, along with the Chart editor sidebar on the right.

Step 3: Select the Column Chart Type

Google Sheets often makes an intelligent guess about the best chart type for your data. If it doesn't automatically create a column chart, it’s simple to fix. In the Chart editor sidebar, click the dropdown menu under "Chart type." Scroll through the options until you find "Column chart" and select it.

And that’s it! You now have a basic column chart ready to go. But the real power comes from customization.

How to Customize Your Column Chart for Maximum Impact

A default chart gets the point across, but a well-designed chart tells a compelling story. The Chart editor is your control center for customizing every aspect of your visualization. You'll find two main tabs here: Setup and Customize. Let's explore the key options under the "Customize" tab.

Chart & Axis Titles

A chart without a title is like a book without a cover. Under the "Chart & axis titles" section, you can:

• Title text: Give your chart a descriptive name, like "Q3 Website Traffic by Source."
• Horizontal axis title: Label your X-axis. For our example, "Traffic Source" is appropriate.
• Vertical axis title: Label your Y-axis to provide context for the numbers, such as "Number of Sessions."

Clear titles remove any ambiguity and help a viewer understand the chart's purpose immediately.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Series

The "Series" section controls the appearance of the columns themselves. You can:

• Change the fill color: Select colors that are easy to distinguish or align with your brand's style guide.
• Add data labels: This is a powerful feature that displays the exact numerical value on, inside, or above each column. It saves your audience from having to guess values based on the vertical axis line.
• Add a trendline: While more common for time-series data, a trendline can help visualize the overall pattern or direction of your values.

Legend

The legend helps distinguish between different data series, which is essential if you're comparing multiple sets of data on one chart (like "Target Sales" vs. "Actual Sales"). You can change its position to be on the top, bottom, right, left, or remove it entirely if you only have one data series.

Gridlines and Ticks

Gridlines are the faded horizontal lines running in the background of your chart. They help the eye travel from a column's peak over to the vertical axis to estimate its value. Under the "Gridlines and ticks" section, you can add or remove them for both the vertical and horizontal axes. You can also specify major gridlines (the main ones) and minor gridlines for more detailed charts.

Axis Formatting

Dig into the "Vertical axis" and "Horizontal axis" settings to adjust text fonts, colors, and slant labels if your category names are long. For the vertical axis, you can set minimum and maximum values for your scale or format the numbers as currency, percentages, or plain numbers.

Putting It Into Practice: Examples of Column Charts

Let's look at how you can apply these steps to common business scenarios.

Example 1: Visualizing Monthly Channel Revenue

Imagine you want to see which marketing channel generated the most revenue each month. Grouped column charts are perfect for this.

Your data would look like this:

When you select this data and insert a chart, Google Sheets will create a grouped column chart. For each month on the x-axis, you'll see two columns side-by-side - one for Email Marketing revenue and one for Social Ads revenue. You can use the legend to distinguish between the two.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Example 2: Tracking Progress Towards a Goal with a Stacked Chart

A stacked column chart is great for showing part-to-whole relationships. Let’s say your team has a quarterly sales target of $50,000, and you want to track progress made versus what's still left to achieve.

Set up your data like this:

Under "Chart type," choose "Stacked column chart." This will show a single column for each quarter. Each column will be split into two colored segments: how much you've achieved and how much is remaining. The total height of the column represents the $50,000 goal, providing an instant visual of how close you are.

Best Practices for Clear and Effective Column Charts

Creating a chart is half the battle, ensuring it's easy to read is the other half. Here are a few tips to keep in mind.

• Always Start the Vertical Axis at 0: Starting the vertical (Y) axis at a value other than zero can exaggerate differences between columns and mislead your audience. Always let your value axis begin at zero for an honest comparison.
• Use Sparing, Intentional Color: Colors should serve a purpose - either to differentiate categories or to highlight a key data point. Avoid using too many distracting colors that add visual noise rather than clarity.
• Keep It Simple: Avoid cluttering your chart with too many categories. If you have more than 10-12 categories to compare, a horizontal bar chart might be easier to read because the labels have more space.
• Order Your Data Logically: Arrange your columns in a way that makes sense. You can sort them from highest to lowest, lowest to highest, or chronologically to help guide the viewer's eye and make the main point obvious.

Final Thoughts

Creating a column chart in Google Sheets is a simple yet powerful skill for anyone looking to translate raw data into clear, understandable insights. By preparing your data correctly and using the customization options wisely, you can build professional reports that effectively communicate your findings and drive better decisions.

Once you've mastered building charts manually, you may find yourself looking for a faster way. We designed Graphed to help with exactly that. Instead of clicking through menus, you can connect your data sources like Google Sheets or Shopify, and simply tell it what you want to see - "show me a column chart of last month's sessions by traffic source." It builds live, interactive dashboards in seconds, letting you skip the setup and get straight to the insights.