How to Make a Bar Chart in Excel (2026)
Bar charts are Excel's most common chart type — comparing categories, showing rankings, or displaying frequencies. This guide covers the fastest way to make one, plus three formatting moves that turn default bars into presentation-ready ones.
⚡ Quick Answer
Select your data range (including headers), press Alt + F1. Excel inserts a default bar chart on the current sheet. For a custom type, use Insert tab → Bar or Column icon.
Method 1: Keyboard shortcut (fastest)
Select your data
Include headers. Excel uses them as category labels and series names.
Press Alt + F1
Excel inserts its recommended chart on the current sheet. For most data with categories, this is a column chart.
Move and resize
Drag the chart to position; drag corners to resize. Hold Alt while dragging edges to snap to gridlines.
Method 2: Insert tab (choose variant)
Select your data
Include headers.
Insert tab → Column or Bar chart icon
Column icon = vertical bars. Bar icon = horizontal bars.
Pick a variant
Options: Clustered (2+ series side-by-side), Stacked (series stacked), 100% Stacked (proportion of total).
Click to insert
Chart appears on the current sheet.
Method 3: Recommended Charts
If you're not sure which variant fits, use Excel's suggestions.
Select data → Insert tab → Recommended Charts
Or click the small chart icon in the Charts group.
Preview options
Excel shows 5-10 chart types with live previews of your data.
Pick and OK
Chart inserts with the chosen type.
Bar vs. column: quick decision
- Column chart (vertical) — comparing time periods (quarters, months) or short category labels.
- Bar chart (horizontal) — long category labels (product names, department names) or many categories (10+).
Formatting to make bars look designed
Move 1: Sort the bars
Right-click the source data column → Sort → Largest to Smallest. Sorted bars communicate the order instantly. Unsorted bars feel random unless there's a natural order (chronological).
Move 2: Simplify colors
By default Excel gives each bar the same color when they're one series. Keep it that way — one color for the whole series, one accent color for a bar you want to highlight.
To highlight one bar:
- Click the chart to select it
- Click the bar you want to highlight once more (selects just that data point)
- Right-click → Fill Color → pick your accent color
Move 3: Kill chart junk
- Delete the chart border (Format Chart Area → No line)
- Delete background fill
- Delete gridlines you don't need
- Delete the legend if you have one data series
- Write a takeaway-style title (e.g., "Q3 revenue outpaced target by 18%" not "Quarterly Revenue")
Bar chart variants explained
Clustered bars
Multiple series side-by-side. Best for comparing 2-4 series across categories (e.g., revenue by product across regions).
Stacked bars
Series stacked on top of each other. Shows total plus composition (e.g., total sales by quarter, broken by product).
100% stacked bars
All bars same length. Each segment = share of total (e.g., market share breakdown by quarter).
3D distorts values. Bars in the back look smaller than bars in the front even when they're equal. Always use 2D versions.
Bar charts must start at zero. Y-axis starting at 80 to make small differences look huge is misleading. Non-negotiable for bars.
Skip the chart wizardry
Describe what you want to visualize in plain English — "show quarterly revenue by region as a horizontal bar chart, sorted descending" — and Excel Wizard builds it, formats it, and drops it on your sheet. No clicking through chart wizards, no manual sorting, no color tweaking.
Install Excel Wizard →Frequently asked questions
How do I make a bar chart in Excel?
Select your data range including headers. Go to Insert tab, click the Bar or Column chart icon, and pick a variant. Or press Alt + F1 for the fastest possible bar chart.
What's the difference between bar and column charts?
Bar charts are horizontal; column charts are vertical. They encode the same data. Use bar when category labels are long or you have many categories; use column when comparing time periods or short labels.
How do I sort bars in a chart?
Sort the underlying data descending — the chart follows. Right-click the source data column → Sort → Largest to Smallest. Sorted charts communicate faster.
How do I highlight one bar in Excel?
Click the chart, then click the specific bar once more (this selects just that data point). Right-click → Fill Color → pick your accent color. The single-point color persists.