Excel Vertical Stacked Bar Chart: Create and Format

Charts & pivot tables · Updated November 19, 2026

To make a vertical stacked bar chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and each component in its own data column, select the range, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Excel calls a vertical chart a column chart; its chart type named Stacked Bar is horizontal.

A stacked column chart shows both the total for each category and how its component values contribute to that total. It is useful for comparing a small number of categories across several parts, such as monthly sales by product or a department’s budget by expense type. Choosing the right chart type and laying out the source data clearly are the keys to getting a chart that is readable and accurate.

Why Excel calls it a stacked column chart

In Excel’s chart terminology, bars run horizontally and columns run vertically. People often say vertical stacked bar chart when they mean stacked column chart, but selecting the chart type called Stacked Bar will produce horizontal bars. To match the usual meaning of vertical stacked bar, use Stacked Column.

In a stacked column chart, each category has one column divided into colored segments. The height of each segment represents one series value, and the full column represents the sum of those values. For example, a column for April might contain separate segments for online, store, and wholesale sales. Its total height shows April sales overall, while its colors show the channels’ contributions.

Do not confuse Stacked Column with 100% Stacked Column. The first shows actual values and totals; the second scales every column to 100%, emphasizing proportions rather than size. These options answer different questions, so the right choice depends on whether the absolute totals matter.

Arrange the worksheet data

Excel needs a category field and one numeric column for each component you want to stack. Put the category labels in the first column, series names in the top row, and values in the body of the table. Keep the table rectangular, with one header row and no blank rows or columns splitting the data.

For example, a small sales table could look like this:

  • Column A: Month, with January, February, and March in the rows below.
  • Columns B through D: Online, Store, and Wholesale as the column headings.
  • The cells beneath each heading: the corresponding sales values for each month.

When the table is selected, Excel generally uses the first column for category labels and each remaining column as a separate series. A series becomes one colored segment in every category’s column. Use meaningful, concise headings: Excel usually uses them in the legend, and unclear headings make the chart harder to interpret.

Use numeric values for the measures. Text such as a currency symbol typed into each cell can cause Excel to treat values as text; apply a number or currency format instead. If the source is an Excel Table, the chart can more easily incorporate rows added to that table later, although you should still check the chart range and appearance after changing the data.

Create the vertical stacked chart

  1. Select the category labels, series headings, and all values, including the header row and category column. For a nonadjacent selection, charting may require extra adjustment, so a contiguous table is simpler.
  2. On the ribbon, choose Insert > Insert Column or Bar Chart.
  3. Under 2-D Column, select Stacked Column. Avoid the Stacked Bar option if you want vertical columns.
  4. Excel inserts the chart on the worksheet. Select it and use the Chart Design and Format tabs to adjust the chart elements and appearance.

If Excel assigns the categories and series in the wrong direction, select the chart and choose Chart Design > Switch Row/Column. This is useful when Excel has treated each row as a series instead of treating each data column as a series. Check the legend and category axis after switching; the intended result is one column per category and one colored segment per component.

You can also make a chart through the recommended charts interface, but choosing the chart type directly from Insert is more explicit. In Excel for Mac, the chart is also inserted from the Insert tab; the names or placement of chart controls can vary slightly by release. Excel for the web has chart insertion and formatting tools too, though some advanced formatting controls are more limited than in the Windows desktop app.

Choose between stacked, clustered, and 100% stacked

A stacked column chart works best when the reader needs to see total size and composition together. It is particularly effective when there are only a few series and the category totals are important. For example, it can show the total number of support requests per month while separating requests by issue type.

  • Stacked Column: Use it when both component amounts and overall totals matter. Segment values remain on the same numeric scale, but only the bottom segment shares a common baseline across categories.
  • 100% Stacked Column: Use it to compare each category’s composition as a percentage. Every column has equal height, so differences in total size disappear.
  • Clustered Column: Use it when comparing the individual values of several series across categories is more important than showing a combined total. The series sit side by side rather than on top of one another.

A common misconception is that stacking always makes component comparisons easier. It does not. The bottom series starts at zero, so its values are easy to compare between categories. The next series starts at the top of the first segment, and higher segments start at changing positions. Their lengths still represent values, but comparing their endpoints by eye is more difficult. If precise comparisons between every component are central, a clustered chart or a line chart may be clearer.

Format for readability

