100% stacked column chart in PowerPoint with Ampler Charts - Ampler

100% stacked column chart in PowerPoint with Ampler Charts

A 100% stacked column chart shows composition — each column is scaled to 100% so the segments read as shares of the total, making the mix easy to compare across categories even when the totals differ. Ampler Charts builds it natively in PowerPoint; it is the share-focused cousin of the stacked column, and where category size also matters you can use a Mekko instead.

Quick answer: Click Ampler Charts and select 100% Stacked Column, drag the chart to size, then enter your data — every column is scaled to 100% so the segments show each series as a share.

How to create it

A 100% stacked column chart in Ampler Charts: each column is scaled to 100% so segments show shares

A 100% stacked column chart: each column is scaled to 100% so segments read as shares.

  1. Click Ampler Charts in the ribbon and select 100% Stacked Column from the chart menu.
  2. Left-click and drag the chart to the size you want — or hold Ctrl to place it in a pre-defined position.
  3. Enter your data in the data sheet: each column is normalised to 100%, so the segments show each series as a share of the total.

When to use it

Use a 100% stacked column when only the composition matters and the absolute totals don’t — a mix shift over time, share by segment across categories of similar size. If the total also matters, use a stacked column; if the categories differ in size and that size is part of the story, use a Mekko.

How consultants use it

When the question is about mix rather than magnitude, consultants reach for the 100% stacked column. A few practices apply:

  • Normalise to compare mix: scaling every column to 100% lets you compare composition across categories whose totals differ widely
  • Label as shares and drop the slivers: show the segment percentages and suppress anything under about 5% so the chart stays readable
  • Keep the totals in reach: because a 100% view hides absolute size, add the totals in a callout or note when size still matters to the decision

A 100% stacked column makes a mix argument cleanly — as long as the reader doesn’t also need the absolute totals.

Tips & best practices

  • Label the segments as percentages and hide slivers under about 5%.
  • Keep the stack to around five series so the shares stay legible.
  • Use a Mekko instead when the categories differ in size and that size matters.

What you can add to this chart

Decorators and elements you can layer onto a 100% stacked column chart in Ampler Charts:

Availability

Part of Ampler Charts, included in Ampler for PowerPoint and the Ampler Suite, on Windows desktop PowerPoint.

Frequently asked questions

What is a 100% stacked column chart?

A 100% stacked column chart scales every column to the same height (100%) so the stacked segments show each series as a share of the category total rather than an absolute value.

How do you make a 100% stacked column chart in PowerPoint?

In Ampler Charts, click Ampler Charts, select 100% Stacked Column, drag it to size, then enter your data — each column is normalised to 100%.

What’s the difference between a 100% stacked and a stacked column chart?

A stacked column keeps the real totals as different column heights; a 100% stacked column scales every column to 100% so you compare composition rather than size.

100% stacked column or Mekko — which should I use?

Use a 100% stacked column when the categories are comparable in size and you only need to compare the mix; use a Mekko when the categories differ in size and that size matters (its column widths carry it).

Was this article helpful?

Related Articles

Try free