Column and bar charts in Excel - Step-by-Step Guide

Introduction

Column and bar charts help you show data visually so you can compare numbers easily. They turn rows and columns of numbers into colorful bars that make patterns and differences clear at a glance.

When you want to compare sales numbers for different products side by side.

When you need to show monthly expenses to see which months cost more.

When you want to display survey results to compare preferences across groups.

When you want to highlight the highest and lowest values in a list of data.

When you want to present data in a simple way during a meeting or report.

Steps

Step 1: Select

- the cells containing your data including labels

The data range is highlighted on the worksheet

Step 2: Click

- the Insert tab on the Ribbon

The Insert tab options appear

Step 3: Click

- the Insert Column or Bar Chart button in the Charts group

A menu with chart style options appears

Step 4: Choose

- a chart style such as Clustered Column or Stacked Bar

The chart is inserted into the worksheet showing your data visually

Step 5: Click

- the Chart Title text box on the chart

The title becomes editable

💡 Type a clear title that explains what the chart shows

Step 6: Use

- the Chart Tools tabs (Design and Format) on the Ribbon

You can change colors, styles, and labels to make the chart easier to read

Before vs After

Before

A table with product names in column A and sales numbers in column B

After

A colorful column chart appears showing each product's sales as vertical bars with a clear title

Settings Reference

Chart Type

📍 Insert tab > Insert Column or Bar Chart button

Choose how the bars are grouped and stacked to best show your data

Default: Clustered Column

Chart Title

📍 Chart area > Click on Chart Title text box

Add a descriptive title to explain what the chart represents

Default: Chart Title

Legend

📍 Chart Tools Design tab > Add Chart Element > Legend

Show or hide the legend that explains what each color or bar means

Default: Right

Data Labels

📍 Chart Tools Design tab > Add Chart Element > Data Labels

Display the exact values on each bar for easier reading

Default: None

Common Mistakes

Selecting only the numbers without the labels before inserting the chart

The chart will not show meaningful labels on the axis, making it hard to understand

Always select both the labels and the numbers so the chart can label each bar correctly

Using a stacked bar chart when you want to compare individual values side by side

Stacked charts combine values, which can hide individual differences

Use a clustered column or bar chart to compare each item separately

Summary

Column and bar charts turn numbers into easy-to-understand bars for quick comparison.

Select both labels and data before inserting a chart to get clear axis labels.

Use chart tools to customize titles, colors, and labels for better clarity.