How to Create a Company Dashboard in Excel

Building a company dashboard in Excel lets you see the pulse of your business on a single screen without needing complex or expensive software. It’s a powerful way to turn rows of data into clear, visual stories about your performance. This tutorial will walk you through the entire process, from structuring your data to building interactive charts and filters.

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 Exactly is a Company Dashboard?

Think of it as the cockpit of your business. A company dashboard is a single-page report that uses data visualizations (like charts and graphs) to provide a high-level overview of your most important business metrics. Instead of digging through messy spreadsheets or logging into five different platforms, you get an at-a-glance view of performance, trends, and key performance indicators (KPIs).

Excel is a common starting point because it's familiar to a lot of people and surprisingly powerful for this kind of work. It’s perfect for getting your reporting process organized and demonstrating the value of data without needing to purchase specialized Business Intelligence tools.

Step 1: Plan Your Dashboard Before You Build

Jumping straight into building charts without a plan is a recipe for a cluttered, confusing dashboard. Taking a few minutes to think through the strategy will save you hours of revisions later.

Define Your Audience and Their Questions

Who is this dashboard for? The metrics a marketing manager cares about are different from what a sales director or the CEO needs to see. Tailor the dashboard to answer the specific questions your audience has.

• For a marketing team: "Which ad campaigns are driving the most sales?" or "How is our website traffic trending month over month?"
• For a sales team: "Who are our top-performing reps?" or "What is our sales pipeline conversion rate?"
• For a founder: "What's our monthly recurring revenue (MRR)?" or "How is our customer acquisition cost (CAC) changing over time?"

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

Identify Your Key Performance Indicators (KPIs)

Once you know the questions, identify the KPIs that will provide the answers. Don't try to track everything - focus on the 5-10 metrics that truly matter. For a sales and marketing dashboard, your list might include:

• Total Revenue
• Website Sessions
• Cost Per Acquisition (CPA)
• Conversion Rate
• Number of New Leads
• Revenue by Campaign

Sketch a Layout

Finally, grab a pen and paper (or a simple design tool) and sketch a rough layout. Where will the most important KPI go? (Hint: top left). How will you group similar charts? This simple blueprint will guide you during the build process and ensure you end up with a clean, organized design.

Step 2: Get Your Data Ready for Analysis

Dashboards are only as good as the data powering them. Your source data needs to be clean and structured in a way Excel can easily understand. The golden rule is to organize your data into a "raw data" table.

Organize Data in a Simple Table Format

Your data should be set up in a simple, flat table structure. This means:

• One header row at the top: Each column has a unique, descriptive name (e.g., "Date," "Sales Rep," "Region," "Revenue").
• No merged cells: Merged cells cause major headaches for PivotTables and formulas.
• No blank rows or columns: Keep the data contained within one contiguous block.

Your raw data might look something like this, probably in a separate tab named "Data":

Format Your Data as an Excel Table

This is arguably the most important trick for building robust Excel dashboards. Don't just format your data manually, turn it into an official Excel Table. Click anywhere inside your data range and press Ctrl + T (or Cmd + T on a Mac). Ensure the "My table has headers" box is checked, and click OK.

Why is this a big deal?

• It's dynamic: When you add new rows of data to the bottom, the Table automatically expands. Your PivotCharts and other calculations will instantly include the new data when you refresh, without you having to manually update any ranges.
• It's clean: It automatically adds formatting and filter buttons, making it easy to see what you're working with.
• It improves formulas: Formulas that reference Table columns are easier to read (e.g., =SUM(SalesData[Revenue]) instead of =SUM(C2:C5000)).

Step 3: Build Your Main Charts with PivotTables

PivotTables are the engine of any great Excel dashboard. They do the heavy lifting of summarizing thousands of rows of data into neat, digestible summaries, which we can then turn into charts.

We'll create our PivotTables on a new, dedicated sheet - let's call it the "Engine Room" or "Analysis" - to keep things organized and separate from the final dashboard view.

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

Create Your First PivotTable

1. Click anywhere inside your official Excel Table on the "Data" sheet.
2. Go to the Insert tab on the Ribbon and click PivotTable.
3. In the dialog box, confirm the Table/Range is correct and choose to place it in an Existing Worksheet (your "Engine Room" sheet).
4. Click OK.

