Why Most Data Slides Look Terrible
You’ve seen this slide before: an Excel chart screenshot pasted directly onto a presentation, with a few lines of text next to it explaining what the numbers mean. The gray gridlines are still there. The colors are Excel’s default blue, orange, and gray.
Your boss looks at it for five seconds and says, “Okay, I’ve seen the numbers.” What they actually understood: “something went up.”
The problem isn’t the data. The problem is that the data wasn’t designed. Keynote has a powerful charting and shape system — more than capable of producing professional-grade data dashboards that rival dedicated analytics tools.
Step 1: Ditch the Excel Default Colors
Keynote’s default chart colors are already better than Excel’s. But if you want to push further:
- Select your chart → Format → Chart Colors
- Skip the default color schemes — go to “Custom”
- Use only 2–3 colors: a primary color (to emphasize data), gray (for reference data), and light gray (for background elements)
A trick that works every time: if you’re highlighting growth, make the growth metric green or blue. Make comparison data gray. The audience’s eye goes to the color first — “Oh, that’s growing.” They don’t even need to read the label.
This is perceptual design at its simplest: color creates hierarchy before anyone reads a single number.
Step 2: Master the “Number Card”
The heart of any data dashboard isn’t the chart — it’s the big number.
Open Google Analytics, Mixpanel, or any analytics tool. What do you see first? That oversized number in the top-left corner: “Daily Visitors 12,847.”
Here’s how to build number cards in Keynote:
- Draw a rounded rectangle — aim for roughly one-third of the page width
- Fill it with light gray (#F5F5F5 works beautifully)
- Stack three lines of text inside: the metric name (small, gray), the number itself (large, bold), and the change rate (small, green for up, red for down)
- Add a small ↑ or ↓ arrow next to the change rate
Put three number cards across the top row, then a trend chart occupying two-thirds of the width below. That’s a complete weekly report page.
Rule: drop the decimals. “83.6 billion” reads far faster than “83.647 billion.” Keep the precise numbers in your notes or appendix. The slide only needs the big figure. Your audience is scanning, not auditing.
Step 3: Kill the Gridlines
This is the single biggest divide between “looks amateur” and “looks professional.”
Excel screenshots almost always carry those gray gridlines. In Keynote:
- Select your chart → Axis → Gridlines → turn them off
- Keep only the X-axis baseline and the leftmost Y-axis line
The chart instantly feels cleaner. If you’re worried people can’t read exact values — annotate key data points with small number labels above them.
Bonus: tighten the gap width on bar charts to around 50%. Visually tighter bars read as more professional. The default wide gaps look like a middle-school science project.
Step 4: Build Progress Bars With Shapes
Keynote’s built-in chart types don’t include progress bars. But you can build them manually with shapes in under a minute:
- Draw two rounded rectangles, stacked on top of each other
- The top rectangle gets your primary color — set its width to the progress percentage
- The bottom rectangle stays light gray at 100% width
Build two side by side — “Target vs. Actual.” This is far more intuitive than a pie chart for showing completion, and you have complete control over the styling. Want rounded ends? Adjust the corner radius. Want a gradient fill? Go ahead. Pie charts can’t give you that flexibility.
Step 5: Add Insight, Not Just Data
The most common dashboard mistake: data with no conclusion.
At the bottom of your slide, add a single line of text — slightly smaller than your body copy, in gray. Write your judgment about what the numbers mean.
Don’t just say “Q3 Revenue: 83.6 billion.” Say “Q3 Revenue: 83.6B ↑18% — third consecutive quarter of accelerating growth.”
Your boss doesn’t need raw numbers from a data dashboard. They need the answer to one question: “So what should I know?”
That one line of insight at the bottom is what separates a data clerk from a strategic thinker. It takes 20 seconds to write and completely changes how your work is perceived.
A Complete Example
Here’s what a finished weekly report dashboard page looks like:
- Top: Page title “This Week’s Core Metrics” (left-aligned, 16pt)
- Row 1: Three number cards (Visitors, Conversion Rate, Average Order Value)
- Row 2: A trend line chart spanning two-thirds of the width, with a “Weekly Highlight” text box on the right
- Bottom: One gray line: “Conversion rate up 2.3pp week-over-week, driven primarily by the homepage redesign”
How long does this take to build? About 20 minutes. But the impact is 10x what you’d get from pasting an Excel screenshot. And once you’ve built it once, you never build it from scratch again.
Save It as a Template
After you’ve made your first dashboard page, save it to Keynote’s master slides. Next week’s report: pick the template, swap in new numbers, done in five minutes.
Here’s how: select the slide → Format → Advanced → Add Slide to Master.
Make a few variants while you’re at it — one for weekly reports, one for monthly, one for campaign performance. You’re building a personal library of dashboard templates that compound in value every time you reuse them.
Design Details That Signal Competence
A few small touches separate a dashboard that looks “thrown together” from one that reads as deliberate:
Use consistent spacing. The gap between your number cards should be identical. Keynote’s alignment guides help — select all three cards, Arrange → Distribute → Horizontally. Pixel-perfect in one click.
Align your chart edges. The left edge of your trend chart should align with the left edge of your leftmost number card. The right edge aligns with the rightmost card. This creates an invisible grid that your audience won’t consciously notice but will subconsciously register as “clean.”
Add subtle dividers. A 1-point horizontal line in light gray between the number card row and the chart row costs nothing but instantly organizes the page into clear zones.
Use one accent color consistently. If growth is green, make every growth indicator on the page the exact same shade of green. If the trend line is blue, make the “up” arrow on each number card the same blue. Color consistency is a cheap way to look intentional.
What About More Complex Dashboards?
Once you’re comfortable with the single-page dashboard, you can scale up. A 3-page dashboard section in a quarterly review might look like:
- Page 1: Executive summary — 3 number cards + 1 trend chart + 1 insight line
- Page 2: Channel breakdown — stacked bar chart showing performance by channel, with a small table of numbers below
- Page 3: Leading indicators — forward-looking metrics with arrows indicating direction
The principles don’t change: big numbers first, clean charts with no gridlines, a written insight on every page. What changes is the depth — you’re giving each dimension of the data its own space to breathe rather than cramming everything onto one slide.
A Note on Data Integrity
One thing dashboards in Keynote can’t do: connect to live data. Your charts and number cards are static — you type in the numbers manually. This means you need a reliable source of truth outside Keynote (your analytics tool, your spreadsheet, your database) and a process for transferring numbers accurately.
For weekly reports, I keep a Numbers spreadsheet with the raw data, then open it side-by-side with Keynote and transfer values. It takes an extra two minutes but eliminates the “wait, is that number right?” anxiety during presentations. If your dashboard will be seen by people who make decisions based on it, build the two-minute cross-check into your workflow.
The Real Job of a Dashboard
The essence of a data dashboard is: filter information for your audience.
Your raw data has a hundred numbers. Your audience needs to know three of them. Your job isn’t to display all one hundred — it’s to pick the three that matter and make them jump into your audience’s eyes.
Keynote gives you the tools. The rest is your judgment about what matters. That’s what makes the difference between a slide deck and a decision-making tool.