How to Make a Vertical Bar Graph in Google Sheets

A vertical bar graph is one of the quickest ways to make sense of your data, turning rows of numbers into a visual story you can understand at a glance. Google Sheets has a powerful built-in chart editor that makes creating them simple. This guide will walk you through every step, from organizing your data to customizing your chart for a professional look.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly Is a Vertical Bar Graph?

You’ve seen them everywhere. A vertical bar graph, often called a column chart, uses rectangular bars of varying heights to represent different values. The height of each bar is proportional to the value it represents, making it incredibly easy to compare categories, track changes, or spot trends at a glance.

They are the workhorses of data visualization because they are so versatile and intuitive. You should use a vertical bar graph when you want to:

• Compare values across different categories. This is their primary superpower. Examples include comparing monthly sales figures, website traffic from different social media platforms, or survey responses for multiple questions.
• Show change over a small number of time periods. While line charts are often best for continuous time-series data, bar graphs are perfect for showing discrete periods like quarterly revenue or year-over-year growth.
• Highlight significant differences between data points. The visual difference in bar heights makes it immediately obvious which categories are outperforming or underperforming others.

When to use a different chart

While versatile, a vertical bar graph isn't always the perfect choice. If you have many categories (more than 10-12), the horizontal axis can become cluttered. In that case, a horizontal bar graph is often a better option. For showing a part-to-whole relationship for a single point in time (like market share), a pie chart is more effective.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First, Prepare Your Data

Before you create any chart, the single most important step is setting up your data correctly. A well-organized table is the foundation of a clear and accurate graph. Messy data leads to a messy (and often incorrect) chart.

For a vertical bar graph in Google Sheets, structure your data in simple columns:

• The Left Column: This should contain your labels, or the categories you want to compare. These labels will appear on the horizontal axis (the x-axis). Examples include months, product names, marketing channels, or sales regions.
• The Right Column(s): These columns should contain the numerical values you want to measure. These values determine the height of the bars and correspond to the vertical axis (the y-axis). Each column will represent a different data series on your chart.

Here’s a simple example of properly formatted data for tracking quarterly social media follower growth. Notice the clear headers at the top of each column - this is a best practice that makes the charting process much smoother.

Example Data: Quarterly Follower Growth

Keeping your data clean and simple like this tells Google Sheets exactly how to build the chart you need, saving you from headaches later.

Creating Your First Vertical Bar Graph: Step-by-Step

Once your data is organized, creating the chart takes less than a minute. Let’s use the Quarterly Follower Growth data from above to build our graph.

Step 1: Select Your Data

Click and drag your mouse to highlight the cells containing the data you want to visualize. Be sure to include the header row ("Quarter" and "Followers Gained"). Including headers allows Google Sheets to automatically label your chart's axes and series, which is a big time-saver.

Step 2: Insert the Chart

With your data selected, navigate to the menu at the top of the screen and click Insert > Chart. Google Sheets will automatically analyze your data and create what it thinks is the best chart type. Because our data is structured well, it will likely default to a vertical bar graph (column chart).

Step 3: Check the Chart Type

A Chart Editor pane will appear on the right side of your screen. If Google Sheets didn't choose a column chart, you can easily change it. In the Setup tab of the Chart Editor, click the dropdown menu under "Chart type" and select "Column chart." You’ll see your data immediately transform into a vertical bar graph.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Customizing Your Graph for a Professional Look

A default chart gets the point across, but a few customizations can make it far more effective and professional. The Chart Editor's Customize tab is where you can fine-tune every aspect of your graph's appearance.

Chart & Axis Titles

Your chart needs a clear title so anyone who sees it immediately understands what it represents. Vague titles like "Chart" or "Followers" are not helpful.

• In the Customize tab, click on "Chart & axis titles."
• Select "Chart title" from the dropdown and type in a descriptive title, like "Quarterly Follower Growth in 2024."
• You can also add titles to the horizontal and vertical axes. For our example, a "Vertical axis title" of "New Followers" adds useful context.

Series (The Bars Themselves)

This section lets you modify the appearance of the data bars.

• Under the Series heading, you can change the bar color to match your brand's colors or to put emphasis on a particular category.
• Tick the "Data labels" checkbox to display the exact numerical value on top of or inside each bar. This is incredibly useful for providing precise information without forcing the viewer to trace back to the vertical axis.

Legend

A legend is essential when you have multiple data series (e.g., comparing followers from Instagram vs. Twitter). For a simple one-series chart like ours, you don't really need a legend. You can change its position (top, bottom, right) or remove it entirely by selecting "None" under the "Position" dropdown.

Gridlines and Ticks

Gridlines are the faint lines running across the chart that help readers gauge the value of the bars. Under "Gridlines and ticks," you can adjust their appearance.

• You can add or remove major and minor gridlines for the vertical axis.
• A good practice is to keep the gridlines subtle (a light gray color is usually best) so they support the data without distracting from it.

Advanced Techniques: Grouped and Stacked Bar Graphs

Once you've mastered the basic bar graph, you can start creating more complex comparisons using just a few extra data columns.

How to Create a Grouped (Clustered) Bar Graph

A grouped bar graph is perfect for comparing a few different metrics within the same categories. For example, let's say you want to compare "Projected Sales" vs. "Actual Sales" for each quarter.

Start by setting up your data with a separate column for each data series:

Select all the data and go to Insert > Chart. Google Sheets is smart enough to see the multiple data columns and will likely create a grouped bar chart by default, placing bars for "Projected" and "Actual" side-by-side for each quarter. This provides a fantastic visual for instantly spotting which quarters exceeded expectations.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Create a Stacked Bar Graph

A stacked bar graph is used to show how a total is divided into different parts across several categories. Imagine you want to see not just total sales per quarter, but how much each of your product lines contributed to that total.

Your data would look like this:

After you select this data and insert a chart, go to the Chart Editor > Setup > Chart type and select "Stacked column chart." Now, each bar will represent the total sales for a quarter, with colored segments showing the contribution of each product line. This helps you analyze both the total performance and the changing revenue mix over time.

Final Thoughts

Mastering the vertical bar graph in Google Sheets is a fundamental data skill. By preparing your data thoughtfully and using the intuitive customization options, you can create clear, compelling visuals that effectively communicate your findings and tell a powerful story with data.

While Google Sheets is fantastic for manual chart creation, we know that building reports across different platforms like Google Analytics, Shopify, and your CRM can be a slow, repetitive process. We built Graphed to automate that tedious work. Instead of downloading CSVs and building charts by hand, you just connect your sources and describe the dashboard you need in plain English. Graphed builds it instantly with real-time data, so you can spend your time on strategy, not spreadsheets.