Docs tower · floor

How to make a bar graph in Excel, and which kind

Making one is quick: select the data, Insert › Recommended Charts, pick the bar chart, OK. If that is all you needed, you are done. But how to make a bar graph in excel hides a second question that the menu asks and most people answer by accident — because three different bar charts sit side by side in it, and they do not mean the same thing.

Three kinds of bar chart, three different questions

They sit next to each other in the same menu and look like variations on a theme. They are not. Each answers a question the others cannot, and Microsoft states which.

“Who is biggest?”Clustered
Microsoft: “Compares values across categories.” Every bar starts at zero, so lengths are directly comparable. This is the default and usually the right answer.
“What is each total made of?”Stacked
Microsoft: “Shows the relationship of individual items to the whole, comparing the contribution of each value to a total across categories.” The totals are comparable. The segments inside are not — only the bottom one starts at zero, so the eye cannot measure the rest against each other.
“What is the mix?”100% stacked
Microsoft: “Compares the percentage that each value contributes to a total across categories.” Every bar is the same length, so size disappears entirely and only proportion remains. Right for comparing composition; wrong if the totals matter, because it hides them.

The stacked one is where charts go wrong quietly. It looks like it shows everything at once, and it does show the totals honestly. But ask yourself the question people actually put to a stacked chart — “did the middle segment grow?” — and you will find you cannot answer it, because that segment floats at a different height in every bar. Only the bottom band is measurable. If the comparison you care about is between components rather than totals, a clustered chart answers it and a stacked one does not.

If the bars come out in the opposite order to your rows

This is the single most common complaint about bar charts specifically, and it is not a fault — it is the axis direction. The fix is a checkbox, and Microsoft documents where it lives.

Select the category axis, then Format tab › Current Selection › Format Selection. In the Axis Options category: “For categories, select the Categories in reverse order check box.” There is a matching Values in reverse order for the other axis.

One limit worth knowing before you go looking for it elsewhere: Microsoft notes that “you can’t reverse the plotting order of values in a radar chart”.

Bar or column? Microsoft settles it in two lines rather than leaving it to taste: “Consider using a bar chart when: The axis labels are long. The values that are shown are durations.” Horizontal bars give long category names room to sit as readable text instead of being squashed or turned on their side, and a duration reads naturally as a length. For everything else, the column chart is the one Microsoft describes as useful “to show how data changes over time or to show comparisons among items”.

Do not start the value axis anywhere but zero. This is the one genuine ethics question in a bar chart, and it is specific to bars: the length of the bar is the value. Cut the axis at 90 and a rise from 92 to 96 becomes a bar twice the height of its neighbour. The same trim on a line chart is a legitimate way to show detail, because a line encodes position rather than length. On bars it is a misrepresentation, and it is the most common one in circulation.

Bar chart or bar graph, create or make — the wording changes and the feature does not. How to create a bar chart in excel and how to make a bar graph in excel are the same Insert menu and the same three kinds of bar. Microsoft calls them charts; most people say graphs; Excel does not mind either way.

The 3-D versions add nothing. Microsoft says so itself: of the 3-D bar variants, a “3-D clustered bar chart shows bars in 3-D format; it doesn’t use a depth axis”. There is no third measurement in that depth — it is a drawing effect on two-dimensional data, and it makes the bars at the front look longer than equal bars behind them.

The steps here, the definitions of the three bar types, the bar-or-column rule and the reverse-order checkbox are all quoted from Microsoft’s own documentation, read on 22 August 2026 and listed below. The warning about stacked charts and the point about the zero baseline are ours.

Where to start

Four ways in.

“I just need the steps.”
Above. Then check which kind in which kind of bar
“Clustered or stacked?”
That is which kind of bar
“My bars are upside down.”
One checkbox — fixing the axis
“Should this even be a bar chart?”
Go to the wider choice

Which kind of bar

Clustered, stacked and 100% stacked are three answers to three questions. Picking the wrong one produces a chart that is accurate and unreadable.

Line graphs in ExcelThe other chart people reach for, and the rule that decides which of the two your data needs.Open this floor → Graphs and charts in ExcelMicrosoft publishes four conditions for a pie chart, and most pie charts fail one of them.Open this floor → Removing duplicates in ExcelThree tools and only one deletes, and what Excel actually counts as a duplicate.Open this floor → Sorting alphabeticallyOne word in Microsoft’s first step keeps your rows together.Open this floor →

Fixing the axis

Most bar chart complaints are axis settings rather than chart faults, and each has a documented checkbox.

Freezing rows in ExcelOne rule from Microsoft explains every case.Open this floor → Merging cells in ExcelMicrosoft says merging deletes the other cells, and merged blocks break everything downstream.Open this floor → Drop-down lists in ExcelPut the source in a table so it updates itself, and the option that decides whether the list is enforced.Open this floor →

The wider choice

A bar chart is one of several shapes, and Microsoft states conditions for each. Sometimes the honest answer is a different chart entirely.

PDF to ExcelWhat survives the conversion, and the numbers that arrive as text.Open this floor → Lock cells in ExcelEvery cell is already locked, so the real job is unlocking the ones people should edit.Open this floor →
Spreadsheets as softwareThe point at which a spreadsheet has quietly become an application.Being built

Getting it out

The chart usually has to leave the spreadsheet, and that journey is where quality is normally lost.

PowerPoint to PDFWhat Microsoft’s own export keeps, and the setting that decides the file size.Open this floor → Word to PDFThe two export options and what each one is actually for.Open this floor → Table of contentsWord builds it from your headings — which is why it is empty when nobody marked them.Open this floor →

What this tower will not do

It will not treat clustered, stacked and 100% stacked as styling. They answer three different questions, and Microsoft says which is which.

It will not let a truncated axis pass. On a bar chart the length is the value, and cutting the baseline misrepresents it.

And it will not recommend a charting add-in for something that is one dropdown on the Insert tab. What holds instead is simple: the chart definitions, the bar-or-column rule and the reverse-order setting are quoted from Microsoft’s own documentation, with the date each page was read.

Where this page got its facts

  1. Microsoft Support — Available chart types in Office, including the definitions of clustered, stacked and 100% stacked bars, when to use a bar rather than a column, and the note that 3-D bar charts use no depth axis — support.microsoft.com, read 22 August 2026.
  2. Microsoft Support — Change the plotting order of categories, values, or data series, including the Categories in reverse order check box and the radar chart exception — support.microsoft.com, read 22 August 2026.
  3. Microsoft Support — Create a chart from start to finish, for the Insert and Recommended Charts route — support.microsoft.com, read 22 August 2026.

Written by Alberto Gulotta

Founder and editor of AI Tools Primer, writing from Palermo, Italy. Thirty-five years of taking computers apart, starting with a Commodore 64 — the long version is on the about page.

Something wrong on this page? Write to aitoolsprimer@gmail.com and it gets fixed.

Written on 22 August 2026.

Independence and limits

No affiliate links and no paid placements anywhere on this site. Nobody pays to appear here, and no company has seen this page before you did.

This is general information, not professional advice. Where a page touches money, health, safety or the law, it names its source and the date it was read — and your situation may still differ. See the privacy page and the cookie policy.