Sheetzy guide

How to Create a Dashboard in Google Sheets (Step by Step)

By Mani Dazzle, Template maker at Sheetzy · 17 November 2026

What a dashboard actually is

One screen that answers the question 'how are we doing?' without any scrolling or maths. A few headline numbers at the top, a couple of charts underneath, everything updating itself from your raw data.

The mistake most first dashboards make is trying to show everything. A good dashboard shows the numbers that change what you do next - this week's sales against last week's, stock running low, invoices unpaid. Everything else belongs on a different tab.

Step 1: Put your data on its own tab

Every working dashboard in Google Sheets has the same skeleton: one tab holds raw data, a second tab holds the dashboard. Never mix them.

Make the data tab a boring, clean table: one header row, one record per row, dates in a real date format, no merged cells, no blank spacer rows. Five minutes of tidiness here saves an hour of formula debugging later.

Step 2: Summarise with pivot tables or QUERY

Select your data, then Insert > Pivot table, and place it on a third working tab. Group by whatever your dashboard is about - by month, by product, by salesperson - and let the pivot do the totals.

If you prefer formulas, =QUERY(data!A:E, "select A, sum(E) group by A", 1) does the same job and is easier to copy across projects. Either way, the summary layer sits between raw data and charts so the dashboard never touches the data tab directly.

Step 3: Add charts that answer one question each

Click inside your pivot or QUERY output, Insert > Chart, and pick the simplest type that fits: a line for trends over time, bars for comparing categories, a pie only when parts genuinely add to a whole.

Give every chart a title phrased as the answer, not the topic. 'Sales dipped in week 3' beats 'Sales chart'. Two to four charts is the sweet spot; more than that and nobody looks at any of them.

Step 4: Scorecards for the headline numbers

The top row of the dashboard should be three to five big numbers: total sales this month, open orders, low-stock items. In Google Sheets these are just cells with a formula like =SUM(data!E:E) or =COUNTIF(data!C:C,"unpaid"), styled large.

Add a small comparison under each one - against last month, or against target - with a formula-driven arrow or a coloured number. A number without context is decoration.

Step 5: Sparklines and slicers for polish

A sparkline (=SPARKLINE) inside a scorecard cell turns a flat number into a mini trend line - cheap to add, genuinely useful.

Then Data > Add a slicer gives viewers dropdown filters for the whole dashboard: pick a region or a month and every connected chart and pivot updates. This is the feature that makes a Sheet feel like a real dashboard tool.

Step 6: Format it so people actually read it

Hide gridlines on the dashboard tab (View > Show > Gridlines), remove the charts' grey borders, and line everything up on a simple two-column layout. Consistent fonts, one accent colour, generous white space.

Freeze nothing on the dashboard tab - it should fit one screen. If it scrolls, something needs to move to another page.

The shortcut: start from a template

Everything above is worth learning once. But if you need a dashboard this week, starting from a wired-up template beats a blank grid: our Stockroom inventory dashboard tracks stock levels and reorder points out of the box, the Ledger sales tracker turns raw sales rows into weekly totals and charts, and the Blueprint project planner does the same for project timelines.

Paste your data into the data tab and the dashboard tab fills itself in. You can still customise every chart the way this guide describes - the steps are identical, you just skip the blank-page hour.

Quick answers

Can Google Sheets really be used as a dashboard?

Yes. A dashboard tab that reads from a raw data tab with pivot tables, charts and scorecards covers most small-business reporting. It auto-updates the moment new rows land in the data tab, it is free, and it shares like any other Sheet.

How do I make a Google Sheets dashboard update automatically?

Build every chart and scorecard on formulas or pivot tables that point at the whole data column, not a fixed range. When you add new rows at the bottom of the data tab, the dashboard refreshes on its own. Nothing needs to be re-made.

Do I need pivot tables for a dashboard?

Not strictly. SUMIFS, COUNTIFS and QUERY can summarise the same numbers, and QUERY is often easier to maintain. Pivot tables are simply the fastest way to group data without writing formulas, so most builders start there.

What should a good dashboard show?

Three to five headline numbers at the top, then two to four charts that each answer one question. If a chart does not change a decision, remove it. A dashboard nobody reads is usually a dashboard with twelve charts.

Is there a ready-made Google Sheets dashboard template?

Yes - our Stockroom inventory dashboard and Ledger sales tracker already have the data tab, formulas and charts wired together, so you paste in your numbers instead of building from scratch. Links are at the end of this guide.

Keep going

More from Sheetzy

Momentum habit tracker Google Sheets template on a tablet, dashboard with monthly progress

Momentum

Habit Tracker Spreadsheet Template

A full-year habit tracker that keeps score gently: daily ticks, weekly rhythm, monthly rollups and a year view that shows how far you have come.

₹358₹39810% OFF DIRECT
Details

All guides Browse the templates