Excel Canvas: Create Stunning Dynamic Dashboards with Copilot

Excel Canvas is a powerful new feature that lets us create stunning, interactive dashboards straight inside our workbook. Using Copilot, we simply describe what we want, and Excel generates a polished HTML-based canvas sheet that is dynamically linked to our source data. No manual chart building, no layout wrestling. In this tutorial, we walk through three exercises: a warm-up with simple regional sales data, a more complex expense summary with interactive filters and a logo, and finally, a look at how to store brand preferences in a special rules sheet so every future canvas automatically uses our colors.

Exercise 1: Create a Basic Canvas from Regional Sales Data

Let’s start with a warm-up. Consider the following worksheet:

We have a simple table with Region and Sales columns. Four rows, four regions. Nothing fancy. The goal here is to turn this into an interactive visual with zero manual formatting.

First, we open the Copilot pane. Then we type a simple prompt asking Copilot to create a canvas from our data:

create a canvas using the data on this sheet

We hit send, and bam:

Excel creates a brand new canvas sheet called Regional Sales. This is an HTML-based sheet, so we do not edit it directly. Instead, we talk to Copilot whenever we want changes. And here is the key part: this canvas is dynamically tied back to our source data.

To prove it, we cruise back to the Exercise 1 tab and change North from 2,696 to 5,000. Then we flip back to the canvas. And bam:

The dashboard updated immediately. North now leads at 5,000, the bar chart reordered itself, and the total flipped to 12,735. That is the power of a deterministic canvas solution: Copilot helps us build it once, and it runs on its own every subsequent period. No re-prompting required.

Exercise 2: Complex Data, Interactive Filters, and a Custom Logo

Now it is time to make things more interesting. Let’s take a look at the Exercise 2 worksheet:

We have a table with 12 expense transactions across multiple departments and categories. This is the kind of data that usually requires a PivotTable, several charts, and a lot of time to summarize well. Let’s see what one prompt can do.

We open Copilot and type:

summarize the data on this sheet using a new canvas

We hit send, and bam:

This time Copilot generated a much richer dashboard. We get four KPI cards at the top: total expenses, transactions, average expense, and largest expense. Below that, we have an Expenses by Category bar chart and a Department totals panel. And this canvas even includes interactive dropdowns for Department and Category filters.

We can click the Department dropdown and select Ops, or Sales, or Admin, and the entire dashboard updates instantly. No formulas to write, no slicers to wire up.

Adding a Logo

Now, what if we wanted to add our company logo? No worries, we can just ask Copilot. We open the Copilot pane, use the file upload option to attach our logo image, and tell Copilot to add it to the canvas. Copilot confirms the image is an Excel University logo and places it in the dashboard header.

The initial result looks great, but the low contrast between the white logo and the dark blue header makes it a little hard to read. So we type one more prompt:

the contrast between the logo and the dark blue header makes the company name hard to read. fix it.

Copilot reasons through the problem and updates the canvas. It adds a solid white panel behind the logo with increased padding and a border, making the logo pop against the dark header. And bam:

We can keep going back and forth with Copilot to fine-tune the look. The important thing is that the entire dashboard remains tied to our source data. Any changes on the Exercise 2 sheet flow automatically into the canvas. Mission accomplished!

Exercise 3: Store Brand Preferences in the .Rules Sheet

But what if we wanted Copilot to ALWAYS use our brand colors whenever it generates a new canvas? Well, we do not have to keep including that in every prompt. Copilot in Excel supports a special sheet called .Rules, and anything we write there acts as standing instructions for all future Copilot operations in that workbook.

To create the rules sheet, we open Copilot, click the plus icon, and choose Create workbook rules. Excel adds a .Rules tab to our workbook. Then we update the rules to include our brand colors:

when creating canvas sheets or other reports, use my brand colors:
4f9972
f6f6f6
87b99f
006633
acadbo
4b7a63
adccbc
ffbf00

