100-percent-bars
# 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
1. **Define the analysis** - What are we comparing?
2. **Gather data** - Obtain segment sizes, category shares, revenues
3. **Calculate totals** - Ensure data adds up to 100%
4. **Order segments** - Usually largest to smallest
5. **Create chart** - Excel, PowerPoint, or specialized tool
6. **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.
标签
skill
ai