In Excel for Microsoft 365 on Windows, put category labels in column A and three numeric series in columns B through D, select the data, then choose Insert > Insert Column or Bar Chart > 2-D Column. This guide compares three reusable layouts—clustered, stacked, and 100% stacked—and explains when each makes sense, how to format it, and how to save a chart template. It is for people who need a clear comparison or composition chart they can update with new data rather than rebuild each month.
1. Clustered Column Template for Side-by-Side Comparisons
A clustered column chart places each series beside the others within a category, so use this template when the reader needs to compare separate values directly rather than see them as parts of one total; a practical worksheet layout is Month in column A, Actual in B, Plan in C, and Prior Year in D, with one month per row. For example, a sales report can show January actual sales of 42,000, plan of 45,000, and prior-year sales of 39,000 as three neighboring columns, making it easy to see both the shortfall to plan and the year-over-year gain without mentally subtracting stacked segments. Select the entire contiguous range, including the header row, and choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column; then use Chart Design > Add Chart Element > Chart Title > Above Chart to add a meaningful title, and give the chart a try when categories have enough room for three readable columns each.
2. Stacked Column Template for Totals and Components
A stacked column chart combines series into a single column per category, with each colored segment representing part of the total, so it suits data where values are additive, such as monthly orders by product line or department spending by cost type. Set up the worksheet with Month in A and three components—Hardware, Software, and Services—in B through D; if January contains 18, 12, and 10 orders, respectively, the column height communicates 40 total orders while the segment colors show how that total is made up. Select the labels and values, then choose Insert > Insert Column or Bar Chart > 2-D Column > Stacked Column, keep each component in the same color across every month, and consider data labels when the individual segment values matter; this layout is worth choosing when readers need to see both the total and the changing mix, but not when the series are unrelated measures such as revenue, customer count, and satisfaction score.
3. 100% Stacked Column Template for Share of Total
A 100% stacked column chart scales every category to the same height and divides that height according to each series’ share, which makes it useful for comparing proportions across categories even when the underlying totals differ substantially. For instance, a channel report can place Month in A and Web, Store, and Partner sales in B through D, then show whether Web’s share is rising over the year; the source values can remain in dollars, because the chart expresses each month as a full 100% column, but the chart no longer communicates whether one month had 50,000 dollars of sales and another had 500,000. Create it with Insert > Insert Column or Bar Chart > 2-D Column > 100% Stacked Column, use a consistent series order and color key, and explain the percentage basis in the title or axis labels; choose this template when mix is the question, and pair it with a separate total-value table or chart if absolute size also matters.
How to Choose
Start by asking what comparison the chart needs to make. If people must compare the value of each series, such as Actual versus Plan versus Prior Year, a clustered column chart is usually the most direct choice because each bar starts at the same baseline. If each series contributes to a meaningful total, as product categories contribute to total units sold, use a stacked column chart. If the key question is how the proportions change while total size is intentionally set aside, use 100% stacked columns. These are different analytical views, not merely different color treatments, so choosing the right one matters more than polishing the chart style.
Check whether the numbers can legitimately be added before selecting either stacked option. Revenue by product line, counts by department, and budget components can often be summed when they share the same unit and time period; a conversion rate and a dollar amount cannot sensibly form one stacked total. Negative values also need care: Excel can draw negative segments below the horizontal axis, but mixed positive and negative components make a normal part-to-whole reading harder. If the series use different units or scales, consider separate charts rather than putting them into one column chart.
Next, consider the number of categories and series. Three series are manageable in a clustered chart when there are a modest number of categories, but many months or long labels can make the bars narrow and the axis crowded. In that case, shorten labels, show fewer time periods, or consider a line chart if the main purpose is to follow a trend. Stacked columns become difficult to compare for middle segments because those segments do not share a common baseline; readers can compare the bottom series and the total more easily than the middle series. Keep the series order fixed across charts so readers do not have to relearn the legend.
Use a clean source range: one header row, one category per row, numeric values in the measure columns, and no merged cells or blank separator rows inside the data. Including the header row when inserting the chart helps Excel use the names in the legend. If you expect to add records, format the range as an Excel table using Home > Format as Table; charts based on a table can expand as rows are added, though you should confirm the chart’s data range when adding new series or changing the table structure. Keep units explicit in the title or axis—for example, Revenue (USD thousands)—and avoid relying on color alone to distinguish values when labels or a clear legend can help readers.
Finally, think about reuse. A saved chart template stores chart formatting and chart type in a .crtx file, not the worksheet data or a full workbook layout. After creating and formatting a chart, select it and choose Chart Design > Save as Template, then give the file a useful name; to use it later, go to Insert > Recommended Charts > All Charts > Templates and select the saved design. The template will not fix a mismatched data structure automatically, so keep a separate workbook template if you also need a prebuilt table, notes, or reporting instructions. In Excel for Mac, chart commands are on the Chart Design tab as well, though tab placement and dialog layout can differ; Excel for the web has a more limited chart-template workflow, so desktop Excel is the better choice for saving and managing .crtx templates.
Frequently Asked Questions
Does a three-column chart need exactly three worksheet columns? Not necessarily. For three plotted series, use four worksheet columns: one category-label column plus three value columns. If you mean three worksheet columns total, use one label column and two value columns; Excel will plot two series. The important thing is to include a clear category column and one numeric column for every series you want to compare.
How do I change a clustered chart to a stacked chart? Select the chart, open Chart Design > Change Chart Type, choose Column, and select Stacked Column or 100% Stacked Column. Excel keeps the same source data but changes how the series are drawn. Check the result afterward: stacked columns only make sense if the series can be added, while 100% stacked columns are intended to compare proportions rather than totals.
Can I reuse the design with different data? Yes. Save the chart as a .crtx file through Chart Design > Save as Template, then select that design from Insert > Recommended Charts > All Charts > Templates when creating another chart. The template retains chart styling and type, but it does not contain the original worksheet’s layout or data. For a recurring report, keep a workbook template with the data table and instructions as well.
Why are my months or series displayed in the wrong direction? Excel may interpret rows and columns differently from the way you intended, especially if the data layout is not a simple header row followed by category rows. Select the chart and choose Chart Design > Switch Row/Column to change which data is treated as categories and which is treated as series. Confirm that the horizontal axis shows the categories and the legend lists the intended measures before distributing the chart.
What should I do when category labels or bars look crowded? Reduce the number of categories shown at once, shorten labels, or make the chart wider; for very long category names, a bar chart may be more readable than a column chart. For three clustered series, a large category count leaves little space for each bar, and a stacked chart can also become hard to interpret if there are too many segments. Avoid shrinking text until it is difficult to read, and show only the labels that help answer the chart’s main question.
Final Thoughts
The best Excel column-chart template depends on whether you want to compare separate values, show components of a total, or compare percentage shares. Use clustered columns for side-by-side measures, stacked columns for additive totals, and 100% stacked columns for composition. Keep the data table simple, label units clearly, and save a .crtx chart template when you want to reuse the visual design; that combination makes updates faster without obscuring what the chart actually says.
Related
- Excel Lagging and Not Responding? Causes and Fixes
- Excel PivotTable Tips for Clearer Reports
- Excel Not Responding and Unsaved? Recover Your Work
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Make a Histogram Start at 0 in ExcelTo make histogram bins start at 0 reliably in Excel, create bin intervals beginning at 0, count the…
- Excel Waterfall Chart: Show a Total at the EndTo show a final total in an Excel waterfall chart, select the last bar, right-click it, and choose…
- Excel Pie Chart With Breakdown of Slices: How to Make OneTo show the detail behind one slice in Excel, create a Pie of Pie or Bar of Pie…
- How to Choose the Right Trendline in ExcelChoose an Excel trendline by matching its shape to the pattern and likely relationship in your data, then…
- Make Charts in Excel the Same Size: A Step-by-Step GuideTo make several charts the same size in Excel for Microsoft 365 on Windows, select their chart borders…
- Excel Chart Series Name: Change It and Fix Series LabelsTo change an Excel chart series name in Microsoft 365 for Windows, select the chart, choose Chart Design…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.