How to Change Size of Sheet in Dashboard Tableau
Wrangling worksheets on a Tableau dashboard to get them perfectly sized is a universal challenge. You drag a border, another sheet shifts unexpectedly, and suddenly your whole layout is off. This guide will walk you through the various ways to change the size of a sheet on your dashboard, from simple dragging to more precise container controls.
Understanding Tableau's Layout Foundation: Containers
Before you can effectively resize any sheet, you need to understand how Tableau structures its dashboards. Almost every element you place on a dashboard lives inside a layout container. These containers dictate how objects interact and resize. There are two main types of objects and two primary containers.
Objects: Tiled vs. Floating
- Tiled: This is the default. When you drag a sheet onto a tiled dashboard, it snaps into place, filling an entire section. Tiled objects cannot overlap and will automatically resize other tiled objects as you add or remove them.
- Floating: Floating objects can be placed anywhere on the dashboard, even on top of other objects. They have fixed sizes and positions unless you manually change them. While useful for specific elements like text boxes or legends, this guide focuses on resizing sheets within the more common tiled layout.
Containers: Vertical and Horizontal
When you use the default tiled layout, Tableau automatically places your sheets into vertical or horizontal containers.
- Vertical Containers: Stacks sheets on top of one another. When you resize a sheet's height, it affects the sheets above or below it. Think of it like a stack of books - if you make one book taller, the whole stack grows.
- Horizontal Containers: Arranges sheets side-by-side. When you resize a sheet's width, it affects the sheets to the left or right. Think of it like a row of folders in a filing cabinet - if you widen one folder, the others have less space.
Understanding which container your sheet is in is the first step to predictable resizing. You can see the container structure by selecting an object and looking for the blue outline around its container. Clicking the small grey tab at the top of the container shows its type.
Method 1: The Simple Drag-and-Drop
The most straightforward way to resize a sheet is to simply click and drag its border. This is best for quick, approximate adjustments when pixel-perfect precision isn't critical.
How to Do It:
- Navigate to your dashboard in Tableau.
- Hover your mouse over the border between the sheet you want to resize and its adjacent sheet.
- Your cursor will change to a double-headed arrow (either vertical or horizontal, depending on the container).
- Click and hold the left mouse button.
- Drag the border to increase or decrease the size of the sheet. Tableau will show a faint gray line indicating the new position.
- Release the mouse button when you're satisfied with the new size.
When to use this: This method works best for simple layouts with only two or three sheets in a container. It gives you a feel for how the layout shifts.
What to watch for: It's easy for this to become a game of whack-a-mole. Resizing one sheet directly takes away space from its neighbor, and in complex dashboards, you might find yourself continuously nudging borders back and forth. It lacks precision.
Method 2: Using Edit Height / Edit Width for Precision
When you need more control than the drag-and-drop method offers, you can specify an exact pixel dimension. This is excellent for ensuring consistent sizes across different elements.
How to Do It:
- Click on the specific worksheet you want to resize so it's selected (it will have a gray border).
- Click the small down arrow in the top right corner of the selected worksheet to open its context menu.
- Depending on the container, you will see an option for Edit Height... (for vertical containers) or Edit Width... (for horizontal containers). Click it.
- A small box will appear asking you to enter a specific pixel value.
- Enter your desired size and click "OK." The sheet will immediately snap to that dimension.
Pro Tip: There's also a "Fixed Height" and "Fixed Width" option in the same menu. Fixing a dimension tells Tableau that sheet size is non-negotiable. This can be powerful, but use it sparingly. If you fix the height of every sheet in a vertical container, Tableau won't be able to fit them all, leading to scroll bars or cut-off content.
Method 3: The Power Move - Distribute Evenly
Have you ever tried to create a row of three KPI boxes and spent ages dragging the borders to make them look equal? The "Distribute Evenly" feature solves this problem in one click. It automatically resizes all items within a container to be the exact same width or height.
How to Do It:
- First, make sure all the items you want to evenly size are inside the same layout container. The easiest way is to add a fresh horizontal or vertical container to the dashboard, then drag your worksheets into it.
- Select the container itself, not an individual sheet. You do this by clicking the gray tab at the top of the container's blue dashed outline.
- Click the down arrow on the selected container to open its context menu.
- Select the option Distribute Contents Evenly.
Instantly, all the sheets within that container will snap to an identical width (if in a horizontal container) or height (if in a vertical container). This is a game-changer for creating clean, professional, and symmetrical dashboards.
Method 4: Leveraging Worksheet "Fit" Options
Sometimes the issue isn't the container size but how the worksheet's content fits within that container. After selecting a worksheet on your dashboard, look for a "Fit" dropdown menu in the toolbar or in the Layout pane on the left.
This setting controls how the underlying visualization (the 'viz') stretches or shrinks to fill the space you've given it. There are four options:
- Standard: This is the default. The worksheet maintains its original, pre-determined size from when it was built in the worksheet view. If the dashboard container is smaller than the sheet, you'll get scroll bars. If larger, you'll see blank white space.
- Fit Width: This dynamically stretches your viz horizontally to fill the entire width of its container. This is extremely useful for things like tables or horizontal bar charts where you want to eliminate the horizontal scrollbar and use all available screen real estate.
- Fit Height: This stretches your viz vertically to fill the height of its container. You'll often use this for long lists or vertical charts, but it's generally less common than 'Fit Width'.
- Entire View: This option stretches the viz both horizontally and vertically to fill every available pixel in its container. Be very careful with this one! While it sounds helpful, it can severely distort your visuals. Bar charts can become wide and squat, while maps might look unnaturally stretched. It's best used for single-value text boxes or vizzes where proportion doesn't matter as much.
Troubleshooting Common Sizing Problems
Even with these tools, you can still run into issues. Here are some common problems and how to resolve them:
Problem: "My sheet won't resize no matter what I do!"
Solution: The culprit is often either a fixed dimension or the overall dashboard size.
- First, check if the sheet (or an adjacent sheet) has a "Fixed Height" or "Fixed Width" set. If so, uncheck it to allow flexibility.
- Next, look at your overall Dashboard sizing in the left pane. If your dashboard size is "Fixed," your sheets have a finite amount of space to work with. You may need to increase the dimensions of the entire dashboard to make room. Consider switching to "Automatic" if you want the dashboard and its contents to resize based on the viewer's screen size.
Problem: "My text is getting cut off or wrapping strangely."
Solution: This usually happens when "Fit Width" or "Entire View" is used on a worksheet with a lot of text or labels. The container is too small, and Tableau is trying its best to cram everything in. The solution is either to increase the container's size by dragging its borders or to change the fit setting back to "Standard" and accept the scroll bar.
Problem: "When I use 'Distribute Evenly,' one chart looks huge and another looks tiny."
Solution: The sheets themselves contain different amounts of visual information. 'Distribute Evenly' only makes the containers the same size. For instance, if you 'Distribute Evenly' three charts - a single big number (KPI), a dense table, and a sparse line chart - the containers will be equal, but the single big number will appear surrounded by white space while the dense table will look cramped. In these cases, it's better to manually resize the sheets to give more room to the more complex vizzes.
Final Thoughts
Mastering sheet sizing in Tableau comes down to understanding that you aren't just resizing a chart, you're managing space within a system of nested containers. By using a combination of direct dragging for quick adjustments, 'Distribute Evenly' for symmetry, and 'Fit' options for content display, you can build dashboards that are functional, clean, and perfectly proportioned.
While mastering Tableau is rewarding, sometimes you need insights without the setup time. We've spent countless hours navigating complex layout options ourselves, which is why we built Graphed. Instead of wrestling with containers, you use plain language - like "create a sales pipeline dashboard in a 3x3 grid" - and our AI builds it instantly, handling all the sizing and arrangement so you can get straight to the insights.
Related Articles
How to Enable Data Analysis in Excel
Enable Excel's hidden data analysis tools with our step-by-step guide. Uncover trends, make forecasts, and turn raw numbers into actionable insights today!
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.