How to Create Scatter Plots and Bubble Charts in PowerPoint

Scatter plots reveal relationships between two variables. Bubble charts add a third dimension through size. Together, they're the best tools for showing correlation, clustering, and outliers in business data.

When to Use Scatter Plots

• Exploring correlation — Does spending more on marketing increase revenue?
• Identifying outliers — Which regions or products deviate from the pattern?
• Showing clusters — Do natural groupings exist in the data?
• Comparing performance — Plot efficiency (output vs. input) across teams or products

Anatomy of a Scatter Plot

• X-axis: The independent or explanatory variable
• Y-axis: The dependent or outcome variable
• Each dot: One observation (a customer, product, region, time period)
• Trend line (optional): Shows the general direction of the relationship

Designing Effective Scatter Plots

Data Point Styling

• Use solid circles at 60–80% opacity so overlapping points remain visible
• Size points at 8–12px for standard presentations
• Color-code groups if comparing categories (e.g., regions in different colors)
• Highlight outliers with a contrasting color or larger point size

Axes and Grid

• Label both axes clearly with the variable name and units
• Include light gridlines to help the audience estimate values
• Don't force axes to start at zero if the data clusters in a narrow range — scatter plots are one exception to the zero-baseline rule

Trend Lines

• Add a linear trend line when the relationship is roughly linear
• Display the R² value if the audience is data-literate
• Use a dotted or lighter-weight line so it doesn't overpower the data
• Never add a trend line to data with no meaningful relationship — it misleads

Annotations

• Label notable outliers by name (not all points — just the important ones)
• Add quadrant lines to create a 2×2 matrix (e.g., "high growth / high margin" quadrants)
• Include a brief insight in the title: "Ad Spend Correlates with Revenue, But Top Performers Invest Differently"

Bubble Charts

Bubble charts extend scatter plots by encoding a third variable as the bubble size.

When to Use Bubbles

• Three variables matter. For example: x = market size, y = growth rate, bubble size = your market share
• Portfolio analysis. The BCG matrix is essentially a bubble chart with quadrant labels
• Geographic or categorical comparison. Each bubble represents a country, product, or business unit

Bubble Design Rules

• Size encodes area, not diameter. A value twice as large should have a bubble with twice the area, not twice the diameter
• Maximum 15–20 bubbles before the chart becomes cluttered
• Include a size legend showing what a specific bubble size represents
• Use transparency (40–60% opacity) so overlapping bubbles remain readable
• Label the 3–5 most important bubbles directly; let the rest speak through position and size

Common Bubble Chart Pitfalls

• Too many bubbles overlapping → reduce dataset or aggregate
• Bubble sizes too similar → the third variable isn't adding value; drop it
• No size legend → the audience can't interpret bubble size

Quadrant Analysis

Both scatter plots and bubble charts become more powerful with quadrant framing:

1. Draw vertical and horizontal reference lines at meaningful thresholds (median, target, benchmark)
2. Label each quadrant with a strategic interpretation
3. Color-code dots or bubbles by quadrant

Example quadrants:

• Top-right: "Stars" (high on both dimensions)
• Top-left: "Invest" (high potential, low current performance)
• Bottom-right: "Maintain" (strong current, low growth potential)
• Bottom-left: "Review" (weak on both dimensions)

Common Mistakes

Next: Waterfall and Funnel Charts