Excel Dashboard Design Templates: How to Choose and Build

Charts & pivot tables · Updated November 19, 2026

Excel dashboard design templates are prebuilt workbooks or layouts that organize key metrics, charts, and filters on a single reporting sheet. Choose one that fits your audience and data, then replace its sample content with a clean, refreshable data source; you can find templates through Excel’s File > New screen or build a custom dashboard from a blank workbook.

What an Excel dashboard template includes

A template is a starting structure, not a finished reporting system. It may contain formatted headings, charts, summary cards, formulas, PivotTables, slicers, or sample data. Some templates are designed for a particular purpose, such as sales tracking or project status; others provide a general layout that you adapt. The quality of the result depends on whether the template’s assumptions match your own data and definitions.

Excel for Microsoft 365 on Windows includes a template gallery under File > New. Search terms such as “dashboard,” “sales report,” or “project tracker” may surface relevant options, though available templates can change by account, language, and region. You can also start with a blank workbook or use a trusted third-party template. Check what a download contains before entering business data, especially if it includes macros or external connections.

What makes a dashboard useful

A useful dashboard answers a small number of specific questions quickly. A sales manager may need to know whether revenue is on target, which region is behind, and how results compare with the previous month. A project lead may care more about overdue tasks, milestone dates, and workload. A template crowded with attractive charts can still be ineffective if it does not make those answers easy to find.

Most practical dashboards combine a few elements:

  • Key performance indicators: a small set of totals, rates, or counts with clear labels and time periods.
  • Charts: visual comparisons or trends that support a specific question.
  • Filters: controls such as date, region, or product that let viewers change the reporting scope.
  • Context: units, target values, reporting dates, and notes explaining unusual figures.
  • A data source: a structured table or refreshable query kept separate from the presentation layer.

Put the most important information near the top-left or top of the sheet, where it is easy to notice. Label metrics precisely: “Revenue, current quarter” is more informative than “Total.” State whether amounts are in dollars, whether a percentage is a share or a change, and what dates the dashboard covers.

Common dashboard template types

Templates are easiest to compare by the decision they support. A sales dashboard might show revenue by month, product, and territory. An operations dashboard may track order volume, turnaround time, and service levels. A project dashboard could summarize task status, due dates, and milestones. A budget dashboard may compare planned and actual spending by category. These are different reporting problems, so a template built for one should not be assumed to suit another.

There is also a difference between a static report and an interactive dashboard. A static report displays a fixed period or selection. An interactive one may include PivotTable slicers, date filters, or drop-down choices. Interactivity can help users explore the figures, but it adds setup and testing: every chart and summary that should respond to a filter must be connected to the appropriate source or PivotTable.

How to choose a template

Before downloading or customizing anything, write down who will use the dashboard, what decision they need to make, and how often the information changes. Then inspect the template against your real reporting process. A good visual match is not enough if the workbook expects fields you do not collect or calculates metrics differently from your organization.

  • Check the data structure. Can your source provide the fields the template expects, such as dates, categories, owners, or amounts?
  • Confirm metric definitions. “Conversion rate,” “on-time,” and “active customer” can each have multiple definitions. Make the intended calculation explicit.
  • Look for refreshability. Prefer a layout that can update when rows are added, rather than one that depends on manually extending formulas or charts.
  • Assess readability. Check labels, chart scales, color contrast, print size, and whether the dashboard works at the screen size viewers will use.
  • Review workbook features. Identify formulas, PivotTables, external links, queries, and macros before relying on the file.

A template that needs substantial repair may take longer to adapt than a simple custom sheet. Use the template as a design reference if its calculations, data layout, or visual choices do not fit your needs.

Build a dashboard from a template

In Excel for Microsoft 365 on Windows, open a suitable template from File > New, or open a trusted workbook and save a working copy before changing it. Start by identifying which sheet contains the source data and which sheets contain summaries or charts. Keep an untouched copy of the original so you can return to it if you need to compare formulas or layout.

  1. Inspect the sample. Read the labels and trace a few displayed values back to the source. Confirm the date range, units, and calculation logic.
  2. Prepare your data. Use one header row, one record per row, and consistent values in each column. Avoid merged cells, blank spacer rows, and subtotals inside the source list.
  3. Convert the source to a table. Select a cell in the data and choose Insert > Table. Confirm that the table has headers. A table can expand as records are added and provides consistent column names for formulas.
  4. Replace or reconnect the sample data. Preserve required column names where possible. If the template uses PivotTables or formulas, check that their source ranges include the real data.
  5. Update metrics and visuals. Remove irrelevant measures, revise chart titles, and check that totals agree with a separate calculation or source report.
  6. Test the finished view. Add a new record, refresh any PivotTables or queries, try each filter, and confirm that the displayed results change as expected.

For a reusable workbook, keep source records on a clearly named sheet and the dashboard on a separate sheet. That separation makes it easier to update data without accidentally overwriting charts or summary formulas.

Simple formula-based summaries

Small dashboards can use ordinary worksheet formulas instead of PivotTables. For example, assume regions are in A2:A5, sales amounts are in B2:B5, and the region to summarize is in D2. With North listed twice at 1,200 and 800, and South listed twice at 900 and 1,100, this formula in E2 returns 2,000 when D2 contains North: =SUMIF(A2:A5,D2,B2:B5). The first range contains the criteria, the second is the selected region, and the third contains the values to add.

