What is a 100% stacked column chart?

A 100% stacked column chart normalizes every column to the same height, so each one represents 100%. Segments within a column show their share of that total as a percentage, not an absolute value. It answers a different question than a standard stacked column chart — not 'how big is the total,' but 'how is the mix changing.'

100% stacked column chart vs regular stacked column chart — which should I use?

A regular stacked column chart shows both the total and the composition — column height changes as the total grows or shrinks. A 100% stacked column chart removes the total from the picture entirely and shows only proportion, every column is the same height. Use 100% stacked when you want the audience to focus purely on share shift, without total growth or decline competing for attention.

When should I use a 100% stacked column chart?

Use it when the story is about mix, not size. Market share by competitor over time, channel split of revenue, budget allocation by category across years — anywhere the question is 'is this segment's share growing or shrinking' rather than 'is the total growing.' It is especially useful when the categories being compared have very different total sizes, since the 100% normalization puts them on equal footing.

Can I import data from Excel or Google Sheets?

Yes. Import from Excel or Google Sheets directly into the editor. First column is the category or time period. Each additional column is one segment. AECharts rescales every column to 100% and calculates the percentages automatically — you don't need to convert your data to percentages yourself.

Do I need to enter percentages, or can I use raw numbers?

Use raw numbers. Paste revenue, headcount, or any absolute value per segment and AECharts converts each column to a percentage of its own total automatically. There's no need to pre-calculate shares in a spreadsheet first.

Can I switch back to a regular stacked column chart?

Yes. Standard stacked and 100% stacked are both modes of the same chart type. Switch between them with one click in the editor without re-entering your data.

What export formats are available?

Every chart exports ready to use in PowerPoint or Google Slides, or as an image for reports.

Is there a free plan?

Yes. AECharts is free to start. Pro plan starts at $12/month billed annually and removes the watermark. No credit card required.

100% Stacked Column Chart Maker

A 100% stacked column chart normalizes every column to the same height so the audience sees proportion, not size. Segments show each category's share of the total as a percentage. It is the right chart when the story is about mix shifting over time, not the total itself growing or shrinking.

100% stacked column chart example showing proportional segment mix over time

How to Create a 100% Stacked Column Chart

Select the 100% stacked column chart type

Open the AECharts editor, it loads directly into 100% stacked mode. Browse the template explorer on the right panel to apply a visual style instantly.

Enter your data

Click "Edit Data" in the top-right corner. The first column holds your time periods or categories. Additional columns are your segments — enter raw values, AECharts converts each column to percentages automatically. Import directly from Excel or Google Sheets, or upload a CSV or Excel file.

Adjust styling

Use the top menu bar to assign a color to each segment. Switch back to standard stacked mode with one click if you need absolute totals instead. Adjust bar width, stroke, labels, axes, and grid options. Every change previews instantly.

Export

Export ready for PowerPoint or Google Slides. Every chart drops directly into PowerPoint and Google Slides.

100% Stacked Column Chart Features

Automatic Rescaling

Paste raw numbers. AECharts rescales every column to 100% and calculates each segment's share automatically — no manual percentage math.

One-Click Mode Switch

Toggle between standard stacked (absolute totals) and 100% stacked (proportion only) without re-entering data.

Percentage Labels by Default

Segment labels default to percentages so the chart is readable without a separate legend lookup.

Consistent Segment Colors

Each segment keeps the same color across all columns, so audiences can track a segment's share through time.

Easy Data Import

Import from Excel or Google Sheets. First column is the category or time period; each additional column is one segment.

Export Straight to PowerPoint

Export ready for PowerPoint or Google Slides. Every chart drops directly into PowerPoint and Google Slides.

When to Use a 100% Stacked Column Chart

Use a 100% stacked column chart when total size differences between periods or categories would otherwise distract from the real story: how the mix is shifting.

Market Share by Competitor

Each column = one year. Segments = competitors. Every column reaches 100%, so share gains and losses are readable at a glance, independent of overall market growth.

Revenue Channel Mix

Each column = one quarter. Segments = direct, partner, and online channels. Shows whether the business is shifting toward or away from a channel, regardless of total revenue trend.

Budget Allocation Over Time

Each column = one fiscal year. Segments = spending categories. Makes it obvious which categories are claiming a growing share of the budget as the total budget itself changes.

Survey Response Shift

Each column = one survey wave. Segments = response options (agree, neutral, disagree). Normalizes for different sample sizes across waves so only sentiment shift shows.

Headcount Mix by Function

Each column = one quarter. Segments = Engineering, Sales, G&A. Shows whether the org is shifting more technical or more commercial as it scales, independent of total headcount.

Customer Segment Composition

Each column = one cohort or period. Segments = customer tiers or plans. Highlights mix shift toward higher-value segments even while total customer count moves around.

100% Stacked vs Standard Stacked vs Clustered Column

All three use vertical columns, but each answers a different question.

100% Stacked Column

Best for: Showing how a mix or share is shifting, independent of total size.

Strength: Removes total-size differences so proportion is the only variable the audience reads.

Use when: Market share, channel mix, budget allocation, response mix.

Standard Stacked Column

Best for: Showing the total and its composition together.

Strength: Column height carries real information — total growth is visible alongside mix.

Use when: Revenue mix by quarter, cost structure, P&L composition.

Clustered Column

Best for: Precise comparison of individual segment values across categories.

Strength: Each segment starts from zero, making exact differences easy to read.

Use when: Comparing two or three metrics side by side, before/after analysis.

AECharts supports all three. Switch modes without re-entering data to find the right format for your story.

Frequently Asked Questions

Create Your 100% Stacked Column Chart Today

Import your data, pick a template, and export in under two minutes. Free to start, no credit card required.

Other chart makers

Line Chart Maker Pie Chart Maker Horizontal Bar Chart Maker Scatter Plot Maker Waterfall Chart Maker Sankey Chart Maker Funnel Chart Maker Gauge Chart Maker Waffle Chart Maker Radar Chart Maker Treemap Maker Heatmap Maker Pareto Chart Maker Mekko Chart Maker Gantt Chart Maker