How to Make a Bar Chart in Excel (2026 Guide)
Home›Excel Charts›Make a Bar Chart
ExcelHow-To⏱ 2 min read

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)

  1. Select your data

    Include headers. Excel uses them as category labels and series names.

  2. Press Alt + F1

    Excel inserts its recommended chart on the current sheet. For most data with categories, this is a column chart.

  3. 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)

  1. Select your data

    Include headers.

  2. Insert tab → Column or Bar chart icon

    Column icon = vertical bars. Bar icon = horizontal bars.

  3. Pick a variant

    Options: Clustered (2+ series side-by-side), Stacked (series stacked), 100% Stacked (proportion of total).

  4. 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.

  1. Select data → Insert tab → Recommended Charts

    Or click the small chart icon in the Charts group.

  2. Preview options

    Excel shows 5-10 chart types with live previews of your data.

  3. 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:

  1. Click the chart to select it
  2. Click the bar you want to highlight once more (selects just that data point)
  3. 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).

Never use 3D bars

3D distorts values. Bars in the back look smaller than bars in the front even when they're equal. Always use 2D versions.

Never truncate the Y-axis

Bar charts must start at zero. Y-axis starting at 80 to make small differences look huge is misleading. Non-negotiable for bars.

Excel Wizard

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.