One important note: the .Rules sheet must remain visible, not hidden, for Copilot to reference it. With our rules in place, we cruise back to the Exercise 3 tab and open Copilot. We type:

create a new canvas to summarize the data in the exercise 2 worksheet

We hit send, and bam:

Instead of the default blue, the new canvas uses our green brand colors throughout. The header, the bar chart bars, the KPI numbers: all on-brand. And of course, the Department and Category filters still work, and the whole thing is still tied back to our live source data. That is how we can use Copilot once to build something that runs automatically going forward.

Summary

Excel Canvas is a genuinely exciting addition to Excel. With a single Copilot prompt, we can generate polished, interactive dashboards that are dynamically linked to our source data. Exercise 1 showed us how fast a basic canvas can be created from simple tabular data. Exercise 2 demonstrated that richer datasets get richer dashboards, complete with KPI cards, category charts, interactive filters, and even a custom logo. Exercise 3 showed us how to use the .Rules sheet to lock in brand preferences so every future canvas automatically reflects our colors. The best part is this is a deterministic approach: Copilot builds it once, and it runs on its own every period going forward.

If you have any suggestions, improvements, alternatives, or questions, please share by posting a comment below … thanks!

Sample File

FAQs

What is Excel Canvas?

Excel Canvas is a new feature that generates an HTML-based dashboard sheet inside our workbook. We describe what we want using Copilot, and Excel creates a polished visual report that is dynamically linked to our source data. We do not edit the HTML directly. Instead, we use Copilot prompts to request changes.

Is Excel Canvas available in all versions of Excel?

As of this writing, Excel Canvas is rolling out to Microsoft 365 subscribers. It requires an active Copilot license. It is not available in Excel 2019, Excel 2021, or other standalone versions.

Does the canvas update automatically when source data changes?

Yes. The canvas is dynamically tied to the source data in the workbook. When we change a value on the source sheet, the canvas reflects the update without any additional Copilot prompting. That is what makes this a deterministic, low-maintenance solution.

Can we edit the canvas HTML directly?

No. The canvas sheet is HTML-based, but we are not intended to edit the code directly. All changes should be made through Copilot prompts. This keeps things manageable and avoids breaking the canvas structure.

What is the .Rules sheet and how does it work?

The .Rules sheet is a special worksheet we create via the Copilot pane by selecting Create workbook rules. Anything we write on that sheet acts as standing instructions for Copilot across the entire workbook. For example, we can tell Copilot to always use specific brand colors whenever it creates a canvas. The sheet must be visible, not hidden, for Copilot to read it.

Can we add a company logo to a canvas?

Yes. We can upload an image file through the Copilot pane using the file attachment option, then instruct Copilot to add it to the canvas. Copilot places the logo in the header area. We can follow up with additional prompts to adjust contrast, sizing, or positioning.

Can we add interactive filters to a canvas?

Copilot may automatically include dropdown filters when it detects categorical columns in the source data, such as Department or Category. We can also request specific filters in our prompt. The resulting dropdowns allow end users to slice the dashboard without needing any additional tools.

Does using Excel Canvas mean we need Copilot every time we want to refresh the report?

No, and that is one of the best aspects of this approach. We use Copilot once to build the canvas. After that, the canvas updates automatically whenever the source data changes. There is no need to re-engage Copilot in subsequent periods unless we want to make design or structural changes.

How many canvases can we create in one workbook?

We can create multiple canvas sheets in a single workbook. Each canvas can reference a different source sheet or a different subset of data. This makes it easy to build separate dashboards for different audiences or use cases, all within one file.

What kinds of data work best for Excel Canvas?

Excel Canvas works well with structured tabular data: a clear header row and consistent columns. Simple tables like regional sales figures produce clean summary visuals. Richer datasets with multiple dimensions, such as dates, categories, and departments, tend to produce more detailed dashboards with KPI cards, category breakdowns, and interactive filters.