Compare and rank
Butterfly chart (opposing categories)
Places two series on opposite sides of a central category axis for comparison.
- Chart
- Comparison
- Distribution
What it answers
How do two groups compare across shared categories?
- Shape
- Mirrored horizontal bars
- What it shows
- Paired differences and distribution shape.
Example
The question
What do online and store customers value most?
Share of customers naming each reason, online and in store
Illustrative data. It belongs to no company.
When to use it
Use it when
Two-group category comparisons.
Avoid it when
When leftward display is confused with negative values.
How to read it
Compare mirrored lengths for the same central label.
Note
Opposing directions need not represent negative values.
The data you need
- Layout
- Wide paired table
- Fields
- Category: text; First: number; Second: number
- One row is
- One category with two comparable measurements. What is the grain?
- Rules
- Both values need the same unit or a documented transformation. Identify which value is first.
- Optional
- Long alternative: Category,Condition,Value.
- Preparation
- Validate the input grain and missing values. Both values need the same unit or a documented transformation. Identify which value is first.
- Units
- Use the measured variable's stated unit consistently. No denominator is implied unless the value is a rate or proportion.
Worked example
A has first 30, second 45; B has 34 and 40. Mirror positive values. Second exceeds first in both categories.
| Category | First | Second |
|---|---|---|
| A | 30 | 45 |
| B | 34 | 40 |
