Excel Dashboard Examples: Layouts and Build Steps

Charts & pivot tables · Updated November 21, 2026

An Excel dashboard is a single worksheet that brings important measures, charts, and filters together. A useful example is a sales dashboard showing total revenue, order count, units sold, revenue by region, and monthly sales; you can build it in Excel for Microsoft 365 using a clean data table, PivotTables, charts, and optional slicers.

A practical sales dashboard example

Imagine a small business that wants to see how sales are performing without reading every transaction row. Its dashboard could open with four large figures across the top: total revenue, number of orders, units sold, and average revenue per order. Below those figures, a column chart could compare revenue by month, a bar chart could compare regions, and a compact table could list the best-selling products.

For a simple illustration, use six records with these columns: Date, Order ID, Region, Product, Units, and Revenue. The records are: 5 January, O-101, North, Desk, 2, 600; 8 January, O-102, South, Chair, 4, 480; 12 January, O-103, North, Lamp, 3, 150; 2 February, O-104, West, Desk, 1, 300; 9 February, O-105, South, Lamp, 5, 250; and 14 February, O-106, North, Chair, 2, 240. The revenue values are illustrative currency amounts, not a claim about any particular business.

This small dataset contains 2,020 in revenue, six orders, and 17 units sold. North contributes 990. These known totals make it easier to check that dashboard calculations are working before you connect a larger dataset.

Choose the measures before designing the page

A dashboard should answer specific questions, not display every number available. Start by asking what decision a reader needs to make. A sales manager might need to know whether revenue is on target, which region is contributing most, and whether sales are changing over time. A project lead might instead need overdue tasks, work completed, and workload by team.

For the sales example, define each measure clearly. Revenue is the sum of the Revenue column; order count is the number of order IDs; units sold is the sum of Units; and average revenue per order is revenue divided by the number of orders. This definition matters: an average of transaction values is not necessarily the same as an average of individual product prices or customer spending over a period.

  • Use a small number of headline measures that directly support the intended decision.
  • Give each measure a clear label and, where relevant, a unit such as dollars, orders, or units.
  • Decide which comparisons matter, such as region, product, month, or actual versus target.
  • Specify the reporting period and whether dates refer to order date, shipment date, or another event.

Prepare the source data

Put the transaction data in a rectangular list with one header row and one record per row. Keep fields in separate columns: do not combine a date and region in one cell, add subtotal rows between transactions, or use merged cells in the source. Excel’s filtering, charting, and PivotTable tools work more predictably when the data has consistent columns and no blank rows splitting the list.

Check that dates are stored as dates, quantities as numbers, and revenue as numeric values rather than text. A value that looks like 600 but is stored as text can be omitted from a sum. Use one consistent meaning for blanks: a blank quantity should not silently mean zero unless that is genuinely how the source system defines it. Resolve duplicate records and decide how to handle refunds or cancelled orders before interpreting totals.

Select a cell in the data and choose Insert > Table. Confirm that the selected range is correct and that the table has headers. A table can expand when new rows are added and gives PivotTables and formulas a more manageable source than a fixed range. In Microsoft 365 for Windows, you can also create a table with Ctrl+T; on Mac, use Command+T. If the data is replaced or extended, refresh dependent PivotTables so the dashboard reflects the updated records.

Build the headline calculations

For a small worksheet-based example, suppose the six illustrative records are in rows 2 through 7, with Order ID in column B, Region in C, Units in E, and Revenue in F. Place each calculation in a separate dashboard cell and put its label nearby. With revenue values in F2:F7, enter =SUM(F2:F7); it returns 2020.

With order IDs in B2:B7 and one nonblank ID per order, enter =COUNTA(B2:B7) to count orders; it returns 6. With units in E2:E7, enter =SUM(E2:E7) to total units; it returns 17. With revenue in F2:F7, enter =AVERAGE(F2:F7) to calculate average revenue per recorded order; it returns 336.6666667, or 336.67 when displayed to two decimal places.

To calculate revenue for a selected region, place North in H2. With revenue in F2:F7 and the matching region names in C2:C7, enter =SUMIFS($F$2:$F$7,$C$2:$C$7,H2). The result is 990. SUMIFS is useful when the dashboard needs a formula tied to a criterion cell, but it does not automatically create an interactive filter. For larger or changing datasets, PivotTables are often easier to maintain than a collection of fixed-range formulas.

Summarize data with PivotTables

A PivotTable groups and summarizes records without changing the source list. Select a cell in the Excel table, choose Insert > PivotTable, confirm the table or range, and choose where to place the PivotTable. In the PivotTable Fields pane, drag fields into Rows, Columns, Values, or Filters. For example, put Region in Rows and Revenue in Values to compare revenue by region. Put Date in Rows and Revenue in Values to examine revenue over time.

Check the calculation used in Values. Excel may choose Sum for numeric revenue, but a field stored as text can lead to a count instead. Open the field’s value settings and confirm that it summarizes by Sum when that is the intended measure. Dates may be grouped into months or years from the PivotTable; confirm that the source dates are real dates and that grouping matches the reporting question. A PivotTable can be refreshed from its context menu or from PivotTable Analyze > Refresh.

PivotTables suit category breakdowns, changing date ranges, and datasets that grow. Formula-based summaries suit a deliberately small set of measures or a customized layout. They can also be combined: use PivotTables to produce chart-ready summaries, then arrange those summaries and KPI formulas on a dashboard sheet.

