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

CODEBLOCK0

Chart Analysis Dimensions

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. 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

Bubble Size

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

Margin Analysis

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. 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