Data Visualization Techniques
Choosing the Right Chart
Effective visualization matches the chart type to the data story you want to tell.
Chart Selection Guide
- Bar Chart: Compare categories (Revenue by Product: 5G $8M, Devices $5M, Enterprise $10M)
- Line Chart: Show trends over time (Monthly revenue: Jan $2M → Dec $4M)
- Pie Chart: Show parts of a whole (Market share: Us 35%, Competitor A 25%, Others 40%)
- Scatter Plot: Show correlation (Deal size vs Sales cycle: larger deals = longer cycles)
- Heat Map: Show patterns in matrix (Best time to call: Tue-Thu, 10 AM-2 PM shows high connect rate)
- Funnel Chart: Show conversion stages (1000 Leads → 150 Qualified → 50 Opps → 15 Won)
Bar & Column Charts
When to Use
- Compare categories: Revenue by territory, Cases by priority, Campaigns by response rate
- Grouped bars: Compare multiple metrics (This Year vs Last Year revenue by quarter)
- Stacked bars: Show composition (Total revenue = Products + Services + Subscriptions)
Best Practices
- Sort bars: Descending order by value (highest revenue product first)
- Limit categories: Max 10 bars (if more, show Top 10 + "Others")
- Start Y-axis at zero: Don't truncate (misleading visual)
- Use color intentionally: Green = positive, Red = negative, Gray = neutral
Example: Opportunity Count by Stage
- Prospecting: 45 opportunities (blue bar)
- Qualification: 32 opportunities
- Proposal: 18 opportunities
- Negotiation: 12 opportunities
- Closed Won: 8 opportunities (green bar)
Line Charts
When to Use
- Time series: Revenue over 12 months, Daily SR volume, Weekly win rate
- Multiple lines: Compare trends (This Year vs Last Year vs Target)
- Identify patterns: Seasonality (Dec spike in sales), Anomalies (Mar drop in leads)
Best Practices
- Consistent intervals: Daily, Weekly, Monthly (not mixed)
- Limit lines: Max 5 lines (too many = spaghetti chart, unreadable)
- Label endpoints: Show final value on line (Dec: $4.2M)
- Use markers sparingly: Only for small datasets (< 20 points)
Example: Monthly Revenue Trend (12 months)
- Blue line: Actual revenue (starts at $2.5M in Jan, ends at $4.1M in Dec)
- Dashed line: Target (straight line at $3.5M)
- Green shaded area: Above target months (Sep-Dec)
- Insight: Strong Q4 performance, exceeded target by 17%
Pie & Donut Charts
When to Use
- Part-to-whole: Market share, Budget allocation, Lead sources
- Limited slices: 3-6 categories (max 8)
- Percentage emphasis: Show proportions clearly (30% of revenue from Product X)
Best Practices
- Start at 12 o'clock: Largest slice first, clockwise descending
- Label percentages: Show % and value (35% - $8.2M)
- Use contrasting colors: Easy to distinguish slices
- Avoid 3D: Distorts perception, stick to 2D
Example: Revenue by Product Line
- Enterprise Solutions: 45% ($10M) - Blue
- 5G Plans: 33% ($7.4M) - Green
- Devices: 22% ($5M) - Orange
- Total: 100% ($22.4M)
Advanced Visualizations
Funnel Charts
Use Case: Sales pipeline, Lead conversion, Customer journey
- Stage 1: 1,000 Leads (100% - widest)
- Stage 2: 250 Qualified (25% conversion)
- Stage 3: 80 Opportunities (32% conversion)
- Stage 4: 24 Closed Won (30% win rate)
- Insight: Bottleneck at Lead → Qualified (75% drop-off, needs improvement)
Scatter Plots
Use Case: Correlation analysis (e.g., Deal Size vs Sales Cycle)
- X-Axis: Deal Size ($10K - $1M)
- Y-Axis: Sales Cycle (10 - 180 days)
- Each Dot: One opportunity
- Trend Line: Shows positive correlation (larger deals = longer cycles)
- Insight: $500K+ deals average 120 days (need executive engagement earlier)
Heat Maps
Use Case: Territory performance, Call connect rates by time/day
| Time | Mon | Tue | Wed | Thu | Fri |
|---|---|---|---|---|---|
| 9-11 AM | 72% | 85% | 88% | 82% | 68% |
| 1-3 PM | 55% | 78% | 75% | 73% | 52% |
| 4-6 PM | 42% | 58% | 61% | 59% | 38% |
Insight: Best call times are Tue-Thu, 9-11 AM (dark green = high connect rate)
Color & Design Principles
Color Usage
- Semantic Colors: Green = success/positive, Red = alert/negative, Yellow = warning, Blue = neutral/info
- Accessibility: Colorblind-friendly palettes (avoid red/green only, add patterns/labels)
- Contrast: Dark colors on light background (readable)
- Consistency: Same color means same thing across all charts (don't switch "blue = revenue" to "blue = cost")
Design Best Practices
- Clear Labels: Axis titles, legend, chart title (no ambiguity)
- Remove Clutter: No unnecessary grid lines, borders, 3D effects
- Readable Fonts: 12pt+ for labels, 14pt+ for titles
- White Space: Don't cram charts together (breathing room)
- Highlight Key Data: Bold the important bar, callout box for insight
Interactive Features
Drill-Down
- Click bar: "Northeast $6.8M" → Shows breakdown by rep
- Click rep: "Rep A $2.1M" → Shows individual opportunities
- Breadcrumb: "Company > Northeast > Rep A" (easy to navigate back)
Tooltips
- Hover over data point: Pop-up shows details
- Example: Hover on "Dec" → "December 2024: $4.2M revenue, 147 deals, 32% win rate"
- Keep concise: 3-5 key metrics (not overwhelming)
Filtering
- Date slider: Change from "This Quarter" to "Last 6 Months" → Chart redraws
- Category checkboxes: Uncheck "Devices" → Chart excludes device data
- Dynamic updates: All charts on dashboard update together (coordinated filtering)
Export & Sharing
- Image Export: PNG/SVG for presentations (high resolution, 300 DPI)
- PDF: Multi-page report with all charts
- PowerPoint: Each chart as editable slide (can tweak colors/labels)
- Email: Schedule weekly chart email to executives (automated)
- Embed: iFrame chart in intranet page (live updates)