How to Create a 2D Column Chart in Excel

Creating a 2D column chart is one of the most fundamental skills you can learn in Excel. It’s a clean and effective way to turn rows of numbers into a visual story that others can understand instantly. This guide will walk you through exactly how to build one from scratch, customize it to look professional, and know when it's the right choice for your data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a 2D Column Chart and When Should You Use One?

A 2D column chart uses vertical bars (or columns) to represent different categories of data, making it incredibly easy to compare values to one another. The height of each column corresponds to its value, so a taller column means a larger number. This format is great because it’s immediately intuitive - our brains are hardwired to quickly compare lengths and heights.

You should consider using a 2D column chart when you need to:

• Compare values across different categories. This is the primary job of a column chart. For example, comparing sales figures for different products, website traffic from various marketing channels (e.g., Organic Search, Social Media, Direct), or survey responses across different age groups.
• Show changes over time. If you have a small number of time periods (like months in a quarter or days in a week), a column chart can be a great way to show performance trends. For longer time series, a line chart is often a better choice.
• Visualize data with a few distinct data points. Column charts work best when you have a manageable number of categories. If you have more than 10-12 columns, the chart can start to look cluttered and defeat the purpose of simple visualization.

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

A common point of confusion is the difference between a column chart and a bar chart. They are functionally identical but display the data differently:

• Column charts use vertical bars.
• Bar charts use horizontal bars.

The best time to use a bar chart instead of a column chart is when your category labels are very long. Long labels can be difficult to read when placed beneath vertical columns, often forcing them to an angle or requiring a very wide chart. Horizontal bars in a bar chart provide ample space, making the category labels much easier to read.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Preparing Your Data for a Column Chart

Before you create any chart, the most important step is setting up your data correctly. Clear, organized data is the foundation of a good visualization. Excel charts work best when your data is structured in a simple table format with headers.

For a column chart, you typically need two things:

1. Categories: These are the things you want to compare. This could be months, product names, marketing channels, or survey questions. These should be in the first column or first row.
2. Values: These are the numbers associated with each category. It could be revenue, session counts, user ratings, etc. These should be in the column or row next to your categories.

Let's use a sample dataset. Imagine we are a marketing team tracking website visits from different sources for the first quarter of the year. Our data in an Excel sheet might look like this:

This table is perfectly set up. The categories (sources) are in column A, and the values for each month are in the subsequent columns. Now, we're ready to visualize it.

Creating Your First 2D Column Chart (Step-by-Step)

Creating the initial chart in Excel takes just a few clicks. The real art is in the customization that follows, but let's get the basic chart on our sheet first.

1. Select Your Data: Click and drag your cursor to highlight the entire data set you want to include in the chart. In our example, you would select cells A1 through D6. Make sure you include the headers for both your columns and rows, as Excel is smart enough to use them as labels automatically.
2. Go to the Insert Tab: Look at the top ribbon in Excel and click on the Insert tab.
3. Find the Charts Group: In the middle of the Insert ribbon, you’ll find a section called Charts.
4. Click the Column Chart Icon: Look for the icon that shows several vertical bars. It's labeled "Insert Column or Bar Chart."
5. Choose a 2D Column Chart: A dropdown menu will appear with several options. Under the 2D Column section, click the first option, which is the Clustered Column chart.

And that’s it! An instant column chart will appear right on your worksheet, displaying your website traffic data organized by channel and month.

Customizing Your Column Chart to Make it Shine

A default Excel chart is a good start, but it's rarely ready for a final report or presentation. To make your chart truly communicate its message clearly and professionally, you'll need to do some formatting. When you click on your chart, two new tabs will appear on the Excel Ribbon: Chart Design and Format.

You can also access most formatting options by clicking the little plus sign (+) that appears in the top-right corner of the chart. This 'Chart Elements' menu is your command center for customization.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Add a Clear Chart Title and Axis Labels

The default title will likely be something generic like "Chart Title." Double-click it to give your chart a descriptive, meaningful title like "Q1 Website Traffic by Source." A good title tells the viewer exactly what they’re looking at.

