How to Create a Procurement Dashboard in Excel

Building a procurement dashboard can feel like a daunting task, but it’s the best way to transform messy purchasing data into clear, actionable insights. A good dashboard tells you where your money is going, how your suppliers are performing, and where you can find opportunities to save. In this guide, we'll walk through exactly how to create a dynamic procurement dashboard right inside of Excel.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Procurement Dashboard?

A procurement dashboard is a visual, one-page report that tracks key performance indicators (KPIs) related to your company's purchasing activities. Instead of digging through endless spreadsheets, you get a high-level view of procurement performance at a glance. Think of it as the command center for your entire supply chain and purchasing process.

An effective dashboard helps you:

• Monitor Spending: Quickly see spend by category, supplier, or department to spot trends and control costs.
• Track Supplier Performance: Evaluate suppliers based on critical metrics like on-time delivery rates and defect percentages.
• Identify Savings Opportunities: Uncover areas where you can negotiate better pricing or consolidate suppliers.
• Manage Risk: Spot potential disruptions early, like over-reliance on a single supplier.
• Improve Efficiency: Measure things like purchase order (PO) cycle times to streamline your processes.

Key Metrics to Track on a Procurement Dashboard

Before you build anything, you need to decide what to measure. The right metrics depend on your business goals, but here are some of the most common and valuable procurement KPIs:

Purchase Spend & Savings

• Total Spend: The total amount of money spent over a period. Often broken down by category or supplier.
• Cost Savings: The amount of money you've saved through negotiations, discounts, or strategic sourcing.
• Spend Under Management (SUM): The percentage of total company spend that procurement is actively managing. A higher percentage is better.

Supplier Performance

• On-Time Delivery Rate: The percentage of orders that arrived on or before the requested delivery date. A critical measure of supplier reliability.
• Supplier Defect Rate: The percentage of units received from a supplier that are defective. This is a key indicator of quality.
• Supplier Scorecards: A composite score that rates suppliers based on multiple criteria (price, quality, delivery, etc.).

Process Efficiency

• Purchase Order (PO) Cycle Time: The average time from when a purchase requisition is created until the PO is approved and sent to the supplier. Shorter is better.
• Contract Compliance: The percentage of purchases made through pre-negotiated contracts. High compliance means you’re taking advantage of your negotiated rates.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Getting Your Data Ready for Analysis

Your dashboard is only as good as the data powering it. "Garbage In, Garbage Out" is a hard reality in analytics. Before building charts, you need a clean, structured dataset. For a procurement dashboard, this data usually comes from an ERP system, accounting software, or a series of detailed spreadsheets.

Your goal is to organize this data into a single, flat table. Each row should represent a single transaction or line item, and each column should represent a piece of information about that transaction.

A typical procurement dataset structure might look like this:

The Magic of Excel Tables

Once you have your raw data in Excel, the single most important first step is to format it as a Table. This isn't just about adding colored stripes. Taking 10 seconds to do this unlocks powerful features:

1. Click anywhere inside your dataset.
2. Go to the Insert tab on the Ribbon.
3. Click Table (or use the shortcut Ctrl + T).
4. Ensure the "My table has headers" box is checked, and click OK.

Excel Tables automatically expand to include new rows and columns, which means your PivotTables and charts will update without you needing to manually adjust data ranges. This makes refreshing your dashboard a breeze.

Step-by-Step Guide: Building the Dashboard in Excel

With our cleaned data in an Excel Table, we can start building the dashboard. Let’s create a few common visuals: a spend analysis by supplier and an on-time delivery rate analysis.

Step 1: Set Up Your Workbook

Keep your workbook organized by using separate sheets. At a minimum, you’ll want two:

• Data: This sheet holds your formatted Excel Table of raw procurement data.
• Dashboard: This is where you will build your final report with all the charts and slicers.

Optionally, you can add a third sheet for your PivotTables called "Calculations" or "Pivot" to keep your dashboard layout clean.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Create Pivot Tables for Your KPIs

