How to Add a Column Chart in Google Sheets

Creating a column chart in Google Sheets is a fantastic way to compare different categories of data at a glance. Instead of deciphering rows of numbers, you can instantly see which products are top-sellers, which months had the highest traffic, or how different regions stack up. This guide will walk you through everything from structuring your data and building your first basic chart to customizing it like a pro.

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 to represent and compare data across different categories. Each bar's height is proportional to the value it represents, making it incredibly easy to see highs and lows. It's one of the most common and effective chart types for a reason.

You should use a column chart when you need to:

• Compare values across different categories. For example, comparing the monthly revenue from different product lines.
• Show changes over time. A classic use case is displaying total sales for each month of the year. This works best when you have a manageable number of time periods (e.g., 12 months, 7 days).
• Highlight individual values. The distinct columns make it easy to focus on the performance of a single category, like sales figures for a specific marketing campaign.

Column Chart vs. Bar Chart: What's the Difference?

Functionally, they are the same - they use bars to represent data. The only difference is the orientation. Column charts have vertical bars, while bar charts have horizontal bars. Generally, you should stick with a column chart for time-series data (like months or years) as it presents a natural left-to-right progression. If you have very long category names, a bar chart can be a better choice as it gives you more space for the labels.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Prepare Your Data for Charting

The secret to a great chart is well-organized data. Before you even think about clicking "Insert Chart," you need to set up your spreadsheet correctly. For a column chart, Google Sheets expects your data to be arranged in a simple, clean format.

Your data should be organized in columns, with:

• A header row that describes the data in each column.
• The first column containing your categories (e.g., Month, Product Name, Sales Rep).
• The subsequent columns containing the numerical values you want to plot (e.g., Sales, Units Sold, Website Visitors).

Here’s a perfect example of what your data should look like:

Common Data Formatting Mistakes to Avoid:

• Empty rows or columns: A blank row within your data range can confuse Google Sheets and break your chart. Make sure your data is in a single, contiguous block.
• Merged cells: Avoid merging cells within your data table. It can cause errors when selecting your data range.
• Inconsistent data types: Ensure your value columns contain only numbers. A stray text character ("N/A") or symbol can prevent the entire column from being plotted correctly.

Step 2: Create a Basic Column Chart

Once your data is cleaned up and organized, creating the chart itself takes only a few clicks.

1. Select your data range. Click and drag your mouse to highlight all the cells you want to include in your chart, including the headers. Using our example above, you would select cells A1 through B7.
2. Insert the chart. Go to the menu bar at the top of the screen and click Insert > Chart.
3. Verify your chart type. Google Sheets is pretty smart and will usually default to the right chart type based on your data. If it guesses correctly, a column chart will pop up instantly. If for some reason it suggests a pie chart or a line graph instead, don't worry. Find the Chart type dropdown in the Chart editor sidebar on the right and select "Column chart."

And that’s it! You now have a basic column chart embedded in your worksheet.

Step 3: Customize Your Column Chart for Clarity and Impact

A basic chart is good, but a well-customized chart is great. The default chart is often bland and may lack the necessary context for your audience. Using the Chart editor sidebar, you can modify almost every element to make your chart more professional and easier to read.

If you close the Chart editor, you can always reopen it by double-clicking on your chart. Let’s focus on the Customize tab within the editor.

Chart &amp, Axis Titles

Your chart needs a clear and descriptive title. "Sales vs. Month" isn't as helpful as "Total Sales Revenue by Month (First Half of the Year)." Be specific.

Under the Chart & axis titles section:

• Chart title: Edit the text to give your chart a descriptive heading.
• Horizontal axis title: Add a label for your horizontal (X-axis) to describe the categories (e.g., "Month").
• Vertical axis title: Add a label for your vertical (Y-axis) to describe the values being measured (e.g., "Revenue in USD").

Series

The "Series" refers to your data bars. Here, you can change their appearance to match your brand or emphasize certain information.

• Color: Change the fill color of your columns. If you have multiple data series (e.g., "2023 Sales" vs. "2024 Sales"), you can assign a unique color to each.
• Data labels: This is a powerful feature. Check this box to display the exact numerical value on top of or inside each column. This saves your audience from having to estimate the height of each bar against the axis lines.
• Trendline: For time-series data, you can add a trendline to visualize the general direction of your data over time - is it trending up, down, or flat?

Graphed

Still Building Reports Manually?

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

Watch the Demo

Legend

The legend explains what each color in your chart represents. If you only have one data series (one set of bars), you don't even need a legend. You can select 'None' for the Position to remove it and give your chart more space. If you have multiple series, you can change the legend's position (e.g., Top, Bottom, Right) to best fit your layout.

Gridlines and Ticks

Gridlines help guide the eye from the columns to the axis values. In the Gridlines and ticks section, you can:

• Change the spacing and color of the major gridlines.
• Add minor gridlines for more granular detail.
• Adjust the tick mark positions on the axes.

For a cleaner, more modern look, you might make your gridlines a very light gray or even remove them entirely if you’re using data labels.

Exploring Advanced Column Chart Formats

Beyond the standard version, Google Sheets offers several variations of the column chart that help you visualize more complex data relationships.

Stacked Column Chart

A stacked column chart is perfect for showing how different parts contribute to a whole for each category. For example, you can show total monthly sales, with each column broken down by product type.

To create one, organize your data with categories in the first column and each contributing part in its own column next to it. Select your data, click Insert > Chart, and choose "Stacked column chart" from the Chart type dropdown.

Graphed

Still Building Reports Manually?

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

Watch the Demo

100% Stacked Column Chart

This chart is similar to a stacked chart, but instead of showing absolute values, each column adds up to 100%. It's incredibly useful for showing the relative proportion or percentage that each part contributes to the whole across different categories. For example, you could use it to visualize the market share of different competitors over several years.

Combo Chart (Columns and Lines)

What if you want to compare two different types of metrics on the same chart, like monthly sales (in dollars) and the number of units sold (a count)? A combo chart lets you plot one data series as columns and another as a line on the same graph.

To create one, start with a standard column chart with two data series. Then:

1. Go to the Customize tab in the Chart editor.
2. Open the Series section.
3. In the dropdown at the top, select the data series you want to change to a line.
4. Change its Type from Columns to Line.
5. You can even assign it to a Right axis if the two series use very different scales (e.g., dollars ranging in the thousands and a unit count in the hundreds).

Final Thoughts

Mastering column charts in Google Sheets is a fundamental data visualization skill. By properly organizing your data and using the powerful customization options, you can transform simple spreadsheets into compelling, easy-to-understand reports that quickly communicate key insights.

Of course, building charts is often the easy part. The real work is having to constantly log into a dozen different platforms like Google Analytics, Shopify, and Facebook Ads, export CSVs, and wrangle all that data before you can even start. With Graphed, we automate that entire frustrating process. We seamlessly connect to sales and marketing data sources, allowing you to build real-time, shareable dashboards instantly using simple, natural language. Just ask, "show me a column chart of our top-selling products from Shopify last month," and it’s done.