How to Overlay Two Sheets in Tableau Dashboard

Want to place one chart directly on top of another in your Tableau dashboard? This layering technique, known as overlaying sheets, is a fantastic way to create more dynamic, information-dense, and professional-looking reports. This guide will show you precisely how to do it using floating objects, a simple but powerful feature that unlocks a new level of dashboard design.

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

Why Would You Want to Overlay Worksheets in Tableau?

Before we jump into the "how," let's quickly cover the "why." Arranging visualizations in a standard grid is fine, but sometimes you need more flexibility. Overlaying sheets lets you go beyond the traditional tiled layout and opens up several design possibilities.

• Provide Better Context: You can place a Key Performance Indicator (KPI) card, like total sales, directly over a map. This lets your audience connect the big-picture number to the geographical breakdown without having to look back and forth between two separate charts.
• Save Valuable Real Estate: Dashboards often have limited space, especially when designed for mobile viewing. Layering a smaller chart or text box on top of a larger one allows you to present more information in the same amount of space.
• Improve Dashboard Aesthetics: Let's be honest - looks matter. A sleek, custom design with layered elements can make your dashboard feel more like a polished, professional application instead of a simple grid of charts. It gives you an incredible amount of creative control.
• Create Advanced Chart Types: Some custom visualizations are built by carefully layering different worksheets. For example, placing a text-only worksheet over a bar chart can give you more control over labels or annotations than the default settings allow.

The Secret to Overlays: Tiled vs. Floating Objects

The entire concept of overlaying sheets in Tableau hinges on understanding one fundamental choice: Tiled versus Floating objects. When you drag an object (like a worksheet, text box, or image) onto a dashboard, you decide how it will behave.

Think of it as decorating a room:

• Tiled Objects: This is like arranging heavy furniture. Everything snaps into place in an organized grid. If you place a bookshelf, the couch has to move over to make room. You can resize them, but they will never overlap. It keeps things neat and automatically aligned, but it's restrictive.
• Floating Objects: This is like hanging pictures on the wall. You can put them anywhere you want, on top of each other, at any size, with pixel-perfect control. This is the freeform mode that gives you the freedom to layer elements and create overlays.

By default, Tableau Dashboards start in Tiled mode. To overlay sheets, you simply need to switch to Floating mode. It’s that easy.

How to Overlay Two Sheets: A Step-by-Step Guide

Ready to build one? Let's walk through the process using a common example: placing a total sales KPI card over a sales map.

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 1: Create Your Two Worksheets

First, you need the individual views (the sheets) that you want to layer. For our example, let's create two simple sheets:

1. The "Background" Sheet: Go to a new worksheet and create a simple map. Double-click the State geographic field, then drag the Sales measure to the Color mark. We’ll call this sheet "Sales Map."
2. The "Foreground" Sheet: Create another new worksheet. Drag the Sales measure to the Text mark. This creates a simple text table showing the grand total. We’ll call this sheet "Total Sales KPI."

Step 2: Create a New Dashboard

At the bottom of your Tableau window, click the "New Dashboard" icon (the one that looks like a window with a plus sign).

Step 3: Add Your Background Sheet as a Tiled Object

When you start a new dashboard, it defaults to Tiled mode. This is perfect for our background sheet because we want it to provide a stable, perfectly sized foundation.

In the Dashboard pane on the left, you'll see your worksheets listed. Drag the "Sales Map" sheet onto the empty dashboard canvas. It will automatically fill the entire space.

Step 4: Switch to Floating Mode

Here comes the key move. In the Objects section of the Dashboard pane (look just below your list of sheets), you’ll see a setting that says "Tiled," which is currently selected. Click on "Floating" to switch modes. From now on, any object you drag onto the dashboard will float on top of the existing view.

Step 5: Add Your Foreground Sheet

Now that you're in Floating mode, drag your "Total Sales KPI" sheet from the sheet list onto the dashboard. You’ll immediately notice the difference - it appears in a floating box that you can drag around freely and place directly on top of your map.

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 6: Position and Resize the Floating Sheet

Click and drag the floating "Total Sales KPI" sheet to position it where you want on the map (a corner is usually best). You can also use the handles on its border to resize it until it looks right.

Step 7: The Magic Trick - Make the Background Transparent

You'll notice your floating KPI card has a solid white background, which awkwardly blocks part of the map. The key to a seamless look is to make that background transparent.

1. Select the floating "Total Sales KPI" sheet on your dashboard.
2. Go to the main menu and click Format > Shading....
3. In the Formatting pane that appears on the left, ensure you are editing the "Total Sales KPI" sheet.
4. Under the "Worksheet" dropdown, set the color to None.

Voilà! The white background disappears, and your text now appears to be floating directly over the map. You can further format the text (make it bigger, change the color) to ensure it stands out.

3 Practical Examples of Sheet Overlays

Once you master that basic technique, you can use it to create all sorts of intelligent designs. Here are a few common use cases.

Example 1: Placing Key Metrics Over a Regional Map

As we just built, this is a classic and highly effective use case. You can stack multiple floating KPIs over your map - one for Total Sales, another for Profit, and a third for Number of Customers. This creates a powerful summary view by combining headline metrics with their geographic distribution.

Example 2: Adding an Explanatory Note Over a Graph

Imagine you have a line chart showing website traffic over time, and there's a big, noticeable spike in the data. You can create a simple floating text box and place it directly near the spike with an annotation like, "Spike due to viral social media post on June 15th." This adds an immediate, clear explanation for anyone viewing the dashboard.

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

Example 3: Creating a Custom Visual Legend

Tableau's default legends are functional but can be a bit boring or inflexible. You can hide the default legend and instead create a new worksheet that acts as a custom, graphical legend with your own text, colors, and shapes. Then, float this custom legend sheet somewhere on your view for a much more polished and branded look.

Tips for Keeping Your Floating Dashboards Organized

Floating objects give you freedom, but with that freedom comes the possibility of chaos. Here are a few tips to keep your dashboard clean and functional.

• Use a Fixed Dashboard Size: Floating layouts can sometimes re-align unexpectedly on different screen sizes. To avoid this, set your dashboard to a fixed size (e.g., 1200 x 800 pixels). You can find this setting in the Dashboard pane under Size.
• Leverage Floating Containers: If you plan on layering multiple floating items, consider placing them inside a floating container first. This groups them, allowing you to move them around as a single unit, which is much easier to manage.
• Manage the Order: Just like layers in a graphic design tool, you can control which floating object is in front. If one sheet is covering another unintentionally, right-click the item you want to adjust and select Floating Order > Bring to Front or Send to Back.
• Be Mindful of Interactivity: Remember that any chart on top will block the user from interacting with the chart underneath it. You can't click on a state through a floating KPI card placed over it. Plan your layouts accordingly.

Final Thoughts

Overlaying sheets using floating objects is a game-changer for anyone looking to build more effective and visually compelling dashboards in Tableau. By simply switching from Tiled to Floating mode and layering your visualizations, you gain an extraordinary amount of design control to tell your data story exactly how you want to.

Even with simple tricks, building a polished dashboard often requires a lot of manual clicks, formatting, and know-how. We created Graphed to remove this friction entirely. Instead of dragging and dropping and formatting, you can connect your data sources (like Google Analytics, Salesforce, or Shopify) and describe the dashboard you need in plain English. We turn hours of tweaking visualizations into a 30-second conversation, letting you get straight to the insights.