PivotTables are the engine of any Excel dashboard. They do the heavy lifting of summarizing your data so you can create charts and visualizations.

Example A: Spend by Supplier

1. Go to your 'Data' sheet and click anywhere in your Excel Table.
2. Go to Insert > PivotTable.
3. In the popup, Excel will automatically select your table. Choose 'New Worksheet' or 'Existing Worksheet' (if you have one for pivots) and click OK.
4. The PivotTable Fields pane will appear. Drag and drop the fields into the areas:

Instantly, you have a summary table showing total spend for each supplier. Be sure to format the "Sum of Total Cost" column as currency for readability.

Example B: On-Time vs. Late Delivery Count

1. Create another PivotTable from your source data.
2. Configure the fields like this:

This table gives you a simple count of all on-time and late deliveries.

Step 3: Create Pivot Charts from Your Pivot Tables

Now, let's turn these tables into something visual. This is the fun part!

Spend by Supplier Bar Chart

1. Click anywhere inside your "Spend by Supplier" PivotTable.
2. Go to the PivotTable Analyze tab and click PivotChart.
3. Choose a Bar Chart or Column Chart. Bar charts are often better when you have long supplier names. Click OK.

Your chart will appear. You can clean it up by hiding the field buttons (right-click a button -> 'Hide all field buttons on chart'), giving it a clear title like "Total Spend by Supplier," and removing the legend if it's not needed.

On-Time Delivery Rate Donut Chart

1. Click anywhere inside your "On-Time vs. Late" PivotTable.
2. Go to PivotTable Analyze > PivotChart.
3. Choose a Pie Chart, and select the Donut style. Click OK.
4. Clean up the chart with a title like "On-Time Delivery Performance." You can also add data labels to show the actual counts or percentages.

Step 4: Design a Clear Dashboard Layout

With a couple of charts built, it's time to arrange them on your 'Dashboard' sheet.

1. Select a chart, press Ctrl + X to cut it.
2. Go to the 'Dashboard' sheet and press Ctrl + V to paste it.
3. Resize and position your charts neatly. Use the gridlines in Excel (under the View tab) to help you align objects.
4. Give your dashboard a main title at the top, like "Procurement Performance Dashboard."

A good layout is crucial. Leave some white space between elements and group related charts together. You can add a few 'cards' at the top for high-level numbers by linking text boxes to cells in your PivotTables that show grand totals.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 5: Add Slicers to Make Your Dashboard Interactive

This is where your dashboard goes from being a static report to a dynamic analysis tool. Slicers are user-friendly buttons that filter your data.

1. Click on one of your PivotCharts on the dashboard.
2. Go to the PivotTable Analyze tab and click Insert Slicer.
3. A dialog box will appear with all your data fields. Check the boxes for fields you want to filter by, such as Category and Supplier. You can also add a Timeline for date fields like Order Date.
4. The slicers will appear on your sheet. Position them where they are easily accessible, typically at the top or on the side.

Right now, a slicer will only control the chart it was created from. To make it control all your dashboard charts, you need to connect them:

1. Right-click on a slicer and select Report Connections.
2. In the dialog box, check the boxes for all the PivotTables you want this slicer to control.
3. Repeat this for every slicer on your dashboard.

Now, when you click a category or supplier in a slicer, all the connected charts on your dashboard will update instantly.

Final Thoughts

Creating a procurement dashboard in Excel transforms how you interact with your purchasing data, moving from manual data digging to proactive, visual analysis. By organizing your data into an Excel Table and using PivotTables and Slicers, you can build a powerful, interactive tool that helps you manage spend, monitor suppliers, and improve efficiency.

While Excel is a fantastic tool, the process can become time-consuming, especially when you need to pull data from multiple sources like your ERP, accounting software, and other SaaS tools. At Graphed, we simplify this entire workflow. By connecting directly to your data sources, we eliminate the need for manual CSV downloads and data cleaning. You can just ask questions in plain English - like "Show me a dashboard of spend vs savings by category this quarter" - and Graphed instantly builds a live, interactive dashboard for you, saving you hours of tedious work.