How to Create a Bar Graph in Excel: A Complete Step-by-Step Guide

Bar graphs are one of the most widely used chart types in Excel — and for good reason. They make it easy to compare values across categories at a glance, whether you're tracking monthly sales figures, survey results, or project timelines. Excel's charting tools are robust, but the path from raw data to a polished bar graph has more variables than most people expect.

What Is a Bar Graph in Excel (and How Is It Different from a Column Chart)?

This distinction trips up a lot of users. In Excel's terminology:

• A bar chart displays data with horizontal bars
• A column chart displays data with vertical bars

Both serve similar comparison purposes, but Excel treats them as separate chart types. Most people searching for "bar graph" are often looking for either one — so it's worth knowing which layout suits your data before you start.

Horizontal bar charts work well when category labels are long or when you're ranking items. Vertical column charts are typically better for time-series data (months, quarters, years).

Step-by-Step: Creating a Basic Bar Graph in Excel

Step 1: Organize Your Data

Before inserting any chart, your data needs a clear structure. Excel reads charts from tabular data, so organize yours like this:

• Put labels in one column and values in the adjacent column
• Include a header row — Excel uses these as axis labels and legend text
• Avoid blank rows or merged cells within the data range

For multi-series bar graphs (comparing two or more data sets side by side), add additional value columns with their own headers.

Step 2: Select Your Data Range

Click and drag to highlight your entire data table, including headers. If your data is non-contiguous (separate columns), hold Ctrl while selecting each range on Windows, or Command on Mac.

Step 3: Insert the Bar Chart

With your data selected:

1. Go to the Insert tab in the ribbon
2. Find the Charts group
3. Click the Bar Chart icon (it looks like horizontal bars) or Column Chart icon (vertical bars)
4. Choose your subtype — Clustered, Stacked, or 100% Stacked

Excel will immediately generate a chart on your current worksheet.

Step 4: Choose the Right Bar Chart Subtype

Clustered is the default and the most common starting point. Stacked variants add complexity — use them only when the composition of each bar carries meaning.

Customizing Your Bar Graph 📊

Excel generates a functional chart immediately, but the default styling rarely communicates data as clearly as it could.

Editing Chart Elements

Click the chart to activate it. You'll see:

• Chart Title — double-click to edit directly
• Axis Labels — automatically pulled from your headers; rename source data to update them
• Legend — useful for multi-series charts; can be repositioned or removed for single-series charts
• Data Labels — right-click any bar and select Add Data Labels to display exact values on each bar

Adjusting Colors and Styles

• Click a bar to select the entire series, then right-click → Format Data Series
• The Format pane on the right lets you change fill color, border, and bar width (Gap Width setting)
• The Chart Design tab (appears when chart is selected) offers pre-built style themes

Changing Chart Type After Creation

Made the wrong choice? Right-click the chart area → Change Chart Type — you can swap between bar, column, line, or any other type without rebuilding from scratch.

Moving the Chart

• On the same sheet: Click and drag
• To a new sheet: Right-click the chart → Move Chart → select New Sheet

Working with More Complex Data 📈

Multi-Series Bar Graphs

If your table has multiple value columns, Excel plots each as a separate series — displayed as grouped bars per category. This is useful for side-by-side comparisons (e.g., actual vs. target, or year-over-year figures).

Sorting Bars for Clarity

Excel plots bars in the order your data appears in the spreadsheet. If you want bars ranked from highest to lowest, sort your source data first — the chart updates automatically.

Switching Rows and Columns

If Excel interprets your data the wrong way (series and categories are swapped), go to Chart Design → Switch Row/Column to flip the orientation without touching your data.

Factors That Affect Your Workflow

How straightforward this process feels depends on several variables:

• Excel version — Microsoft 365 subscribers get the most current charting interface; Excel 2016 or 2019 users have the same core tools but a slightly different ribbon layout
• Data complexity — single-series data takes minutes; pivot-table-sourced charts or dynamic named ranges add meaningful setup time
• Operating system — Excel for Mac and Excel for Windows share most features, but keyboard shortcuts and some formatting panels differ
• Chart purpose — a quick internal chart needs far less polish than one going into a client presentation or published report

The underlying chart creation steps are consistent across modern Excel versions, but formatting depth, template availability, and integration with tools like Power Query vary significantly depending on your setup.

A reader building a simple quarterly comparison chart has a fundamentally different task than someone building a dynamic dashboard that updates from an external data source — and what counts as "done" looks very different in each case.