Stacked Bar for Market Share — Competitive Share Shift Over Time
A market share stacked bar chart partitions each period's column into competitor segments ($Share_{i,k} = V_{i,k} / \sum_k V_{i,k}$) to reveal both total market expansion and competitive share capture.
Tip: Paste Excel or Google Sheets rows (Ctrl+V / ⌘V) directly into any cell.
| # | Label | ||||
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 | |||||
| 6 |
Market share of vendor k in period t: MS_{t,k} = (Rev_{t,k} / sum_j Rev_{t,j}) * 100%. Basis points gained: bps = (MS_{t,A} - MS_{t-1,A}) * 100.
Chart Design & Use-Case Tips
- 01Market share of vendor k in period t: MS_{t,k} = (Rev_{t,k} / sum_j Rev_{t,j}) * 100%. Basis points gained: bps = (MS_{t,A} - MS_{t-1,A}) * 100.
- 02Enter percentages that sum to 100% per row for a 100%-stacked market share view, or enter raw revenue ($M) per vendor to show both market growth and share shift simultaneously.
- 03Place your primary company in Series A at the bottom of the stack so its share trajectory is measured from the flat zero axis.
- 04Group smaller fragmented players into Series C ('Rest of Market') to keep the visual focus on the primary duel.
Frequently Asked Questions
Should my rows sum to 100% or use actual dollar revenues?+
If each row sums to 100, every column has uniform height (100% stacked bar), emphasizing pure share shift. If you enter dollar revenues, column height also shows total addressable market (TAM) expansion.
Why put our own brand in Series A?+
Series A rests directly on the horizontal x-axis baseline, making even a 2-percentage-point gain immediately visible without baseline offset.
Can I export this for an investor pitch deck?+
Yes, use the 300-DPI PNG or Vector SVG export to drop directly into Keynote, PowerPoint, or Google Slides.