Now you have a blank PivotTable. Let's say we want to see monthly revenue. In the PivotTable Fields panel on the right:

• Drag the "Date" field to the Rows area. Excel will automatically group it by months and years.
• Drag the "Revenue" field to the Values area. Excel will default to Sum of Revenue.

Just like that, you have a summary table showing total revenue for each month!

Create a PivotChart from the PivotTable

Now for the visual part. With your newly created PivotTable selected:

1. Go to the PivotTable Analyze tab in the Ribbon.
2. Click on PivotChart.
3. Choose a chart type. For revenue over time, a Line chart is perfect.
4. Click OK.

A shiny new line chart appears, completely linked to your PivotTable. If the data in the PivotTable changes, the chart updates automatically.

Clean Up Your Chart

The default PivotChart is often cluttered. Right-click on the gray field buttons (like "Sum of Revenue") on the chart and select "Hide All Field Buttons on Chart" to clean it up. You can also click the "+" sign next to the chart to remove gridlines or add a clear title.

Rinse and Repeat

Follow this exact process - create a new PivotTable, then create a PivotChart from it - for each of your other KPIs.

• Product Sales Leaderboard: PivotTable with "Product Name" in Rows and "Sum of Revenue" in Values. Use a Bar chart.
• Marketing Channel Contribution: PivotTable with "Marketing Channel" in Rows and "Sum of conversions" in Values. Use a Pie or Doughnut chart.

Move Your Charts to the Dashboard

Once you’ve created all your charts, create one more new sheet - call it "Dashboard." Select each chart from your "Engine Room" one by one, cut it (Ctrl + X), then paste it (Ctrl + V) onto your "Dashboard" sheet. Now you can arrange them according to the sketch you made in Step 1.

Step 4: Make Your Dashboard Interactive with Slicers

This is where the magic happens. A Slicer provides interactive buttons that link to your charts, allowing you and your team to filter the entire dashboard view without touching any formulas or filters.

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

Insert a Slicer

1. Click on any of the charts on your "Dashboard" sheet.
2. Go to the PivotTable Analyze tab.
3. Click Insert Slicer.
4. A dialog box will appear showing all your available data columns. Check the box for the dimension you want to filter by - for example, "Campaign" or "Sales Rep."

A new, floating Slicer panel with buttons for each of your campaigns or reps will appear on your dashboard.

Connect One Slicer to All Charts

Out of the box, a Slicer only controls the chart it was created from. To make it a true dashboard filter, you need to connect it to your other charts as well.

1. Right-click on your Slicer and choose Report Connections.
2. In the dialog box, you'll see a list of all the PivotTables in your workbook. Check the box for every PivotTable that you want this Slicer to control.
3. Click OK.

Now when you click a button on the Slicer, every chart you connected will filter to show data just for that selection! You can even hold Ctrl to select multiple items.

Step 5: Add Final Design Touches and Dynamic KPIs

With the structure in place, it's time to add a layer of polish to make your dashboard easy to read and understand.

• Use a clean grid layout: Align your charts neatly. Use the options in the View tab (like disabling Gridlines) for a cleaner canvas.
• Be consistent with color: Use colors from your company's brand palette to create a professional look. Avoid using too many clashing colors.
• Add KPI "cards": Instead of a chart, sometimes you just want a single, important number. In a blank cell on your dashboard, type "=" and then click the cell in your "Engine Room" that contains the grand total for a KPI like total revenue. Now that cell on your dashboard will always display the real-time total. Style it with a large font size to make it stand out.

Final Thoughts

Creating a company dashboard in Excel is a powerful skill. It shifts your reporting from manual, repetitive data dumps to a dynamic, visual tool that empowers your team to make faster, better-informed decisions. By following a structured process of planning, data preparation, building with PivotTables, and adding interactive slicers, you can create professional dashboards directly in a tool you already know.

Of course, the biggest challenge with Excel dashboards is the manual upkeep - downloading new CSVs, pasting data, and remembering to refresh everything. It also isn't "live" with your data sources. At Graphed, we automate that entire frustrating piece of the puzzle. Instead of wrestling with spreadsheet imports and manual refreshes, you just connect your sales and marketing tools (like Shopify, Google Analytics, or Salesforce) once. From there, you can ask for charts and dashboards in plain English, and they build themselves for you in seconds, always connected to the live data.