Design a One-Page Manager Dashboard in Excel or Google Sheets
Get a buildable one-page dashboard plan with a layout grid, a spec for each tile (metric, chart, filter, source range, formula) and numbered build steps.
You getLayout grid, tile spec table with columns and build steps
Prompt
Act as a reporting analyst who builds one-page management dashboards in Excel and Google Sheets.
Your job: design a dashboard layout I can build directly from my data. Before designing anything, ask me these questions in one message and wait for my answers:
1. Who reads this dashboard, and how often?
2. Which 2-3 decisions should it help them make?
3. What columns does my data have, and what sheet name and range is it in? (I can paste the headers and a few rows.)
4. Excel or Google Sheets, and which version?
Rules:
- Every tile must support one named decision. Drop any metric that does not.
- Use a maximum of 8 tiles, all fitting one landscape page at 100% zoom.
- For each tile, give the exact formula or pivot setup using my real sheet and column names.
- Choose chart type by purpose: trend = line, comparison = bar, part of whole only with 5 or fewer slices. No 3D or gauge charts.
- Put the most important number in the top-left tile.
Output format:
1. Layout grid: a table showing each tile's position as a cell range (e.g., B2:E6).
2. Tile spec table with columns: Tile #, Metric, Decision it supports, Chart type, Filter/slicer, Source range, Formula or pivot setup.
3. Build steps: numbered, 10 steps maximum.
4. Shared filters and refresh steps.
End with one line listing your assumptions about the data and any metric you could not calculate from the columns given.Example output
Tips and common edits
Why this works
- Asking about readers and decisions first stops the dashboard from filling up with metrics nobody acts on.
- Requiring real sheet names, ranges and formulas turns a vague mockup into something you can build in an hour.
- Fixed chart rules and an 8-tile cap keep the page readable and ban misleading 3D and gauge charts.
Use this when a manager wants a weekly or monthly view and you have the raw data ready. Paste your column headers and a few sample rows into ChatGPT, Claude or Gemini when it asks.
Common edits
- Change the tile cap to 4 for a phone-friendly executive summary.
- Ask for Google Sheets QUERY formulas instead of pivot tables.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Pick the Right Excel or Google Sheets Chart for the Point You Want to Make
Get one recommended chart tied to your message, exact build steps for Excel or Google Sheets, a takeaway title, and one chart to avoid with the reason.
Build an Employee Shift Schedule and Hours Tracker with Overtime in Excel
You get a ready-to-build spreadsheet layout with formulas for overnight shifts, unpaid breaks, weekly hours per employee and highlighted overtime.
Build an Inventory Tracker Spreadsheet with Reorder Points and Low-Stock Alerts
You get exact columns, copy-ready reorder-point formulas, a status column and conditional formatting that highlights items to reorder now or this week.
Build an Invoice Template in Excel or Google Sheets with Automatic Totals
You get a cell-by-cell invoice layout with exact formulas for line totals, discount, tax, due date, and a duplicate-proof invoice numbering system.
Set Up Data Validation Rules That Stop Bad Entries in a Shared Excel Sheet
You get a column-by-column validation plan with allowed values, custom formulas, input and error messages, plus a helper formula that flags rows already holding bad data.
Turn a Spreadsheet Analysis into a Three-Finding Executive Summary Email
Get a short executive email with three numbered findings backed by your data, one clear recommendation, one open question, and a note on data gaps.