Sheet2ChartHow to Build a Startup Dashboard in Excel
A startup dashboard in Excel usually needs fewer charts than a department-level one — most founders check the same three or four numbers weekly: MRR, growth rate, burn, and runway. Here’s how to build all four from a simple monthly finance export.
One row per month, not per transaction
Unlike a sales or operations dashboard, a startup dashboard is usually built from monthly rollups, not raw transactions. Keep a Data table with one row per month: Revenue, MRR, Expenses, Cash Balance. If you only have transaction-level exports (bank statements, Stripe payouts), summarize them into monthly totals first with a PivotTable, then feed that into the monthly table.
MRR and month-over-month growth
With MRR as a column in the monthly table, growth is a formula referencing the current and prior row:
=(MRR_ThisMonth - MRR_LastMonth) / MRR_LastMonthShow MRR itself as a simple line chart across months — this is usually the first thing a founder or investor looks at, so put it at the top of the sheet, not buried after other metrics.
Burn rate
Net burn is expenses minus revenue for the month. To avoid a noisy month-to-month number, average it over the trailing 3 months:
=AVERAGE(Expenses[last 3 months]) - AVERAGE(Revenue[last 3 months])Runway
Runway in months is current cash divided by that same average burn:
=CashBalance / AverageMonthlyBurnPut this front and center — it’s the number that determines urgency, and it changes meaningfully month to month even when MRR looks stable.
Layout: headline numbers first, charts below
Unlike the department dashboards above, a startup dashboard rarely needs multiple PivotTables and slicers — the whole thing usually fits on one sheet: a row of 4 headline cells (MRR, Growth %, Burn, Runway) at the top, followed by one or two trend charts (MRR over time, cash balance over time). Keep it to one screen; a founder dashboard that needs scrolling has usually grown past what a weekly check-in needs.
Excel vs. a live founder dashboard
| Excel | Sheet2Chart | |
|---|---|---|
| Monthly rollup from transactions | Manual PivotTable summarization first | Upload the transaction-level export directly |
| Runway calculation | Formula maintained by hand each month | Computed automatically from the uploaded columns |
| ”What changed in burn this month?” | Compare rows manually | Ask the question, see the SQL and values behind the answer |
Excel is a fine fit here for as long as one person (usually the founder) maintains the monthly table by hand. It gets heavier once someone else needs to update it, or the source is transaction-level data that needs summarizing every time.
See the founder use case for a version that skips the manual monthly rollup.
Frequently asked questions
What is the formula for runway in months?
Runway = current cash balance ÷ average monthly net burn (expenses minus revenue) over a recent period, usually the trailing 3 months. Using a single month's burn instead of an average makes runway noisy month to month.
How do I calculate month-over-month MRR growth?
Growth % = (Current month MRR − Previous month MRR) ÷ Previous month MRR. Keep MRR as one row per month in your source table so this is a simple formula referencing the current and prior row, not a manual lookup.
Do I need separate sheets for each metric?
No — for a startup dashboard the whole thing usually fits on one sheet: a row of headline numbers (MRR, growth %, burn, runway) at the top, with one or two trend charts below. Splitting metrics across sheets just adds clicking for a dashboard this size.