A chart should make the data easier to understand, not simply reproduce every worksheet detail. Give it a descriptive title that identifies the measure and period, such as Monthly Sales by Channel. If the units are not obvious, explain them in the vertical value axis title or chart title. Avoid relying on color alone when the chart may be printed in grayscale or viewed by people with color-vision differences.

To add or change chart elements, select the chart and use Chart Design > Add Chart Element. Depending on the element, you can add an axis title, data labels, a legend, or gridlines. Data labels can show values inside segments, but putting a label on every segment can overcrowd a chart with many categories or small values. A useful practice is to add labels only when they can be read without overlap, and to format them consistently with the data.

Use a limited set of distinct colors and keep each series’ color consistent across categories. Place the legend near the chart when space allows, and order the series so the legend is easy to follow. The order of series in the source data influences the order of segments and legend entries; if the stack is unintuitive, adjust the series order through Chart Design > Select Data and the series ordering controls in the dialog.

For a 100% stacked chart, percentage labels are often more informative than raw values, but Excel does not automatically make every label display a calculated share in every chart setup. You may need to calculate percentages in worksheet cells and use those cells as labels, where supported by the chart’s data-label options. Keep the underlying values available so readers can distinguish a proportion from an absolute amount.

Common problems and what to check

If the chart is horizontal, the likely issue is that Stacked Bar was selected instead of Stacked Column. Reinsert the chart or change its type using Chart Design > Change Chart Type, then choose Stacked Column under 2-D Column.

If the legend shows categories or the x-axis shows series names, check whether Excel interpreted rows and columns in the opposite way from what you intended. Use Chart Design > Switch Row/Column, or select Chart Design > Select Data to inspect the chart data range, series names, and category labels. Also verify that the selected range includes the correct header cells and does not include unrelated totals.

Unexpected gaps or missing segments can result from blank cells, text values, or errors in the source range. Confirm that the component cells contain numbers and that the chart references the full data table. A zero is different from a blank: zero is a valid value and contributes no height, while a blank can be handled differently depending on the chart’s settings and data arrangement.

Negative values need particular care. Excel can plot negative data below the zero axis, so a stack containing both positive and negative values may be harder to interpret than an all-positive stack. Do not treat the full column height as a straightforward total when positive and negative components offset each other. Consider showing positive and negative measures separately or choosing a chart form that makes the sign and comparison clearer.

Limits and useful alternatives

Stacked columns are not ideal for every dataset. Many series create narrow, hard-to-distinguish segments, and many categories make labels crowded. If the purpose is to compare a large number of component values precisely, consider separate small charts, a clustered column chart, or a table with conditional formatting. If the important story is a trend for each series rather than composition of totals, a line chart may be more suitable.

A PivotChart can be useful when the data is a large, structured list with fields such as date, region, product, and sales channel. Create a PivotTable first, summarize the values by the relevant fields, then insert a PivotChart and select a stacked column type. This allows filtering and grouping without manually rebuilding the summary table. It does not remove the need to check how the chart is aggregated: a sum, count, or average can tell a different story.

For reports that are shared or printed, consider whether a chart is still legible at its final size. A chart that looks clear on a large monitor can become difficult to read in a narrow document or on a phone. Removing unnecessary borders, limiting the number of series, and using a concise title can improve clarity without changing the data.

Frequently Asked Questions

How do I make a vertical stacked bar chart in Excel?
Select the data, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Excel calls vertical charts columns; Stacked Bar is the horizontal chart type.

What is the difference between stacked column and 100% stacked column?
A stacked column displays the actual component values and total heights. A 100% stacked column scales every category to the same height, making relative shares comparable while hiding differences in total size.

How do I change the order of the stacked segments?
Select the chart and choose Chart Design > Select Data. In the dialog, select a series and use the move controls to change its order. The series order affects the stack and the legend, so check both after making a change.

Can a stacked column chart show data labels?
Yes. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a placement. Labels may overlap when segments are small, so inspect the result and remove or reposition labels if necessary.

Why does my stacked chart show the wrong categories?
Excel may have interpreted rows as series and columns as categories, or the selected range may include the wrong cells. Try Chart Design > Switch Row/Column, then use Chart Design > Select Data to confirm the series names and category-label range.

Quick checklist before sharing

  • Confirm that you used Stacked Column for vertical orientation.
  • Check that each category has the intended component values and that totals are meaningful.
  • Verify the legend, category labels, units, and chart title.
  • Review data labels and colors at the size where the chart will be read.
  • Choose 100% stacked only when proportions matter more than absolute totals.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.