Column Chart and Bar Chart

Column Charts and Bar Charts are among the most commonly used charts in Microsoft Excel. Both charts are used to compare values between different categories. The main difference is the direction in which the data is displayed.

Column Chart

A Column Chart displays data using vertical columns. It is useful for comparing values across different categories and showing changes over time.

When to Use a Column Chart

• Compare sales of different products.
• Compare marks of students.
• Compare monthly or yearly performance.
• Show trends over time.

Example Data

Steps to Create a Column Chart

1. Select the data range including headings.
2. Click the Insert tab.
3. Go to the Charts group.
4. Select Insert Column or Bar Chart.
5. Choose Clustered Column.

Bar Chart

A Bar Chart displays data using horizontal bars. It is useful when category names are long or when comparing a large number of categories.

When to Use a Bar Chart

• Compare employee performance.
• Compare product sales.
• Display rankings.
• Show data with long category names.

Example Data

Steps to Create a Bar Chart

1. Select the data range including headings.
2. Click the Insert tab.
3. Select Insert Column or Bar Chart.
4. Choose Clustered Bar.

Difference Between Column Chart and Bar Chart