Bar and Column Charts
Excel calls the horizontal one a bar chart and the vertical one a column chart, which is the opposite of how most people use the words. Within either family the real decision is the arrangement. Clustered sets one bar per series side by side, all starting from the same baseline, so any bar can be compared with any other. Stacked piles the series into a single bar, which shows each part and the total but leaves only the bottom segment sitting on a shared baseline, so the segments above it become hard to compare across categories. 100% Stacked rescales every bar to the same full height, so proportions become comparable and the totals disappear completely. Choose horizontal bars whenever the category labels are long, because a bar chart gives each label a whole row while a column chart tilts it or truncates it.
A worked example
A2:A6 holds five sales regions (North, South, East, West, Central), and B2:D6 holds each region's revenue for Q1, Q2 and Q3.
Select A1:D6, open Insert > Insert Column or Bar Chart, and draw the same range three times: Clustered Column, Stacked Column, then 100% Stacked Column.
Clustered draws fifteen bars, three per region, every one measured from zero, so you can say directly that South beat East in Q3. Stacked draws five bars split into three coloured segments: the full-year total per region is now readable, but Q2 and Q3 float on top of whatever is beneath them, so comparing them across regions means comparing segment lengths by eye. 100% Stacked draws five bars of identical height and tells you Q3 was 45% of South's year against 28% of North's — while hiding that South sold roughly twice as much in total.
Which one do I need?
| If you want to… | Use |
|---|---|
| You want the bars to run vertically, one per category | Insert > Column — Excel files vertical bars under 'Column chart', so searching the gallery for 'bar' will not find them |
| Category names are long: product names, survey questions, country names | A horizontal bar chart, which gives every label its own full-width row instead of tilting it 45 degrees |
| You are comparing series against each other, category by category | Clustered — every bar starts at zero, so any two lengths are directly comparable |
| Each category is made of parts that add to a total worth showing | Stacked — read the total from the whole bar, and keep the series you most want compared at the bottom |
| You care about the mix within each category, not the size of it | 100% Stacked — every bar becomes the same height and only the proportions differ |
| Your horizontal bar chart lists the categories bottom-to-top, backwards from the sheet | Right-click the category axis > Format Axis > tick 'Categories in reverse order', then set the value axis to cross at the maximum category so the labels stay on the left |
| One series belongs on the chart as a line: a target, a running average, a prior year | A combo chart — change only that series to Line, and give it a secondary axis if its scale differs |
| The bars are really tracking change over time rather than comparing categories | A line chart, which reads a twelve-point time series far better than twelve columns do |
| The bars need to represent task durations positioned across a calendar | A stacked bar chart whose first segment is made invisible — the standard Gantt construction |
| You are still deciding whether bars are the right family at all | Start from the question the data answers, not from the gallery |
Frequently asked questions
What is the difference between a bar chart and a column chart in Excel?
Only the direction. Excel reserves "bar chart" for horizontal bars and "column chart" for vertical ones, and puts them under separate headings in the Insert gallery. Everyday speech uses "bar chart" for both, which is why people hunt for vertical bars under Insert > Bar and cannot find them. The data, the series and the options are otherwise identical.
When should I use a stacked bar chart instead of a clustered one?
Use stacked when the parts genuinely add up to a total your reader cares about, such as revenue split by product line within each region. Use clustered when the point is comparing series against each other, because only clustered bars all start from the same baseline. In a stacked bar every segment except the bottom one floats on the ones below it, which makes precise comparison across categories much harder than it looks.
Why is my horizontal bar chart in reverse order?
Excel builds the category axis from the bottom up, so the first row of your sheet becomes the lowest bar and the list reads upside down. Right-click the category axis, choose Format Axis, and tick "Categories in reverse order". That flip also moves the value axis to the top of the plot, so set "Horizontal axis crosses" to "At maximum category" to bring the category labels back to the left.
How do I add a target line across a bar chart?
Add a helper column next to your data that repeats the target value on every row, include it in the chart range so it becomes an extra series, then use Chart Design > Change Chart Type > Combo and set only that series to Line. The repeated constant draws as a flat line across all the bars. Untick its legend entry or rename the series if you do not want it listed alongside the real data.
New guides and tools, once a month
DE + EN · double opt-in · no spam