360 Secure SkillHub
360 安全技能中心

100 Percent Bars

核心功能是制作100%堆叠条形图,涵盖分析定义、数据整理计算、图表生成及洞察标注全流程。适用于竞品分析、成本结构对比、投资组合构成等场景。输入相关细分数据后,输出含数据表格、图表规格、关键洞察、趋势分析的完整可视化报告,帮助掌握各构成占比及变化趋势。

linuszz
linuszz
热度 45.24
最近更新 2026-05-11 17:34:12
分类:数据依赖:纯提示词应用场景:市场分析 / 报告撰写 / 数据处理

安装技能

复制下面的话术发给你的 Agent,它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill: npx secure-skills-cli add 100-percent-bars
Metadata
name
100-percent-bars
description
Compare composition across segments using 100% stacked bars. Use for competitive analysis, cost structure comparison, and portfolio composition.

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.