You should also label your axes. Click the "+" button, hover over Axis Titles, and check the boxes for both Primary Horizontal and Primary Vertical. Then, double-click the new text boxes to label your Y-axis (vertical) as "Website Visits" and your X-axis (horizontal) as "Marketing Channel." This removes any guesswork for the viewer.

Adjusting Colors and Style

Branding and visual appeal matter. The default blue, orange, and gray color scheme might not fit your company's style guide or the story you're trying to tell.

• Use Pre-set Styles: On the Chart Design tab, you can quickly experiment with different chart styles and color schemes Excel provides. This is a fast way to find a professional-looking design.
• Change Individual Column Colors: For more control, you can change the color of each data series. For example, to change the January columns, right-click on any of the blue bars and select Format Data Series. A pane will open on the right. Click the Paint Bucket icon (Fill & Line) and select a new color under 'Fill.' This will change all bars in that series. If you only want to change a single bar, click it once to select the series, and then click it again to select just that specific bar before changing its color.

Managing Gridlines and Data Labels

Gridlines - the faint lines running in the background - can help a viewer trace back from a column to its value on the y-axis, but they can also add unnecessary visual noise. Consider removing them for a cleaner, more modern look. Click the '+' icon and uncheck the Gridlines box.

For more precision, Data Labels can display the exact value on top of each column. This is very helpful when the precise numbers are important. Click the '+' button and check the box next to Data Labels. You can even click the little arrow next to it for options on where to place the label (e.g., Inside End, Center, Outside End).

Formatting the Axes

Sometimes the automatic axis formatting isn't quite right. To adjust it, right-click on the vertical (value) axis and select Format Axis. From here, you can:

• Change the minimum and maximum bounds of the axis. For example, if your smallest value is 8,000, you might start the axis there to emphasize the differences between columns. (Use this with caution, as starting at a value other than zero can be misleading.)
• Adjust the major and minor units that define the gridline spacing.
• Change the number format to add commas, currency symbols, or control decimal places.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Advanced Column Chart: Stacked vs. 100% Stacked

Once you’ve mastered the basic clustered column chart, you can explore its variations to tell more complicated stories.

A Stacked Column Chart shows you the parts of a whole across different categories. Each column represents a total, and the different colored segments within that column show the contribution of each part. Using our data, a stacked column would show the total traffic per channel, with each column broken down by month. This helps you see both the total and the composition at the same time.

A 100% Stacked Column Chart is similar, but instead of showing absolute values, it shows the percentage contribution of each component. Each column goes up to 100%, making it easy to compare the relative makeup of categories. For example, you could see how the percentage of traffic from 'Paid' sources changed each month, regardless of the overall traffic numbers.

Common Mistakes to Avoid

Building a great chart also means avoiding common pitfalls that can make your visualization confusing or misleading.

• Overcrowding the Chart: Trying to plot too many categories will result in tiny, unreadable columns. If you have more than a dozen categories, consider grouping some together (e.g., 'Other Social') or using a different chart type.
• Vague Labels and Titles: Nothing is worse than sharing a chart titled "Chart." Always provide context with clear headings and axis titles so your audience knows exactly what data they're looking at.
• Using a Non-Zero Baseline: With column charts, the length of the bar directly represents a value. Starting the vertical axis at a number other than zero can exaggerate differences between columns and mislead your audience. Always start at zero unless you have a very specific reason not to.
• Relying on 3D Effects: Excel's 3D chart options might look fancy, but they often distort perspective and make it harder to accurately compare column heights. Stick with 2D charts for clarity and professionalism.

Final Thoughts

A well-made 2D column chart in Excel is an incredibly valuable reporting tool. By organizing your data correctly and taking a few extra minutes to customize the title, labels, colors, and layout, you can transform a simple spreadsheet into a clear, persuasive visual story that drives better understanding and decision-making.

Of course, manually building charts in Excel is a great skill set, but the process of downloading CSVs, cleaning data, and rebuilding reports week after week can be time-consuming, especially when managing data from platforms like Shopify or Google Ads. We built Graphed to solve this by automating your reporting. Instead of spending hours in spreadsheets, you can hook up your data sources and create live, real-time dashboards just by describing what you need. A prompt like "create a column chart of Shopify sales this month" instantly gives you an updated chart, saving you from all the manual busy work.