A stacked bar chart Excel template is a reusable chart setup that shows how several series contribute to a total for each category. In Excel for Microsoft 365 on Windows, enter categories in the first column and series in the following columns, select the data, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar; you can save the finished chart as a template or keep it in a workbook with sample data.
What an Excel stacked bar chart template includes
“Template” can mean either a starter workbook or a saved chart design. A starter workbook typically contains a clearly labeled data table and a chart linked to it, so you can replace the example values with your own. A chart template stores visual settings such as chart type, colors, fonts, and formatting. It does not provide a universal data model or automatically make every new dataset suitable for stacking.
A standard stacked bar chart uses horizontal bars. Each bar represents a category, and its colored segments represent the values of separate series within that category. For example, a monthly support report might have one bar per month and segments for email, phone, and chat requests. The full bar represents the month’s total, while each segment shows one channel’s contribution.
This chart is useful when readers need to compare totals and see their composition at the same time. It is less effective when the main question is how one series changes across categories: only the first series shares a common starting point, so segments later in the stack are harder to compare precisely.
Arrange the source data before inserting the chart
Excel needs a rectangular table with one category field and one column for each series. Put the category names in the first column, series names in the top row, and numeric values in the cells below each series name. Include the headers when selecting the range so Excel can use them for the legend and axis labels.
- Use a meaningful label for every category, such as a month, department, or product.
- Use concise, distinct series names; these become the legend entries.
- Keep the data area continuous. Avoid blank rows or columns inside the range, merged cells, and totals that are not part of the chart.
- Use numbers for values. Text that looks like a number, such as a value imported with an apostrophe, may be treated as zero or omitted.
- Check that categories are in the order you want readers to scan. The order in the worksheet may appear reversed on a horizontal bar chart.
For example, a table with columns for Month, Email, Phone, and Chat can chart monthly request totals by channel. If the purpose is to compare each channel’s share rather than the number of requests, use a 100% stacked bar chart instead. Keep a separate, unstacked total column out of the selected range unless you intend it to appear as another series.
Create a stacked bar chart in Excel
- Enter the data and headers in a worksheet, with categories down the first column and series in separate columns.
- Select the complete table, including the headers. If the data is in a formal Excel table, clicking within it can make it easier to select the whole source range.
- On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Choose Stacked Bar, not 100% Stacked Bar, if you need to preserve actual totals.
- Review the result. If Excel has assigned categories and series in the wrong direction, select the chart and choose Chart Design > Switch Row/Column.
- Add a descriptive chart title and check that the category labels, legend, and value axis make sense for the data.
Excel for Mac has a similar Insert chart workflow, though ribbon placement and wording can vary slightly by release. Excel for the web also supports common chart creation and formatting, but some advanced chart-template and formatting options may be unavailable or differ from the desktop app. If a command is missing, open the workbook in the desktop version of Excel.
Choose between stacked and 100% stacked bars
A regular stacked bar chart preserves the size of each value. Bar lengths can therefore show which categories have higher totals, and the segments show how those totals are divided. It works well for workloads, units sold, or expenses when both the total and the component amounts matter.
A 100% stacked bar chart scales every bar to the same full length. The segments then show each series as a proportion of that category’s total. This makes relative composition easier to compare, but hides differences in total size. A category with 10 items and one with 1,000 items can each fill the same width, so include another way to show totals if scale matters.
Use a standard stacked chart when amounts are meaningful; use a 100% chart when proportions are the central question. Neither version is ideal if readers need to compare several middle segments across many categories. A clustered bar chart, small multiples, or a table may communicate those comparisons more clearly.
Format the chart so it is easy to read
Start with the question the chart should answer, then remove elements that do not help answer it. A useful title states the subject and, where relevant, the time period or unit. The value axis should show a sensible scale and units. If the values are dollars, percentages, hours, or thousands of items, make that clear rather than relying on readers to infer it.
- Use a consistent, distinguishable color for each series. Avoid relying only on subtle differences between similar shades.
- Keep the legend in a position where it does not crowd the bars. If the chart has many series, consider whether a simpler chart would be easier to interpret.
- Use data labels selectively. Labels on every small segment can overlap; labels on a few important values or a separate total label may be more legible.
- Set the category order deliberately. In a horizontal bar chart, the first worksheet category may display at the bottom. Select the category axis, open Format Axis, and use Categories in reverse order if you want the first category at the top.
- Use gridlines sparingly and check that text remains readable at the size where the chart will be viewed or printed.
For accessibility, do not communicate series identity through color alone. Use clear legend names and sufficient contrast, and add alternative text to the chart where the workbook will be shared with people using assistive technology. A brief description should explain what the categories and segments represent, not merely say that the object is a chart.
Save the chart as a reusable template
Once the chart looks right, select it and choose Chart Design > Save as Template. Excel saves a chart template file with the .crtx extension. To use it later, create or select a chart and open Chart Design > Change Chart Type; look for the Templates category and choose the saved design. Exact dialogs can vary by Excel release, and a template saved on one computer may need to be made available on another.
A .crtx file preserves chart formatting and type, not the worksheet data or a live connection to the original workbook. For a reusable report that includes the table, chart, notes, and possibly formulas, save a separate workbook as an Excel template (.xltx) instead. Replace the sample values in a copy of that workbook, then confirm the chart’s data range still covers the intended cells. Keep sample data realistic but clearly marked so it is not mistaken for current results.
Common problems and how to fix them
- The chart shows the wrong series or categories: Use Chart Design > Switch Row/Column. If that does not correct it, choose Chart Design > Select Data and review the chart data range, series names, and category labels.
- Some values do not appear: Check for numbers stored as text, blank cells, filtered rows, or a selected range that ends too early. Confirm the source range in Select Data.
- The first category is at the bottom: This is a normal axis-order effect for horizontal bars. Change the category-axis setting Categories in reverse order if a top-to-bottom reading order is preferable.
- The chart is cluttered: Reduce the number of series or categories, shorten labels, or remove unnecessary data labels and gridlines. A chart with many thin segments is difficult to decode even when the data is correct.
- Totals do not match expectations: Check whether all intended series are included and whether a total column has accidentally been included as an additional segment. Also verify the source values and units.
- Negative numbers look confusing: Stacked charts place positive and negative values on opposite sides of a zero baseline. This can be appropriate for gains and losses, but the visual total is not interpreted like a simple all-positive stack. Consider a diverging bar chart or separate positive and negative views when that distinction matters.
When another chart or template is a better choice
Use a clustered bar chart when comparing the exact value of each series across categories is more important than displaying the total composition. Use a 100% stacked bar chart when proportions matter and totals do not. A line chart is often a better fit for a time series with a small number of measures, especially when trends are the main focus. A table may be clearer than any chart when exact values are more important than visual patterns.
If you want a ready-made workbook rather than a saved chart style, Excel’s template gallery and Microsoft’s template offerings may provide starting points, but availability can depend on the version, account, and connected services. Review any downloaded workbook before entering data: verify its formulas, chart range, units, and sample values. A template should save setup time, not replace checking whether the chart matches the question.
Frequently Asked Questions
Is there a built-in stacked bar chart template in Excel?
Excel includes stacked bar chart types, and you can save a formatted chart as a reusable .crtx template. A workbook containing a sample table and a chart is a separate kind of template; you can create one and save it as an .xltx file.
How do I add total labels to a stacked bar chart?
Excel can add data labels to chart series, but a standard label shows a series value rather than automatically providing a clean overall total in every layout. You can add totals through a carefully prepared helper series or place labels in worksheet cells, but check that the method remains correct when the source data changes and that extra labels do not misrepresent the chart.
Can I make a stacked bar chart with percentages?
Yes. Choose 100% Stacked Bar when creating the chart to show each series as a share of its category total. The chart normalizes each category to 100%, so it does not show which category has the largest absolute total.
What is the difference between a stacked bar and a stacked column chart?
A stacked bar chart displays horizontal bars, with categories along the vertical axis. A stacked column chart displays vertical columns, with categories along the horizontal axis. Both show series contributions stacked into a total; choose the orientation that best accommodates your labels and comparisons.
Will the chart update when I change the data?
A chart normally updates when values in its source range change. If you add new rows or columns outside that range, they may not appear automatically. An Excel table can help a chart’s source expand as you add records, but always check the selected data range after changing the table layout.
Can I use the same chart template with different data?
Usually, yes, if the new data has a compatible structure and you apply the saved chart design to a chart based on that data. The template supplies formatting, not the right labels or source range automatically, so inspect the series, categories, units, and chart type after applying it.
Related
- Real Estate Excel Template for Cash Flow: Build One
- Real Estate Excel Budget Template: Setup and Costs
- Randomize Numbers in Excel Without Duplicates
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Pivot Tables: How to Edit and UpdateTo change a pivot table in Google Sheets, click a cell inside it to open the Pivot table…
- Excel Dashboard Visualization: How to Design and BuildExcel dashboard visualization means presenting important measures and trends in a compact, interactive worksheet using elements such as…
- Excel Histogram Format Options: Bins, Labels, and StyleIn Excel for Microsoft 365 on Windows, select a histogram and use Format Axis to change its bins,…
- Excel Line Chart With Data Labels: Add and Format ThemTo add data labels to an Excel line chart, select the chart and choose Chart Design > Add…
- How to Insert a Clustered Column Chart in ExcelTo insert a clustered column chart in Microsoft Excel for Microsoft 365 on Windows, arrange your categories in…
- Create a Gantt Chart in Excel with a Pivot Table?Yes—but a PivotTable does not have a built-in Gantt view. In Excel for Microsoft 365 on Windows, summarize…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.