Weighted Column

Compare profitability and market share using variable-width column charts. Use for competitive positioning, product portfolio analysis, and pricing strategy.

Security Scan

This is an instruction-only skill for producing weighted/variable-width column charts and competitive analysis; its requirements and instructions are coherent with that purpose and it does not request extra credentials, installs, or system access.

Purpose & Capability

Name and description match the SKILL.md content: guidance for creating weighted/variable-width column charts and strategic analysis. The skill requests no binaries, env vars, or configs that would be unrelated to charting/analysis.

Instruction Scope

The instructions are high-level and describe the expected steps (define axes, gather data, calculate metrics, create chart, analyze). They do not instruct the agent to read system files, environment secrets, or call unexpected endpoints, but 'gather data' is deliberately vague — the agent will need to rely on the user's provided data or its existing connectors.

Install Mechanism

No install spec or code files are provided (instruction-only). Nothing will be written to disk or fetched at install time, minimizing installation risk.

Credentials

The skill declares no environment variables, credentials, or config paths. No disproportionate access to secrets or unrelated services is requested.

Persistence & Privilege

Skill is not always-enabled and is user-invocable. Model invocation is allowed (the platform default) but there is no indication the skill requires permanent or elevated privileges.

Assessment

This skill is coherent and low-risk: it only contains high-level instructions for creating and interpreting weighted-column charts and requests nothing sensitive. Before using, provide the specific dataset you want analyzed (revenue, margins, market share) and avoid pasting any sensitive or proprietary credentials into prompts. Because the instructions are general, confirm what data sources the agent will use (manual upload vs. connected services) so it doesn't attempt to pull unspecified data from other connectors. If you need code or automated chart generation, prefer a skill that includes audited code or an install spec from a trusted source.

Weighted Column Chart

Metadata

• Name: weighted-column
• Description: Variable-width column chart with profitability analysis
• Triggers: weighted column, bubble chart, profitability, market share

Instructions

Create weighted column chart to analyze the relationship between profit margin, market share, and size.

Framework

The Weighted Column Chart

                         MARKET SHARE (X-axis)
                         │
                         │      Market Size (Bubble Area)
                         │
        ┌───────────────┬───────────┬───────────┐
        │               LARGE         □ LARGE     □ MEDIUM   □ HIGH      ◆️ HIGH      ◆️ MEDIUM    └──┬─────┐
        │               MEDIUM         ◢️ MEDIUM   ◑ MEDIUM   ◇️ MEDIUM    ◆️ HIGH     └──┬─────┐
        │               SMALL          ⚠️ SMALL    ◔️ MEDIUM   ◑️ LOW      ◇️ MEDIUM    └──┬─────┬───┘
        │               NICHE         ● NICHE     ● HIGH      ● HIGH     ◇️ HIGH      ◆️ MEDIUM    └──┬─────┬───┐

Chart Analysis Dimensions

Dimension	What it shows
Bubble Size	Company valuation/profitability
Bubble Position	Relative to competitors and growth
Bubble Color	Profit margin (Red=loss, Yellow=breakeven, Green=profit)
Y-axis	Return on Sales (ROS)

Visual Variations

• Standard Weighted Column - Profit vs market share
• Variable Width Column - Company performance by profitability
• Revenue Matrix - Alternative visualization with revenue by competitor
• 4-Quadrant Chart - Four-quadrant analysis (Stars, Cash Cows, Question Marks, Dogs)

Output Process

1. Define axes - What goes on each dimension?
2. Gather data - Revenue, margins, market shares
3. Calculate metrics - ROS for each company
4. Create chart - Choose appropriate visualization
5. Analyze position - Identify quadrants and implications
6. Add insights - Competitive positioning, strategic implications

Output Format

## Weighted Column Analysis: [Industry]

### Company Positioning Matrix

| Company | Revenue | Margin | ROS | Market Share | Position | ROS Rank | Margin Rank |
|-----------|---------|---------|-----------|-----------|----------|-----------|
| [Comp A] | $X M | X% | Z% | 1.2 | Top Left | ⭐ | ⬆️⬇️ | - |
| [Comp B] | $X M | Y% | Z% | 0.8 | 2.3 | Top Left | ⭐ | ⬆️⬇️ | - |
| [Comp C] | $X M | Y% | Z% | 1.0 | 2.1 | Top Left | ⭐ | ⬆️⬇️ | - |
| [Comp D] | $X M | Y% | Z% | 1.2 | 2.4 | Top Right | ⭐ | ⬆️⬇️ | - |
| [Industry Avg] | $X M | Y% | Z% | 0.8 | 3.2 | Bottom Right | ⭐ | ⬆️⬇️ | ⭐⭐ |

---

### Bubble Size

| Company | Bubble size represents $Y M valuation (NPV) |

---

### Margin Analysis

| Company | Margin | Position | ROS Rank |
|-----------|----------|-----------|
| [Comp A] | X% | Top Left | ⭐ | ⬆️⬇️ | - |
| [Comp B] | Y% | Top Left | ⭐ | ⬆️⬇️ | - |
| [Comp C] | Z% | Bottom Left | ⭐ | ⬆️⬇️ | - |

### Competitive Analysis

**Strengths:**
- [Comp A] has strong profit margins and market leadership
- [Comp B] has average margins but growing market share
- [Comp C] has high volume but low margins (volume player)
- [Comp D] is smaller but has high profitability (niche player)

**Weaknesses:**
- [Comp B] lacks scale and faces pricing pressure
- [Comp D] has limited market access
- [Comp C] needs to reduce costs to compete

**Opportunities:**
- Consolidation opportunities between volume and profitable players
- Premium positioning for niche players
- Geographic expansion opportunities

---

### Strategic Implications

1. **[Analysis]**
- Current portfolio over-reliance on volume players
- Vulnerability to pricing pressure from volume competitor
- Need to improve margins or reduce costs

---

### Visualization Tips

- Bubble size can represent company valuation
- Use consistent color coding (red=loss, yellow=break-even, green=profit)
- Consider both ROS and market share when positioning
- Add trend lines to show movement over time
- Annotate key insights about competitive dynamics

## References

- Porter, Michael. *Competitive Strategy*. 1980.
- Various competitive analysis and portfolio management sources