FIELD GUIDE 02 · DASHBOARDS

A dashboard is an argument, not a chart collection.

Use Claude for Excel to choose the KPIs that belong on the first screen, build the summary tables behind them, and write the takeaway the numbers are trying to tell.

6dashboard prompts
8KPI slots
1screen
Operating reviewOne screen · updated monthly
MRR$482K+8.4%
Net retention112%+3 pts
Runway17 mo-1 mo
12-month trendSource: workbook

What makes a dashboard fail

Most dashboards answer every question except the one that matters. Start with the decision, then choose the KPI, the chart, and the sentence that explains it.

Claude can draft the KPI tree, aggregate the table, and write the commentary. The design decision stays with you: what belongs on the first screen, and what can wait.

01

KPI sprawl

Twenty metrics on one screen means no one knows where to look.

02

Charts without a takeaway

A chart that does not change a decision is decoration.

03

Definitions drift

If finance and the dashboard define churn differently, the meeting starts with a fight.

Dashboard prompts for Claude in Excel

Pick the prompt that matches the decision on the screen. Copy it into Claude in Excel and adapt the cell references to your workbook.

01LAYOUT

Design a KPI Dashboard

Recommend a KPI dashboard layout for this workbook. Choose 6-8 KPIs, map each to a cell or range, suggest card titles, and explain the order. Use a 3x2 or 4x2 grid that fits one screen.

Choose 6-8 KPIs that fit one screen.

02TABLE

Build a Dashboard Summary Table

Create a summary table that aggregates the selected data by month and region, with current, prior, variance, and variance percentage columns. Explain the formulas and the sorting logic.

Create the table behind the cards.

03VARIANCE

Create a Variance Dashboard

Build a variance dashboard comparing actuals to budget. Include absolute and percentage variance, conditional formatting rules, and a short list of the largest drivers. Explain how to update it each month.

Show actual vs budget and the biggest drivers.

04CHARTS

Choose the Best KPI Chart

Recommend the best chart type for each KPI in this workbook. Explain why, and warn about chart types that distort the comparison. Include a short layout suggestion for a dashboard.

Match the chart to the decision.

05TRENDS

Add Trend Indicators

Add month-over-month and year-over-year trend columns to this KPI table. Use arrows or plus and minus signs, and explain the formula for each column. Keep the table easy to scan.

Make direction visible at a glance.

06NARRATIVE

Write Dashboard Commentary

Write a concise executive commentary for this dashboard. Summarize the three most important movements, the likely drivers, and one recommended action. Keep it under 150 words.

Turn movement into a three-sentence takeaway.

How to build a dashboard in Excel with Claude

Design the decision first. The layout, formulas, and commentary follow from the question the dashboard has to answer.

  1. 01

    Define the decision

    Write the question the dashboard must answer. If it cannot change a decision, it is not a KPI.

    Deliverable: Decision statement
  2. 02

    Map the KPI tree

    Link each KPI to a cell, owner, definition, and refresh cadence.

    Deliverable: KPI dictionary
  3. 03

    Build the table

    Create the summary table and variance columns before styling anything.

    Deliverable: Summary table
  4. 04

    Write the takeaway

    Draft a three-sentence commentary: what moved, why, and what to do next.

    Deliverable: Executive note

The one-screen checklist

A dashboard is finished when someone can make a decision without asking a follow-up question.

One decision per screen

The dashboard answers a specific operating question.

Definitions match finance

Every KPI has one owner, formula, and refresh cadence.

Every chart has a takeaway

The title states the insight, not just the metric.

Values trace to cells

A reviewer can follow every number back to the source.

Refreshes have an owner

Someone is responsible for the monthly update.

Print and mobile checked

The first screen works beyond your desktop.

Dashboard FAQ

Answers for the spreadsheet team building the first version.

How many KPIs should a dashboard have?

Aim for 6-8 KPIs on the first screen. Everything else belongs in a detail view, a tooltip, or a follow-up workbook.

Can Claude build the charts?

Claude can recommend chart types, build summary tables and formulas, and write the commentary. Excel charts and formatting are still applied in the workbook; review the result.

How do I keep KPI definitions consistent?

Put definitions in one KPI dictionary, use persistent Instructions in Claude, and assign an owner for each metric.

Can Claude write the executive commentary?

Yes, if you provide the period, the comparison, and the three largest movements. Keep the final edit human.

Does this work for a one-page operating review?

Yes. Design for the decision, not the data volume. The first screen should answer what changed and what to do next.

Can Claude update the dashboard every month?

Claude can help with the table and commentary each cycle, but the refresh process and data sources still need an owner.

THE NEXT MOVE

Take the prompts into your workbook.

Start with the six prompts above, then explore the full library for formulas, dashboards, audits, and forecasts. Download the PDF for a printable field guide.