100% Bars
Metadata
- Name: 100-percent-bars
- Description: Stacked bar charts for visualizing segment composition
- Triggers: 100% bars, segmentation, composition analysis, market share
Instructions
Create 100% stacked bars to show how different categories contribute to total.
Output Process
- Define the analysis - What are we comparing?
- Gather data - Obtain segment sizes, category shares, revenues
- Calculate totals - Ensure data adds up to 100%
- Order segments - Usually largest to smallest
- Create chart - Excel, PowerPoint, or specialized tool
- Add annotations - Key insights, totals, sources
Output Format
## 100% Bars: [Analysis Type]
### Data Table
| Segment | 2023 | 2024 | 2025 | % Change |
|-----------|---------|----------|--------|--------|
| [Segment 1] | $X M | $Y M | +X% | 📈 |
| [Segment 2] | $X M | $Y M | +X% | 📈 |
| [Segment 3] | $X M | $Y M | +X% | 📈 |
| [Segment 4] | $X M | $Y M | +X% | 📈 |
| **Other** | $X M | $Y M | -X% | 📈 |
| **Total** | **100%** | $X M | $Y M | 📈 |
### Chart Specifications
**X-Axis:** Market size (revenue, units, customers)
**Y-Axis:** Segment composition (% of total)
**Source:** [Where data came from]
**Time Period:** [Year range]
---
### Total Breakdown by Category
| Category | 2023 | 2024 | 2025 | % Change |
|-----------|---------|----------|----------|--------|
| Products | $X M | $Y M | +X% | 📈 |
| Services | $X M | $Y M | -X% | 📈 |
| Other | $X M | $Y M | -X% | 📈 |
| **Total** | $X M | $Y M | 📈 |
---
### Composition Chart
100% Stacked Bar by Year
---
### Key Insights
**Insight 1:** [Analysis]
- [Observation about market dynamics]
- [Implication for strategy]
**Insight 2:** [Analysis]
- [Observation about product mix]
- [Implication for portfolio balance]
**Insight 3:** [Analysis]
- [Observation about geographic spread]
- [Implication for distribution strategy]
---
### Historical Trends
| Metric | 2023 | 2024 | 2025 | Trend |
|--------|---------|----------|----------|
| Market Size | X M | Y M | ↗ | ↗ |
| Growth Rate | 3% | 2% | ↓ |
## Tips
- Use 100% to make comparison meaningful
- Order segments consistently across time periods
- Focus on trends, not just composition
- Show both absolute and percentage changes
- Annotate strategically important shifts
References
- Tufte, Edward. The Visual Display of Quantitative Information. 2001.
- Few, Stephen. Show Me the Numbers. 2012.
微信扫一扫