How to Make a Column Chart in Excel

A column chart is one of the most effective ways to visually compare different categories in your data. It turns rows of numbers into a simple, easy-to-understand visual story. This guide will walk you through creating, customizing, and mastering column charts in Excel, from the first click to advanced formatting tricks.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Is a Column Chart, and When Should You Use One?

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 see which categories are bigger or smaller at a glance. Think of it as the go-to chart for showing comparisons.

It’s often confused with a bar chart, which uses horizontal bars. The primary difference is orientation. Here’s a simple rule of thumb:

• Use a column chart when comparing values across a handful of categories (e.g., monthly sales, quarterly revenue) or tracking changes over time. They work best when your category labels are short and distinct.
• Use a bar chart when you have long category labels that would be difficult to read if placed vertically along the bottom axis.

You should use a column chart when you need to:

• Compare values across different groups (e.g., sales figures for different products).
• Show how something has changed over a set period (e.g., monthly website traffic from January to June).
• Display results from a survey (e.g., number of votes for each option).

Preparing Your Data for an Excel Column Chart

Before you create any chart, the most important step is setting up your data correctly. A well-organized table ensures Excel understands exactly what you want to visualize. Your chart is only as good as the data you give it.

Follow these simple rules for your data layout:

• Use Columns: Place your categories or time periods (like months or quarters) in the first column.
• Keep Values Separate: Place the corresponding numeric values in the next column.
• Include Headers: Always have clear, concise headers at the top of each column. Excel will use these to automatically label your chart's axes and legend.
• Avoid Blank Rows/Columns: Ensure there are no empty rows or columns within your data range, as this can confuse Excel when you select the data.

Here’s an example of a perfectly structured dataset for a column chart showing Q1 widget sales:

Month      | Units Sold  
-----------|-----------  
January    |    450  
February   |    620  
March      |    510

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Create a Basic Column Chart (Step-by-Step)

Once your data is ready, creating the chart takes less than a minute. Let's use the widget sales data from above.

Step 1: Select Your Data

Click and drag your mouse to highlight the entire data range, including the column headers. In our example, you would select the cells containing "Month," "Units Sold," and all the corresponding data points.

Step 2: Go to the Insert Tab

With your data highlighted, navigate to the Insert tab on Excel's main ribbon. You'll see a group of commands labeled "Charts."

Step 3: Choose the Column Chart Type

In the "Charts" group, click on the icon that looks like a small column chart. A dropdown menu will appear with several options. For now, under the "2-D Column" heading, click on the first option: Clustered Column. This is the most common and easily understood type of column chart.

Excel will instantly generate the column chart and place it onto your worksheet. That's it! You've made a basic column chart.

You’ll also see other options like Stacked Columns and 100% Stacked Columns. Here’s when to use them:

• Clustered Column: The default and best option for directly comparing values across categories. Each data series gets its own column.
• Stacked Column: Use this to show how individual parts contribute to a total. Each bar is a total, with segments showing the composition of that total. For example, you could show total sales per month, with each column stacked by product category.
• 100% Stacked Column: This is similar to a stacked column but focuses on showing the percentage contribution of each part to the whole. Every bar is the same height (100%), allowing you to easily compare proportions across categories.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Customizing Your Column Chart to Make it Professional

The default chart Excel creates is good, but a few customizations can make it great. A well-formatted chart is clearer, more professional, and tells a much stronger story.

When you click on your chart, you'll see a few icons appear on its right side. The plus sign (+) is "Chart Elements." Clicking it lets you easily add, remove, or modify key parts of your chart.

Adding and Modifying Chart Elements

• Chart Title: Your chart should always have a title. Instead of the generic "Chart Title," give it a descriptive name like "Q1 2024 Widget Sales Performance." Just click on the title text to edit it.
• Axis Titles: This is crucial for clarity. Add axis titles to tell viewers exactly what the vertical (Y-axis) and horizontal (X-axis) axes represent. For our example, the Y-axis would be "Units Sold" and the X-axis would be "Month."
• Data Labels: Check this box to add the exact numeric value above each column. This saves our audience from having to guess heights and provides precise insight directly on the chart. You can click the arrow next to "Data Labels" to change their position (e.g., inside or outside the column).
• Legend: A legend is necessary when you have multiple data series (e.g., comparing "Units Sold" vs. "Units Returned" for each month). For a simple chart with only one data series, like our example, the legend is often redundant and can be removed to clean up the chart.
• Gridlines: Horizontal lines that stretch across the plot area, helping the eye gauge the height of the columns. Sometimes removing them can create a cleaner, less cluttered look, especially if you're using data labels.

Advanced Formatting and Design Tips

Once the core elements are in place, you can refine the design to improve readability and visual appeal.

Changing Column Colors

The default blue is fine, but you might want to match your company's branding or highlight a specific data point.

• To change all columns: Simply right-click on any of the columns, select Format Data Series from the menu, and go to the "Fill & Line" options (the paint bucket icon). From there, you can choose a new fill color.
• To change a single column: First, click once on any column to select all columns in the series. Then, click a second time on just the column you want to change. Now, only that single column is selected. Right-click and change its fill color to make it stand out - perfect for highlighting your best-performing month!

Creating a Combination (Combo) Chart

What if you want to show two different types of data on one chart, like sales (in dollars) and conversion rate (in percentages)? With vastly different scales, plotting them both as columns would make the smaller value nearly invisible. This is the perfect use case for a combo chart.

How to make a combo chart:

1. Set up your data with three columns (e.g., Month, Sales, Conversion Rate).
2. Create a standard clustered column chart with all three columns selected. It will initially look odd.
3. Right-click on one of the data series you want to change (e.g., the smaller Conversion Rate columns) and select Change Series Chart Type.
4. A dialog box will open. Find the "Conversion Rate" series and in its dropdown menu, change the chart type to Line.
5. Most importantly, check the box for Secondary Axis next to it.

Excel will create a second vertical axis on the right side of your chart for the line graph, allowing you to clearly visualize two different data types in a single, coherent chart.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Common Mistakes to Avoid When Making Column Charts

Keep these tips in mind to ensure your charts are always clear and accurate:

• Using Too Many Categories: A column chart becomes cluttered and hard to read with more than 10-12 categories. If you have more, consider switching to a horizontal bar chart.
• Lack of Proper Labeling: A chart without a title and axis labels is just a picture. Always give your audience the context they need to understand the data.
• Misleading Y-Axis: By default, an Excel column chart's Y-axis starts at zero. Truncating the axis (starting it at a higher value) can exaggerate differences between columns and mislead your audience. Always start your columns from a zero baseline unless you have a specific, deliberate reason not to.
• Abusing 3-D Effects: While tempting, 3-D charts often make it harder to accurately compare the heights of the columns due to perspective distortion. Stick with 2-D charts for better clarity and honesty.

Final Thoughts

Creating a column chart in Excel is a straightforward process of arranging your data, inserting a chart, and customizing its components for maximum clarity. They are an essential tool for visualizing comparisons and are fundamental to good data reporting. Practice these steps, and you'll be able to turn any dataset into a compelling visual story.

While Excel is powerful, repeatedly pulling data, cleaning it up, and manually building these reports can take hours out of your week. At Graphed, we automate this process entirely. You can connect your data sources (like Google Analytics, Shopify, or Salesforce) and use plain English to ask for the report you need, like, “Show me a column chart comparing revenue by product for last quarter." We instantly build a live, interactive dashboard for you, saving you valuable time to focus on analysis instead of manual creation.