How to make a bar chart in Excel
Bar and column charts are the workhorse of Excel — best for comparing values across categories. Getting them clear (right type, sorted, labelled) takes a few choices. Here's how, and the one-click alternative.
When to reach for a bar chart
Bars are the default for comparing values across categories — simple, familiar and hard to misread.
Compare categories
Sales by product, headcount by team — ranked side by side.
Show change
Column charts read well for values over a few time periods.
Rank clearly
Sort bars so the biggest sits first and the story is instant.
How to make one in Excel
A few small choices — type, order and labels — separate a clear chart from a cluttered one.
Select your data
Two columns: categories and their values, with headers.
Insert the chart
Insert › Charts › Column or Bar. Use columns for few categories, horizontal bars for long labels.
Sort for clarity
Sort the source data largest-to-smallest so the bars rank cleanly.
Label it
Add data labels and a title via Chart Elements (+); drop gridlines you don't need.
The most common bar-chart mistake is leaving categories in their original order — an unsorted bar chart makes the reader do the ranking. Sort the data first, keep one idea per chart, and label the bars directly so the axis becomes optional. Those small choices are what separate a chart that informs from one that just decorates.
The faster way — skip the fiddling
Choosing the type, sorting and labelling every time adds up. DataHub Pro makes those choices for you.
Quick, but choices add up
- Pick column vs bar each time
- Sort the source data by hand
- Add labels, titles, tidy gridlines
- Rebuild when the data changes
Clean charts, auto-built
- Upload the file — it picks and sorts for you
- Labels and titles applied automatically
- Refreshes on new data
- Drops into a dashboard or report
FAQ
What is the difference between a bar chart and a column chart in Excel?
They show the same thing; columns are vertical and bars are horizontal. Use columns for a handful of categories or time periods, and horizontal bars when category names are long or there are many of them.
How do I sort a bar chart in Excel?
Sort the underlying data, not the chart. Select your data, sort the value column largest-to-smallest, and the bars re-rank automatically. For horizontal bars you may need to reverse the axis order so the largest sits on top.
How do I add data labels?
Click the chart, open Chart Elements (the +) and tick Data Labels. You can then position them inside or above each bar from the label options.
Keep exploring
More visual analysis you can run on your own data — no sign-up needed to read.
Clean bar charts without the fiddling
Upload an Excel or CSV file and DataHub Pro builds sorted, labelled charts for you. Free to try, no card.
Start free →