Skip to content

PMO dashboard builder

Portfolio health at a glance: budget against plan, milestones, and the projects that need a decision this week. Add your numbers and export the slide.

New here? — takes 2 minutes.

PMO dashboard

Portfolio status — Period ending 30 September

Active projects

24
+2

On schedule

17
71%

Budget used

62%
of $9.4m

At risk

4
+1

Spend against plan ($k)

PlannedActual
0
200
400
600
800
Planned: 620Actual: 598
Planned: 640Actual: 671
Planned: 660Actual: 642
Planned: 700Actual: 745
Planned: 720Actual: 712
Planned: 740Actual: 769
AprMayJunJulAugSep

Milestones delivered on time

78%Target 90%

Projects needing a decision

ProjectOwnerStageVarianceNext gate
Warehouse automation, criticalR. IyerBuild+$180k12 Oct
ERP migration, seriousS. ClarkeTest+$64k24 Oct
Depot consolidation, goodM. OkaforDesign−$22k03 Nov
Customer portal, warningA. DuarteBuild+$9k17 Nov

4 Project Portfolio Management Office Dashboard templates

Every template opens as a finished dashboard. Pick the closest one, then change anything.

Metrics and how to calculate them

The KPIs these templates are built on, with the formula behind each one.

Projects on schedule
Projects forecasting their next gate on or before baseline ÷ active projects × 100.
Budget used
Actual spend to date ÷ approved portfolio budget × 100.
Spend variance
Actual spend − planned spend for the period; positive means over plan.
Milestones on time
Milestones delivered on or before baseline ÷ milestones due × 100.
Benefits realized
Measured benefits delivered to date against the benefits profile in the business case.
Resource utilization
Hours allocated ÷ hours available × 100, by team or person.
Strategic alignment
Portfolio budget in projects mapped to a current strategic objective ÷ total portfolio budget × 100.

How to make your Project Portfolio Management Office Dashboard

Pick a template, put your numbers in, download — about two minutes. Nothing to install; the PDF and every other format come with a SlideTeam plan.

  1. 1

    Pick your dashboard

    Click Pick Your Dashboard. This dashboard has 4 ready-made layouts, such as PMO dashboard and Portfolio management. Each opens finished, with example figures.

  2. 2

    Change the numbers

    Point at any widget (tap it on a phone) and choose Edit to type or paste its numbers and labels — a column copied from Excel pastes straight in. Click the dashboard's title to rename it.

  3. 3

    Use your own data

    Upload CSV or Excel takes a CSV, .xlsx or .xls file and shows exactly what it read: pick the sheet, the label column and how repeated rows are combined (sum, average, count), then Build a new dashboard or Fill this template with your columns. Not sure of the layout? Download the sample CSV and replace the numbers.

  4. 4

    Download PDF, PowerPoint, Excel and more

    Download (right end of the toolbar) lists every format: a PDF (free), PowerPoint with native charts you can still edit (right-click › Edit data), a report pack (summary slide plus one slide per chart) as PowerPoint or PDF, Excel (opens on a Dashboard sheet with live charts) and a CSV for Power BI, Tableau or Google Sheets.

  5. 5

    More options: add widgets, brand it, share

    More options (top right) shows the rest: Add widget puts in a chart, KPI tile, table, funnel or a Text / commentary box; the arrows on a widget move it and ✕ removes it; click the subtitle to edit it. Customise sets the currency, template language, slide size, brand colour and logo. Sheets / Slides shows how to open your file in Google Sheets or Slides; Share copies a link to this exact dashboard.

Common questions

What should a PMO dashboard include?

Active projects and how many are on schedule, spend against plan, milestones delivered on time and the projects that need a decision. The PMO dashboard template opens with exactly those.

What is the difference between a PMO dashboard and a portfolio management dashboard?

A PMO dashboard reports delivery status. A portfolio management dashboard answers investment questions: spend by strategic theme, the stage-gate pipeline and value against risk. Both are templates here.

Can a PMO dashboard show resource capacity?

Yes. The PMO resource capacity template shows utilization by team and month as a heatmap, demand against capacity, and the people most over-allocated.

Can I export it to Excel for the PMO pack?

Download Excel for a workbook with each chart's data on its own sheet, or PowerPoint for an editable slide.

Goes well with this — from our other free tools

The figures in the example dashboards are illustrative and exist so each page shows a finished dashboard rather than an empty grid. Replace them with yours before sharing anything.