Pick charts that clarify the comparison

Choose a chart based on the question. A line chart is usually a straightforward way to show a measure changing over regular time periods. A bar or column chart compares categories such as regions or products. A stacked chart can show how components contribute to a total, but it becomes hard to read when there are many categories or series. A pie chart is best kept for a small number of parts that make up one whole; it is not a good way to compare many similar values.

To create a chart from a PivotTable, select a cell in it and choose Insert > PivotChart, then select a chart type. For a chart based on an ordinary summary range, select the labels and values and choose an appropriate chart from Insert. Give the chart a descriptive title, label axes when the units are not obvious, and remove decoration that does not help interpretation. Avoid three-dimensional effects and excessive colors, which can make comparisons less clear.

Add useful filters and arrange the dashboard

A slicer lets a reader filter a PivotTable using visible buttons. Select a PivotTable and choose PivotTable Analyze > Insert Slicer, then choose fields such as Region or Product. For date filtering, a Timeline can be inserted from PivotTable Analyze > Insert Timeline when the PivotTable contains a suitable date field. If several PivotTables should respond to the same slicer, use its Report Connections or PivotTable Connections settings and select the PivotTables that share a compatible source.

Arrange the sheet in a clear reading order: title and reporting period first, KPI cards next, then the main charts, with any detailed table below or to one side. Keep related objects aligned and leave enough space for labels. On Windows, View > Gridlines can hide worksheet gridlines for a cleaner presentation; the same View tab setting is available in Excel for Mac, though ribbon layout can vary. Freeze panes are more useful on a long detail sheet than on a compact dashboard.

Use restrained formatting. Consistent colors can distinguish categories, but color alone should not communicate a critical status because readers may have difficulty distinguishing some colors or may print in grayscale. Use clear labels as well. Apply number formats so revenue is recognizable as currency and percentages show an appropriate number of decimal places. Formatting changes how values appear, not the underlying calculation.

Common dashboard problems and checks

A dashboard can look polished and still be misleading. The most common trouble is a mismatch between the question and the calculation: for example, counting rows when the business definition is distinct customers, or comparing totals from different date ranges. Excel’s ordinary COUNTA count does not deduplicate repeated customer IDs. State the definition of each KPI and verify it against a small manually checked sample.

  • New records do not appear: confirm they are inside the Excel table, then refresh the PivotTable and check that the PivotTable source includes the table.
  • A revenue total is unexpectedly low or zero: check for numbers stored as text, filters left active, missing rows, or an incorrect source range.
  • A PivotTable shows Count instead of Sum: inspect the source column for text or mixed values, then correct the data and refresh.
  • Dates group incorrectly: check for text dates, blanks, or inconsistent date values in the source.
  • Charts disagree with KPI cards: verify that both use the same reporting period, filter selections, and source records.

Before sharing, test the dashboard with several filter selections and compare its totals with an independent check, such as a PivotTable or a sum of the source data. Include a visible “data through” date if readers need to know how current the information is. Keep a copy of the source or a documented refresh process so that another person can update the workbook consistently.

Excel dashboards, templates, and alternatives

A template can save time on layout, but it cannot determine whether its metrics match your organization’s definitions. Inspect the formulas, source ranges, sample data, and refresh behavior before using a downloaded template. Replace example values with approved data, check that charts update when the source grows, and remove any measures that do not apply. A clean workbook built around a small number of reliable measures is more useful than a complex template that readers cannot interpret.

Excel is a practical choice when the audience already works with spreadsheets, the data is moderate in size, and someone can maintain the source and refresh steps. If many people need controlled, simultaneous access to a published report, or the data is large and comes from several systems, a dedicated business intelligence service or a database-backed reporting process may be more suitable. That does not make Excel dashboards inherently unsuitable; it means the right tool depends on data scale, update frequency, access control, and maintenance needs.

Frequently Asked Questions

What should an Excel dashboard include?
A focused dashboard usually includes a title and reporting period, a few clearly defined KPIs, one or more charts that answer specific questions, and filters only where readers need to explore the data. The right contents depend on the decision the dashboard supports.

Can I make an Excel dashboard without PivotTables?
Yes. You can calculate KPIs with formulas and build charts from summary ranges. That approach works well for a small, stable report. PivotTables are often easier when users need to group records by region, product, or date and refresh summaries as data changes.

How do I make a dashboard update when new data is added?
Format the source as an Excel table, base PivotTables or formulas on that table where appropriate, and refresh PivotTables after data changes. Check that chart sources and any manually selected formula ranges include the new records.

Can an Excel dashboard have interactive filters?
Yes. Slicers can filter compatible PivotTables, and a Timeline can filter PivotTable date fields. Confirm that connected PivotTables share a compatible source and configure the slicer’s connections if the dashboard has multiple summaries.

Should I use a chart or a table?
Use a chart to reveal a pattern or make comparisons quickly. Use a table when readers need exact values, detailed records, or a precise ranking. A dashboard can use both, but each should serve a distinct purpose.

How many charts should a dashboard have?
There is no universal ideal number. Include only charts that answer different useful questions; too many competing visuals make it harder to find the important result. Start with the smallest layout that communicates the required measures clearly.

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.