You can also show change between two periods. With the earlier-period value in B2 and the later-period value in C2, enter this in D2: =IFERROR((C2-B2)/B2,0). If B2 is 2,000 and C2 is 2,500, the result is 0.25, or 25% when formatted as a percentage. IFERROR returns zero if the calculation cannot be completed, including when the earlier value is zero; label or handle that case carefully because zero growth and an undefined percentage are not the same thing.

For larger or changing data sets, formulas tied to fixed ranges can miss new records. Excel tables, PivotTables, or Power Query can provide more maintainable foundations, depending on how the data arrives and how much transformation it needs.

Design choices that improve readability

Use a visual hierarchy rather than giving every figure equal weight. A few prominent KPI cards can lead into a trend chart and a breakdown table. Avoid filling every empty space: whitespace helps separate sections and makes unusual values easier to spot. Use consistent number formats, such as the same decimal places for comparable percentages, and include units in a heading or label.

Choose chart types according to the question. Line charts are generally suited to values over time, while bars make category comparisons easy to scan. Pie charts can become hard to compare when there are many categories or similar-sized slices. Do not rely on color alone to communicate status; add labels or symbols so meaning remains clear for people who cannot distinguish the colors. Check that axes and time periods are not misleadingly cropped or inconsistent.

For accessibility, use descriptive chart titles, readable font sizes, adequate contrast, and meaningful worksheet names. Avoid tiny text intended to fit a dashboard onto one screen. If people will print the report, check Page Layout and print preview separately: a layout that works on a monitor may split across pages or shrink until labels are unreadable.

PivotTables, formulas, and other approaches

PivotTables are helpful when viewers need to summarize many records by categories and change the arrangement. In Excel for Microsoft 365 on Windows, select a cell in the source table and choose Insert > PivotTable. Build the summary by placing fields into the PivotTable areas. To add a chart, select the PivotTable and use PivotTable Analyze > PivotChart. To add a slicer, select the PivotTable and choose PivotTable Analyze > Insert Slicer. Ribbon labels or available controls can differ in Excel for Mac and Excel for the web; use the corresponding PivotTable controls in those versions.

Formula summaries offer more control over a fixed dashboard layout, but they can become difficult to maintain when many measures and conditions are involved. Power Query is useful for repeatable importing and cleaning, while PivotTables are useful for interactive grouping and aggregation. These options can also work together: Power Query can prepare a source table, and PivotTables can summarize it. Choose based on the update process, not on which feature sounds most advanced.

Common problems and how to avoid them

A frequent template problem is that the dashboard looks correct while its data is stale or incomplete. A chart may reference a fixed range that excludes new rows; a PivotTable may need a refresh; or a formula may treat text-formatted numbers as text. Check the source, formulas, and refresh behavior rather than relying on appearance alone.

  • Totals do not match: confirm filters, hidden rows, duplicate records, date boundaries, and whether the template includes all source rows.
  • Charts show blanks or unexpected categories: inspect source ranges and inconsistent spellings, extra spaces, or empty category values.
  • Filters affect only some visuals: verify that each PivotTable or chart is connected to the intended filter and data source.
  • Workbook opens with warnings: review external links and connections. Do not enable macros or content from an unfamiliar file just to make a dashboard display.
  • Numbers change after refresh: compare the refreshed result with a known sample and verify the metric definitions and date filters.

Sharing and maintaining a dashboard

Save a reusable template as an Excel template file (.xltx) when it does not need macros. Opening a template generally creates a new workbook based on it, helping preserve the original design. A macro-enabled template uses a different file type; only use macros when they are needed and come from a source you trust. Excel files with macros cannot be made safe merely by changing their appearance.

Before sharing, remove sample or confidential data, check for external links, and decide whether recipients need to edit the source or only view the report. Document the data owner, refresh frequency, reporting period, and definitions for important metrics. Excel for the web is convenient for viewing and collaboration, but some workbook features and editing controls differ from the Windows desktop application. If the dashboard depends on a feature that behaves differently online, tell viewers which version to use and verify the shared workbook in that environment.

Frequently Asked Questions

Where can I download Excel dashboard templates?
Start with Excel’s File > New template gallery. You can also look at reputable business or industry sources, but inspect the workbook’s formulas, connections, and macros before using it with sensitive data.

Are Excel dashboard templates free?
Some templates in Excel’s gallery and on other sites are available at no charge; others are sold or require a subscription. Check the provider’s terms, file format, and included features before downloading.

Can I make an interactive dashboard in Excel?
Yes. PivotTables, PivotCharts, and slicers can let users filter summaries. Test that all relevant visuals respond to the filters, and refresh PivotTables when the underlying source changes.

Should I use a template or build a dashboard from scratch?
Use a template when its data structure and metric definitions are close to yours and its layout serves the intended audience. Start from scratch when adapting it would require extensive formula repairs or when your reporting needs are specific.

How do I keep a dashboard updated?
Use a consistent source table or refreshable data connection, make the update steps clear, and test a new record or refresh before sharing each reporting cycle. Check that formulas and charts include newly added records.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.