Yes—but Excel does not offer a one-click chart type that reliably places a stacked bar and a regular, unstacked bar beside each other for every category. The clearest solution is usually to build two matching charts and align them; a single mixed chart is possible as a custom workaround, but it takes more setup and can produce confusing axes or spacing.
What “stacked next to non-stacked” means
A stacked bar combines multiple series into one bar for each category. For example, a bar for each region might be divided into sales from two product lines. A non-stacked, or clustered, bar shows a separate bar for each series instead of adding the series together. People asking for both often want one combined bar showing a meaningful total and another bar showing a separate measure for the same category.
Imagine a table with regions, Product A sales, Product B sales, and a sales target. You might want the two product sales to form one stacked bar, with the target shown as a separate bar beside it. The target is not another component of sales, so stacking it with the product values would imply a total that does not make sense. That is the key reason to keep the two kinds of bars distinct.
Excel uses “bar” for horizontal bars and “column” for vertical bars. The same chart-design problem applies to both orientations, but the Insert menu names the chart types accordingly: Stacked Bar for horizontal bars and Stacked Column for vertical ones.
What Excel can and cannot do natively
Excel for Microsoft 365 on Windows has built-in stacked bar and clustered bar chart types, and it can create combo charts that assign different chart types to different series. However, the standard chart gallery does not provide a dependable preset called “stacked beside clustered.” Even when a combo chart lets you assign stacked and clustered bar types, Excel may group or overlay series in a way that does not create the neat side-by-side pair you intended.
That distinction matters: choosing two chart types is not the same as controlling where each bar group sits. Bar placement depends on series grouping, axes, and chart spacing. A secondary axis can help separate series groups, but it can also create an extra scale or make bars overlap. For a report that must be easy to read, two aligned charts are often more predictable than forcing everything into one plot area.
If your goal is simply to compare the stacked composition with a separate value across the same categories, two charts can look like one coordinated display. If a single plot area is essential—for example, because the graphic must fit into a dashboard tile—a custom combo chart may be worth trying, with careful checks of its axes and bar positions.
Choose the layout before building the chart
Decide what comparison the reader should make. If the stacked total and the standalone value use the same unit and scale, two side-by-side charts with matching value-axis bounds can make direct comparison straightforward. If one measure is a percentage and the other is a count, or their magnitudes differ greatly, do not force them onto a shared scale simply to make the bars line up.
- Use two aligned charts when dependable placement, clear labels, or different scales matter most.
- Try one custom combo chart when a single chart object is required and you can verify that the series are grouped and positioned correctly.
- Use a regular clustered chart instead when the components do not need to communicate a meaningful total.
- Consider a 100% stacked chart only when the purpose is to compare each component’s share of its category, not the absolute totals.
Also check whether the standalone value is conceptually comparable to the stacked total. A target, forecast, or benchmark may be better represented by a line or reference marker than by a bar, especially when readers need to see how far the total is from the benchmark.
Reliable method: make two aligned charts
Suppose your worksheet has Region in column A, Product A in B, Product B in C, and Target in D, with headers in row 1 and one region per row below. Build the stacked chart from the region and product columns, then build the clustered chart from the region and target columns. For the second chart, a small helper range containing just Region and Target can make selection and editing easier.
- Select the region labels and the component columns, including their headers. On Windows, if the columns are not adjacent, select the first range, then hold Ctrl while selecting the other range.
- Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Choose Stacked Column instead if vertical bars are more suitable.
- Select the region labels and the standalone measure, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar.
- Move the charts next to each other, make their outer dimensions similar, and align their plot areas as closely as possible. Add one shared descriptive heading with a text box if a single title helps explain the pair.
- When both measures use the same unit, set matching minimum and maximum bounds on both value axes. Select an axis, right-click it, choose Format Axis, and edit the bounds under Axis Options. Check that the tick marks also support a fair comparison.
For horizontal charts, category order can appear reversed depending on the chart and axis settings. If the first region appears at the bottom in one chart but at the top in the other, select the category axis and use Format Axis > Axis Options > Categories in reverse order to make the order consistent. Hide one set of repeated category labels only after confirming that the bars still line up visually.
Separate charts are not automatically linked in every way. If you filter or rearrange data, confirm that both charts still show the same categories in the same order. Keeping the charts based on the same source table—or using Excel table columns as their sources—reduces the chance that one chart silently omits a new category.
Advanced option: try a single custom combo chart
For one chart object, begin with the same data layout and insert a chart that includes all relevant series. Select the chart, then choose Chart Design > Change Chart Type > Combo. In the custom combo controls, assign the component series to a stacked bar type and the separate measure to a clustered bar type if those choices are available for the chart. Excel may offer a secondary-axis checkbox for a series; use it only when you understand why a second scale is needed and intend to label it clearly.
After applying the chart, inspect the result rather than assuming the series are side by side. In some configurations, the standalone bar overlaps the stack, the category positions do not align, or a secondary axis makes the scale hard to interpret. The Format Data Series options, including Series Overlap and Gap Width where available, can affect spacing, but they do not guarantee a clean clustered-stacked layout in every workbook or Excel version.
If the combo dialog does not offer the needed bar types, or if changing the series settings makes the display less clear, return to the two-chart method. A workaround that requires hidden duplicate series, invisible bars, or unexplained axes may be fragile when someone edits the data. A chart should make the relationship understandable without requiring the reader to reverse-engineer its construction.
Prepare the data so the visual is honest
Each row should represent the same category across the component series and the standalone measure. Check that all component values are additive and use the same unit. If Product A and Product B are parts of total revenue, stacking them communicates that their sum is meaningful. If one series is a rate and another is a dollar amount, they should not be stacked.
Use clear column headings, avoid blank category labels within the data, and decide how missing values should be represented before charting. A blank cell, a zero, and an unavailable value can communicate different things. In particular, replacing an unknown measure with zero makes the chart claim that the value is known to be zero.
For a 100% stacked bar, Excel normalizes each category’s component values to 100 percent. That makes relative shares easier to compare but removes the original total sizes from the bar lengths. If readers need to compare both composition and total size, use a standard stacked chart or provide the totals separately rather than expecting a 100% chart to show both.
Formatting and common problems
- Bars overlap: In a mixed chart, check which axis each series uses and whether Excel has grouped the series as intended. Do not fix overlap by adding a secondary axis unless the axis has a clear purpose.
- Different scales distort the comparison: Matching axes is useful for equal units, but it is inappropriate when the measures are fundamentally different. Label separate scales prominently or use separate charts with clear axis titles.
- Categories appear in a different order: Check category-axis settings in both charts. A reversed category axis can make otherwise correct charts look mismatched.
- Labels are hard to read: Use concise category names, consistent colors for the same components, and direct data labels only where they improve interpretation. A legend should distinguish components, not make the reader guess which bar is the separate measure.
- The chart changes after new rows are added: Check the chart’s source data. Converting a source range to an Excel table can help charts include new table rows, but still verify the displayed categories and series after editing.
Color should reinforce meaning: keep Product A and Product B colors consistent, and give the standalone series a distinct but coordinated treatment. Avoid using color alone to communicate an important distinction; labels, a legend, or a subtitle should make clear that the separate bar is not part of the stack.
When another chart type is better
If the standalone value is a target against the stacked total, a line can be more legible than a second bar. A line across categories can act as a benchmark while the stacked bars show composition. In a combo chart, however, the line may need a secondary axis if its scale differs, so label that axis and avoid suggesting that unlike units are directly comparable.
If the component parts are not important, use a clustered bar chart to compare each measure separately. If the central message is each category’s share of a total, use a 100% stacked bar. If readers need exact differences between values, a table alongside a simpler chart can be clearer than a complicated mixed chart. The right choice depends on the question being answered, not on whether Excel can technically draw a particular arrangement.
Frequently Asked Questions
Can Excel put a stacked bar and a clustered bar in one chart?
Excel can assign different chart types to series in a custom combo chart, but the result may not place the two bar groups neatly side by side. Test the series grouping and axes; use two aligned charts if the layout is unreliable.
How do I put a stacked bar chart next to a regular bar chart?
Create a Stacked Bar chart from the component series and a Clustered Bar chart from the separate measure, using the same categories. Position the chart objects side by side and match category order and value-axis bounds when the units are the same.
Is a clustered bar chart the same as a non-stacked bar chart?
Usually, yes in this context. A clustered bar displays series as separate bars rather than combining their values into one stacked bar. Excel’s chart-type name is “Clustered Bar.”
Should the stacked total and the separate bar use the same axis?
Use the same scale when the values share a unit and direct comparison is meaningful. If the measures use different units or scales, do not imply that equal bar lengths mean equal quantities; use separate, clearly labeled scales or separate charts.
Why are my bars overlapping instead of appearing side by side?
Excel may be plotting the series in different axis groups or applying a series-overlap setting that puts bars together. Review the chart type and axis assignment in Chart Design > Change Chart Type, then inspect Format Data Series. If adjusting them does not produce a clear arrangement, use two charts.
Related
- Excel Shortcut to Move Between Sheets in a Workbook
- Excel Shortcut to Insert a Table Row on Windows and Mac
- Excel Shortcut to Insert a Row Every Other Row in a List
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Create a Chart Audit Form in Excel: Step by StepCreate a chart audit form in Excel by listing each audit as one row, adding consistent Yes/No/N/A fields…
- Access Power Pivot Add-In: Use Access Data in ExcelYou cannot add Power Pivot to Microsoft Access: Power Pivot is an Excel add-in, not an Access feature.…
- Excel Histogram Limits: Bin Counts, Data, and WorkaroundsExcel does not have one universal histogram limit that applies to every workbook: the practical ceiling depends on…
- Google Sheets: Add a Vertical Line to a ChartGoogle Sheets does not offer a one-click setting for an arbitrary vertical reference line in a chart. For…
- Excel Trendline Only Some Data Points? Fix ItIn Excel, a trendline is normally calculated for an entire chart series, not for individually selected points. To…
- Does Excel Online Have Sparklines? Setup and LimitsYes. Excel for the web—often called Excel Online—can create and format sparklines, the small charts that fit inside…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.