My Boss Wants a Weekly Dashboard. I Have No Idea Where to Start.

It’s Monday morning. Your manager sends a message:

“Hey — can you put together a dashboard so the team can track progress each week? Something visual. Nothing too complicated.”

Nothing too complicated. Sure.

If you’ve never built a dashboard before, this request can feel genuinely overwhelming. What tool do you use? What should it show? How do you make it update itself so you’re not manually rebuilding it every week?

Let’s break this down into something actually manageable.

Step 1: Figure Out What “Dashboard” Actually Means to Your Boss

Before you open Excel or Google Sheets, ask one clarifying question: “What are the 3–5 numbers you most care about seeing?”

That’s it. That’s the whole question.

Most people asking for a dashboard don’t want 40 charts. They want a quick, honest answer to: Are we on track? Where are we behind?

Common answers you’ll hear:

Revenue vs. target
Tasks completed vs. total
Active users this week
Budget spent vs. remaining
Leads in the pipeline

Once you know the 3–5 numbers, you know what to build.

Step 2: Put Your Raw Data in One Place

The biggest mistake beginners make is building the dashboard and the data storage in the same tab. Don’t do this.

Use two tabs:

“Data” — where the raw numbers live (this is what gets updated weekly)
“Dashboard” — where the charts and summaries live (this should never need editing)

This separation means updating the dashboard becomes as simple as pasting new data into the Data tab. Everything else updates on its own.

Step 3: Keep the Design Dead Simple

Here’s a secret: the best dashboards are boring. They have:

A clear title with the date range
3–5 big numbers at the top (“headline metrics”)
1–2 charts showing trends over time
Maybe a simple table if your boss loves tables

That’s it. Resist the urge to add more. Every extra element is one more thing that can break, confuse, or distract.

Use your company’s colors if you know them. If not, pick one accent color and use it consistently. White background. Done.

Step 4: Make the Update Process Take Less Than 5 Minutes

The whole point of a “weekly” dashboard is that it shouldn’t take hours to update. If it does, you’ve built something fragile.

Test it: paste in one new week of data. Did everything update automatically? If yes, you’re done. If no — there’s a formula somewhere that needs fixing before you hand it off.

The Honest Shortcut

If you’re pressed for time (or you just really don’t want to spend your weekend on this), tools like Sheetglow let you connect your existing spreadsheet and get a dashboard automatically — without any of the formula-wrangling. You share a link, your boss opens it, it’s already updated.

Sometimes the best use of your time is knowing when not to build from scratch.

Your boss asked for “something visual.” You’ve got this — and now you know exactly where to start.