How to Make a Column Chart

Column charts are one of the most effective ways to compare values across different categories. With just a quick glance, you can see which products are selling best, which regions are performing highest, or how website traffic has trended from month to month. This guide will walk you through exactly when to use a column chart, how to prepare your data, and how to create one step-by-step in common tools like Google Sheets and Excel.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What Exactly Is a Column Chart?

A column chart uses vertical bars to represent data. The height of each bar is proportional to the value it represents, making it incredibly easy to compare data points visually. Think of it as a simple, powerful tool for telling a story with your numbers.

Every standard column chart has a few key components:

• The Y-Axis (Vertical Axis): This axis represents the numerical scale used to measure your data values, like sales figures, visitor counts, or temperatures.
• The X-Axis (Horizontal Axis): This axis displays the categories you are comparing, such as product names, months of the year, or marketing channels.
• Columns (Bars): These are the vertical rectangles that represent the value for each category. The taller the column, the higher the value.
• Chart Title: A descriptive title that tells the viewer what the chart is showing (e.g., "Monthly Sales Revenue - Q3 2023").
• Legend: If you're comparing multiple data series (like sales data for two different years on the same chart), a legend explains what color corresponds to which series.

When to Use a Column Chart

Column charts are your go-to visualization for direct comparisons. They shine when you need to:

• Compare values across discrete categories. This is their primary function. For example, comparing the number of tickets sold for three different events.
• Show rankings. You can easily see which category has the highest or lowest value. Ordering your columns from largest to smallest makes this even more impactful.
• Illustrate changes over a manageable number of time periods. While a line chart is often better for continuous time-series data, a column chart works well for comparing distinct periods like months, quarters, or years.

The key is that you are comparing distinct, individual items. If your category labels are long, you might want to consider a bar chart, which is essentially a column chart turned on its side. The horizontal format of a bar chart gives more space for lengthy text.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Prepare Your Data for a Column Chart

Before you can make a great chart, you need well-organized data. A clean dataset prevents errors and makes the creation process smooth. The ideal format is a simple table with two columns.

Imagine you want to visualize your website's traffic sources for the last month. Your data should look something like this:

Here’s what makes this data structure work:

• Column 1 (Categories): Your non-numerical labels representing what you are measuring (e.g., "Traffic Source"). These will appear on the x-axis.
• Column 2 (Values): The corresponding numbers for each category (e.g., "Sessions"). These values will determine the height of each column on the y-axis.
• Clear Headers: Each column has a clear header (“Traffic Source,” “Sessions”). This makes it easy for the software to automatically label your axes.

Pro tip: Keep your category names relatively short and to the point. Long names can get cluttered on the x-axis, forcing them to display diagonally or cut off entirely.

How to Make a Column Chart in Google Sheets (Step-by-Step)

Google Sheets makes creating a column chart simple and intuitive. Once your data is organized, it only takes a few clicks.

Step 1: Get Your Data into the Sheet

Enter your categories in the first column and your numerical values in the second column. Be sure to include headers for both.

Step 2: Select Your Data

Click and drag your cursor to highlight all the cells containing your data, including the headers. Correctly selecting your data helps Google Sheets build the chart automatically.

Step 3: Insert the Chart

With your data selected, navigate to the top menu and click Insert > Chart. Google Sheets will instantly analyze your data and suggest a chart type. Most of the time, it will correctly default to a column chart.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 4: Customize Your Chart with the Chart Editor

A "Chart editor" sidebar will appear on the right side of your screen. This is where you can refine your visualization. It has two main tabs:

• Setup: Here, you can change the chart type if Google Sheets picked the wrong one. You can also confirm the data range and which columns it’s using for the x-axis and y-axis.
• Customize: This is where you bring your chart to life. You can edit the chart title, add axis titles, change the colors of your columns, adjust gridlines, and modify the legend.

A good starting point is to give your chart a clear title and label the horizontal and vertical axes under the "Chart & axis titles" section.

How to Make a Column Chart in Excel (Step-by-Step)

The process in Microsoft Excel is just as straightforward. Let's walk through it.

