How to Create a Bar Chart in Excel: Setup, Subtypes and Tips
How to create a bar chart in Excel — three-step setup, when to choose bar over column, stacked subtypes, formatting tips and common pitfalls to avoid.
How to Create a Bar Chart in Excel: The Three-Step Setup
Creating a bar chart in Excel takes three steps. Select your data including category labels and values. Click the Insert tab on the ribbon. Click the Bar Chart icon in the Charts group and choose the subtype that fits your data. Excel produces a horizontal bar chart on the active worksheet within a second.
The basic flow is identical to any other chart type creation, but the choice of bar versus column versus other types matters more than most users realise. Bar charts have specific strengths that make them the right pick for some questions and a worse pick for others.
This guide focuses on bar charts specifically — when they work better than column charts, which subtype to choose, how to customise the result and the common mistakes that produce bar charts harder to read than they should be. The aim is to give you the specific knowledge that turns a routine bar chart into a clean, professional visualisation rather than a default Excel chart that looks like every other default Excel chart in every other dashboard.
Bar charts are among the most-used chart types in business reporting. Survey results, performance comparisons, top-N rankings and budget allocations all read well as bar charts. Knowing the small set of customisations that improve the default Excel bar chart turns five seconds of work into a substantial improvement in the end deliverable. The investment pays back across hundreds of charts over an Excel-using career.
Bar chart in Excel at a glance
Setup: Select data → Insert tab → Bar Chart → choose subtype. Subtypes: Clustered Bar, Stacked Bar, 100% Stacked Bar (avoid 3D variants). Best for: long category labels, 5+ categories, ranking comparisons. Use column chart instead for: time series, ≤5 categories, where vertical reading feels natural. Customisation: Chart Title, data labels, gap width 50–100, brand colours via Chart Design tab. Sort source data before charting to control bar order.
Bar Chart vs Column Chart
The most common confusion in Excel charting is between bar charts and column charts. The two look similar but have different strengths. Bar charts have horizontal bars with category labels along the vertical axis. Column charts have vertical bars with category labels along the horizontal axis. The visual data they encode is the same, but the layout affects readability significantly depending on the data shape. Bar charts give long category labels room to breathe horizontally, which matters when the labels are sentence fragments or full names rather than short codes.
Column charts work better for time series — months, quarters or years on the horizontal axis with values rising vertically. Time naturally reads left to right, and column charts encode that natural reading direction. Bar charts work better for ranking comparisons — top 10 sales reps, longest queries, biggest customers — where the visual impact of horizontal bars at varying lengths conveys magnitude immediately.
They also work well for survey results with many response categories, organisational performance data with long division names, and any dataset where the category axis labels are too long to fit horizontally under column bars without rotating to a 45-degree angle.
One useful tactical question is to imagine reading the chart from across a conference room. If the labels would be readable horizontally beneath columns, the column chart works. If the labels would be cramped or rotated under columns, the bar chart with horizontal labels solves the readability problem. The same logic applies to printed reports — bar charts handle long labels in narrow page widths better than column charts that force label rotation or font shrinkage.
When to Choose Bar Over Column
Bar charts give long labels (sentence fragments, full names, multi-word categories) horizontal room. Column charts force long labels to rotate or truncate. Whenever the longest category label exceeds about 12 characters, bar chart usually reads more cleanly.
Bar charts handle long category lists better than column charts because vertical scrolling is more comfortable than horizontal scrolling. Top 10 lists, ranked surveys and category breakdowns of 5 to 30 items all read better as bar charts.
Sort your data descending by value before charting. The longest bar at the top, second longest below it, and so on. The visual hierarchy reads instantly. This is the most powerful pattern for bar charts and produces dashboard-quality output with no extra customisation.
Likert-scale survey responses, multi-option preference questions, and any survey output with 5 to 12 response categories. Bar charts handle these cleanly. Column charts squeeze the labels uncomfortably in most cases.
Sales by region, conversion rates by channel, quality scores by department. The category labels are usually proper nouns that do not abbreviate well. Bar charts preserve readability while column charts force the labels to truncate or rotate.
Time series belongs in column charts. Two-category comparisons fit either format but column often feels more natural. Distributions are better as histograms. Proportions of a whole work as pie charts under six slices or stacked bar over.
Bar Chart Subtypes: Clustered, Stacked, 100% Stacked
Excel offers three main 2D bar chart subtypes plus 3D variants of each (avoid the 3D variants — they distort visual proportions). The Clustered Bar subtype shows multiple data series side by side within each category. Use it when you want to compare individual values across categories — for example, Q1 versus Q2 sales by region with two bars per region.
The Stacked Bar subtype stacks the data series end to end within each category, with each series taking a portion of the bar's total length. Use it for parts-of-whole comparisons where the total matters and the segments matter — Q1 plus Q2 plus Q3 plus Q4 sales by region with one stacked bar per region.
The 100% Stacked Bar subtype rescales every bar to the same total length, with each segment showing what percentage of the total each series contributes. Use it for proportional comparisons where the absolute total does not matter but the relative composition does. A 100% stacked bar showing channel mix by region answers "what percentage of each region's sales come from each channel" without obscuring the answer with magnitude differences between regions. Choose subtype based on the comparison you want the reader to draw. Picking the wrong subtype produces a chart that technically displays the data but obscures the insight.
One subtle distinction is between Stacked Bar and 100% Stacked Bar that catches some users off guard. Stacked Bar preserves the absolute totals — a region with $100,000 total has a longer bar than a region with $50,000 total even if the proportional mix is identical. 100% Stacked Bar normalises every bar to the same length, hiding the absolute difference and showing only the proportional composition. Picking one when you needed the other produces a chart that obscures the actual answer to the reader's question.
Step-by-Step: Building Your Bar Chart
Organise data in a clean table with category labels in column A and values in column B (or multiple value columns for multi-series charts). Sort by value descending before creating the chart so the longest bar appears at the top. Remove blank rows or columns inside the data range.
Customisation Tips That Make a Difference
The default Excel bar chart works but rarely looks polished without customisation. The single highest-impact change is reducing the Gap Width — the empty space between bars. Excel's default Gap Width of 150 percent leaves the bars looking thin and the chart looking sparse. Reducing to 50 to 100 percent produces wider bars that fill the chart area better and emphasise the data over empty space. Right-click any bar, choose Format Data Series, and drag the Gap Width slider to find the value that works best for your specific chart.
The second highest-impact change is adding data labels at Inside End or Outside End. Data labels show the precise value for each bar, removing the need for the reader to estimate from the axis tick marks. Use the Chart Elements (+) button to add labels and choose the position. Inside End places the label just inside the end of each bar; Outside End places it just outside the end.
Inside End usually looks cleaner for charts with consistent value lengths; Outside End is better when bar lengths vary widely. The third high-impact change is removing unnecessary chart elements — if data labels are present, the value axis can usually be hidden because the labels carry the precise numbers.
Colour palette matters more than most users realise. Default Excel colours are recognisable as Excel defaults at a glance and signal hasty work to discerning readers. Even a small custom palette using your brand colours or a thoughtful colour combination produces dramatically more polished output. The Page Layout tab offers built-in colour themes that affect every chart in the workbook, providing a quick way to apply consistent colours across multiple charts simultaneously.
3D bar charts look impressive but distort visual proportions. The perspective makes front-positioned bars look longer than back-positioned bars even when the underlying values are equal. Modern data visualisation guidance is unanimous on this: use 2D bar charts always. The flat presentation conveys the data accurately. The 3D versions exist in Excel for backwards compatibility with older versions, not because they produce better charts.
Sorting and Category Order
The single most common bar chart layout problem is unsorted source data producing arbitrary bar order in the chart. Excel does not automatically sort the data when creating the chart. Whatever order the data appears in your worksheet is the order it appears in the chart, except that Excel reverses it because the first row goes to the bottom of the bar chart axis by default.
The fix is two-step: sort the source data descending by the value column before charting, and check the "Categories in reverse order" option in the category axis format settings. The combination produces a chart where the largest value sits at the top, second largest below it, and so on down to the smallest at the bottom.
Some bar charts deliberately preserve the source data order rather than sorting by value. Reports comparing performance across regions in a fixed corporate order (always East then West then Central then Mountain), or product lines in catalog order, sometimes need the original sequence rather than a value-sorted view. The Format Axis settings let you keep the source order without sorting, which is useful when the corporate convention matters more than the value-based visual hierarchy. Most analytical bar charts benefit from value sorting; some operational reports do not.
When the data is updated frequently, the sort needs to happen before each refresh. PivotChart-based bar charts handle this automatically because the underlying PivotTable can be configured to sort by value. Standard bar charts based on regular ranges require manual re-sorting whenever new data is added, or a SORT-formula-based source range that re-sorts dynamically. Choosing the right approach for the chart's data update cadence matters because manual re-sorting is easy to forget.
Bar Chart Quality Checklist
- ✓Source data sorted descending by value before charting
- ✓Category axis reversed so the largest bar appears at the top
- ✓2D subtype chosen (skip all 3D variants)
- ✓Chart title clearly states what the bars represent
- ✓Axis labels include units of measurement (USD, count, percentage)
- ✓Gap width reduced from default 150% to 50–100% for visual balance
- ✓Data labels added if precise values matter to the reader
- ✓Brand colours applied via Chart Design Style or Format Data Series
- ✓Number of bars limited to fit cleanly in the chart area (typically 5–25)
- ✓Chart tested in print preview if it will be printed or exported as PDF
Special Cases and Variants
Bar charts have several useful variants worth knowing. The horizontal bar chart with negative values produces a left-right comparison around a central zero axis — useful for surplus/deficit analysis, gain/loss comparisons or any data with positive and negative values relative to a baseline.
The Clustered Bar with two series produces side-by-side comparison bars within each category, which is an effective alternative to a Combo chart when both series share the same scale. A Population Pyramid is a specific bar chart variant showing demographics — male population on the left, female population on the right, age categories along the vertical axis — built by setting one series to negative values and adjusting axis labels.
Top 10 bar charts focus the reader on a curated subset rather than every category. The standard pattern combines the FILTER function (or a sorted Top 10 named range) with a chart referencing the dynamic range. As source data updates, the Top 10 chart automatically refocuses on the current top performers. This is one of the most useful patterns for executive dashboards because it filters noise from the chart while remaining live to the underlying data. Similar patterns work for Top N for any N value, and for filtered bar charts that show only categories meeting specific criteria.
One particularly useful pattern is the comparison of two time periods using a side-by-side bar chart. Q1 vs Q2 sales by region produces a Clustered Bar with two series — Q1 in one colour and Q2 in another. The reader compares both periods within each region directly. The same pattern works for current-year-vs-prior-year, actual-vs-budget, and any two-period comparison. Adding data labels showing the percentage change between the two bars makes the comparison even faster to read.
Common Mistakes to Avoid
Several mistakes appear repeatedly in Excel bar charts. The first is unsorted bars — categories appearing in arbitrary or alphabetical order rather than value-sorted descending. The fix is one quick sort of the source data plus a category-axis reverse-order setting. The second is too many bars cramming into the chart area. Bar charts work well from about 5 to 25 categories; beyond 25 the chart becomes hard to read. Splitting a large dataset into multiple smaller charts (small multiples, separate by region or category) usually reads better than one dense chart with 50+ bars.
The third common mistake is mixing scales on a single chart. Two metrics with very different ranges — for example, sales in thousands and growth percentage — produce a chart where one series dominates and the other becomes invisible. The fix is a Combo chart with a secondary axis, or splitting into two separate charts.
The fourth mistake is decorative chart junk — gradients, drop shadows, textured fills — that adds visual noise without adding information. Modern data visualisation favours clean, flat, minimal chart styles. The fifth mistake is missing axis labels and units, which forces readers to guess what the numbers represent. Five seconds of label addition saves the reader meaningful confusion.
One mistake worth highlighting separately is the use of bar charts for time series data. Time naturally reads left to right, and column charts encode that reading direction. Using a bar chart for monthly or quarterly data forces the reader to mentally rotate the chart to interpret the time progression. The chart still works but reads awkwardly. Save bar charts for non-time-based comparisons and use column charts for time series unless there is a specific reason to do otherwise.
Bar Chart Quick Reference
Bar Chart Variants Worth Knowing
Multiple series side by side within each category. Best for comparing 2 to 4 metrics across categories. Becomes hard to read with more than 4 series in a single category. Use when each metric needs its own visible bar.
Series stacked end to end within each bar. Best for parts-of-whole where total matters. Reader sees both the total length and the segment lengths. Works well for time-period stacks (Q1+Q2+Q3+Q4) or product mix per region.
Like stacked bar but rescaled so each bar reaches 100%. Best for proportional comparison where absolute totals do not matter. Good for showing channel mix or category mix where comparison is about composition rather than magnitude.
Bars extending left and right from a central zero axis. Useful for surplus/deficit, gain/loss, opinion polls (favourable/unfavourable). Built by combining positive and negative values in the source data.
Specific demographic chart showing male population on the left, female population on the right, age groups stacked vertically. Built with one series as negative values plus careful axis label customisation.
Bar chart that automatically displays the current top 10 categories from a larger dataset. Built with FILTER and SORT dynamic array functions feeding the chart's source range. Updates automatically as source data changes.
Bar Charts in PivotTables and Dashboards
Bar charts are particularly powerful when paired with PivotTables. A PivotChart based on a PivotTable inherits the pivot's filtering, slicing and grouping capabilities. Adding slicers above the chart lets non-technical users filter the data interactively, with the chart updating automatically. This is the pattern most modern Excel dashboards use — PivotTable underneath, PivotChart on top, slicers controlling both. Building this combination once produces a flexible reporting view that supports many user-driven questions without constant chart rebuilding.
For static dashboards that do not need interactive filtering, the SORT and FILTER dynamic array functions feed clean source ranges to standard charts. =SORT(FILTER(A2:B100, B2:B100>1000), 2, -1) produces a sorted, filtered list that automatically updates as source data changes. Pointing a chart at the spilled output of these formulas gives you a dynamic chart without the overhead of a PivotTable. The choice between PivotChart and dynamic-array-fed standard chart depends on whether the audience needs interactive filter controls or a curated view that only the author can change.
That single guideline — bars for non-time data, columns for time — produces better-reading reports than any individual chart-formatting choice. The right chart type makes everything else easier; the wrong chart type fights the reader at every step.
Make the type choice deliberately every time.
Bar vs Column Chart
- +Bar charts handle long category labels gracefully
- +Bar charts read naturally for ranked top-N lists
- +Bar charts comfortably fit 5–25 categories on one chart
- +Stacked bar handles parts-of-whole effectively
- +Diverging bar shows positive/negative values around a baseline
- −Bar charts feel less natural for time series data than columns
- −The default Excel bar order needs reversing for descending presentation
- −100% stacked bar can confuse readers if the absolute totals matter
- −Mixing scales on a single bar chart obscures one metric or the other
- −3D bar charts look professional but distort visual proportions
Excel Questions and Answers
About the Author
Attorney & Bar Exam Preparation Specialist
Yale Law SchoolJames R. Hargrove is a practicing attorney and legal educator with a Juris Doctor from Yale Law School and an LLM in Constitutional Law. With over a decade of experience coaching bar exam candidates across multiple jurisdictions, he specializes in MBE strategy, state-specific essay preparation, and multistate performance test techniques.