Design an Excel dashboard table that is easy to read and share

A useful Excel dashboard table answers a specific question without making readers decode the workbook. For a quarterly revenue report, that question might be: Which regions missed target, and did revenue rise or fall?

Build a compact comparison table for that question, keep its source data separate, and prepare a clean export if readers need to explore the figures on a public page.

Separate the data from the dashboard

Use three worksheets with different jobs:

• Data: the records used for calculations, with one header row and consistent column types.
• Dashboard: the reader-facing summary, including the reporting period, units and comparison table.
• Publish: a reviewed, values-only table containing only information approved for public release.

Do not put merged titles, blank separator rows or handwritten subtotals inside the source data. Microsoft recommends tabular data without blank rows or columns and consistent types for PivotTable sources. An Excel table also lets newly added rows enter the PivotTable source when you refresh it. Microsoft’s source-data guidance explains these requirements.

For a small example, paste this fictional dataset into Data!A1:D4. Each row represents one region; all revenue figures are USD. Treat the previous quarter as Q1 2026 and the current quarter as Q2 2026.

Region	Previous quarter revenue USD	Current quarter revenue USD	Current quarter target USD
North	100000	120000	125000
South	80000	92000	90000
West	120000	108000	120000

Select a cell in the data, choose Home → Format as Table, select a restrained style, confirm the range, mark that the table has headers and select OK. These are Microsoft’s documented table-creation steps.

Put the comparison in the column order

On the Dashboard sheet, use the title Regional revenue — Q2 2026, followed by Fictional example; USD; growth compared with Q1 2026. Arrange the summary like this:

Region	Revenue USD	Target USD	Target attained	Quarter-on-quarter growth
West	108,000	120,000	90.0%	−10.0%
North	120,000	125,000	96.0%	20.0%
South	92,000	90,000	102.2%	15.0%

The order moves from identity to amount, benchmark and interpretation. Sorting by target attainment ascending puts the largest proportional shortfall first—not necessarily the largest dollar shortfall. Sorting by revenue would answer a different question: which region generated the most revenue?

On the Data sheet, add two calculated columns:

• Target attained: enter =C2/D2 in E2.
• Quarter-on-quarter growth: enter =(C2-B2)/B2 in F2.

Fill the formulas through row 4 and format the results as percentages with one decimal place. Use these results in the dashboard summary, keeping each region’s amounts and rates together when sorting.

These formulas assume positive, nonzero denominators. If the previous revenue or target is zero or missing, flag the rate as unavailable and explain why; do not substitute a misleading 0%.

A PivotTable is useful when you need to summarize many records into these regional amounts. Start with the clean-data PivotTable workflow, then calculate rates from the summarized amounts rather than averaging record-level percentages.

Use formatting to guide reading

For this dashboard table, use:

• A clear header: bold text and a single contrasting fill.
• Consistent alignment: region labels left; numbers right.
• Consistent precision: whole dollars and one decimal place for rates.
• Light separation: subtle row banding or horizontal rules, not a heavy border around every cell.
• Enough column width: wrap long headers instead of shrinking the text.

Reserve emphasis for the reader’s task. Here, highlight target attainment below 100% and negative growth. Conditional formatting applies rules based on cell values and works on Excel tables and ranges. Microsoft’s conditional-formatting guide documents that behavior.

Keep the numbers visible. If you add a status, use text such as Below target as well as color. Avoid coloring every numeric column: readers should be able to tell which signal matters.

Check totals before making them prominent

For this example, dashboard totals should be:

• Current revenue: $320,000
• Previous revenue: $300,000
• Current target: $335,000
• Overall growth: 6.7%
• Overall target attainment: 95.5%

Calculate overall growth as (320000-300000)/300000 and attainment as 320000/335000. Do not average the three displayed regional percentages: their denominators differ.

If the dashboard uses PivotTables, refresh them after changing the source, as described in Microsoft’s refresh guidance. Check the reporting period and filter scope alongside the totals, so a regional selection is not presented as the whole business.

Publish the table, not the workbook decoration

On the Publish sheet, include region, reporting period, revenue, previous revenue, target and clearly defined rate columns. Keep one header row and omit decorative titles and total rows that could be counted as records. Copy the reviewed results as values.

For a CSV export, do not rely on percentage formatting to define the data. One explicit convention is to export growth_pct as a number such as 20.0 and document that it means 20%, not a decimal ratio. To use that convention, multiply the calculated growth ratio by 100 and use a number format rather than a percentage format before copying it as a value. Apply the same convention consistently to other rate columns.

Include source, coverage and refresh information with the public dataset; a caption and summary can explain these details.

Save a separate export, keeping the working workbook intact. Excel’s CSV export saves only the active worksheet and removes formatting, as Microsoft’s export guidance explains. Make Publish the active sheet before exporting, then reopen the exported file and check headers, row count and numeric values.

TablePage accepts CSV, TSV, XLSX and XLS and creates a public dataset page with a shareable link and filterable table. Upload only the sanitized export—not confidential records or the working workbook—and check the resulting page’s labels and values before sharing. Treat the public table as a dataset readers can explore, not as a guaranteed reproduction of your Excel dashboard layout.