Step 1: Enter Your Data

Just like in Google Sheets, start by entering your categories into one column and their corresponding values into the column next to it. Don't forget the headers.

Step 2: Highlight the Data

Select the range of cells you want to include in your chart. Clicking any single cell within your data range usually works too, as Excel is smart enough to detect the entire table.

Step 3: Go to the Insert Tab

Click on the Insert tab in the main Excel ribbon at the top of the window. In the "Charts" section, you'll see a small icon of a column chart.

Step 4: Choose Your Column Chart Type

Click the Insert Column or Bar Chart icon. A dropdown menu will appear showing several options like 2-D Column, 3-D Column, 2-D Bar, etc. For most situations, a "2-D Clustered Column" is the best choice - it’s clean, simple, and easy to read.

Step 5: Customize and Format Your Chart

Once you select a chart type, your column chart will appear in the spreadsheet. Now, you can customize it.

• Chart Elements: Click on your chart, and you'll see a green "+" icon appear on the right side. Clicking this allows you to add or remove elements like Axis Titles, Data Labels, a Legend, and Gridlines.
• Chart Styles and Colors: A paintbrush icon also appears. This lets you quickly change the visual style and color palette of your chart.
• Top Ribbon: You can also use the contextual Chart Design and Format tabs that appear in the top ribbon when your chart is selected for more advanced customization.

Spend a minute adding a title and axis labels to make sure anyone looking at your chart knows exactly what they're seeing.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Different Types of Column Charts and Their Uses

Once you've mastered the basic column chart, you can start using different variations to tell more complex stories with your data.

1. Clustered Column Chart: This is the standard column chart you just learned to make. You use it to compare the main values of different categories. You can also compare a few sub-categories by putting them side-by-side (clustered). For example, you might have a cluster of columns for each U.S. region, with each column in the cluster representing a different product's sales.
2. Stacked Column Chart: Instead of clustering columns side-by-side, a stacked column chart places them on top of each other. This shows you the total for each main category while also displaying the contribution of individual sub-categories. You'd use this to see total sales per region and how much each product contributed to those regional sales.
3. 100% Stacked Column Chart: This chart is similar to a stacked column chart, but it shows percentages rather than absolute values. Each column adds up to 100%. This is useful when you care more about the relative proportion in each category than the total. You might use it to answer: “What percentage of our total Northeast sales come from telephones vs. televisions?”

Column Chart Creation – Best Practices

Creating a beautiful and effective column chart isn’t just about putting numbers into rectangular form, it’s about communicating insights clearly. Here are some best practices to keep your charts readable and honest:

• Always Start the Y-Axis at Zero: Starting the y-axis at a number greater than zero can exaggerate the differences between columns and distort the data. Always keep your starting point at zero to provide an accurate representation of your numbers.
• Use Clear and Concise Labels and Titles: Don't make people guess. Use an informative title, like “Q4 Widget Sales by City” instead of just "Sales." Be sure each axis is clearly labeled so viewers aren't confused by what they're looking at.
• Sort Your Data Logically: It’s often helpful to organize your columns either alphabetically for easy reference, numerically (from highest to lowest), or chronologically. Sorting by values makes it instantly obvious which categories are the top performers or the lowest performers.
• Keep the Design Simple and Clean: Avoid excessive 3D effects, loud colors, unnecessary background images, and anything that can distract viewers from the story told by your data. A clean, minimalist design is almost always the most effective.

Final Thoughts

Column charts are a fundamental tool for data analysis and reporting. By learning how to organize your data and create these charts in common programs like Google Sheets and Excel, you are empowering yourself to translate raw numbers into compelling visual insights.

Creating manual charts in your spreadsheet is a great starting point, but when you need to pull data from different sources (like Shopify, Google Analytics, and Salesforce), the tedious routine can become time-consuming. So, we have built Graphed . It connects seamlessly to all your marketing data sources, allowing you to create real-time reports like column charts, just by using simple English prompts. The idea is to help users like you save time previously occupied by CSVs and complex formulas, and to help you on your way with accurate insights instead.