How to Resize Graph in Tableau
Getting your graph to the perfect size in Tableau can feel surprisingly tricky. You build a beautiful bar chart on your worksheet, drag it onto a dashboard, and suddenly it either shrinks to a tiny sliver or explodes to fill the entire screen. This common frustration comes from Tableau’s powerful - but particular - way of handling object dimensions.
This tutorial will walk you through exactly how to resize your graphs and charts. We’ll cover the essential controls on both the individual worksheet and the final dashboard, giving you complete command over your report's layout.
Why Sizing in Tableau Can Seem So Tricky
Before diving into the "how," it helps to understand the "why." A Tableau report is built in two main areas: the Worksheet and the Dashboard. Sizing works differently in each, and understanding this distinction is the first step to mastering your layouts.
- Worksheets are where you create a single chart or graph (a "viz"). The sizing options here are focused on how an individual chart should render its data within its own boundaries - for example, whether bars should stretch to fill available space or remain a fixed size.
- Dashboards are where you arrange one or more worksheets (along with other objects like text) into a final presentation. Sizing controls on a dashboard are about how much space each worksheet gets relative to other objects on the page.
Most sizing problems happen when the settings on your worksheet conflict with the settings on your dashboard. Let's fix that.
How to Resize a Chart in a Tableau Worksheet
Start by adjusting the size settings on the individual worksheet. These settings determine how your chart will behave when you place it on a dashboard later.
Your primary tool on the worksheet is the ‘Fit’ menu in the toolbar.
Here’s what each ‘Fit’ option does:
- Standard: This is the default. The chart’s size is determined by the number of data points, labels, and headers. If you have many bars, the chart will be wide. If you have few, it will be narrow. This setting often causes charts to appear too small or too large on a dashboard because it maintains its original worksheet dimensions.
- Fit Width: This useful setting forces the chart to stretch horizontally to fill the entire width of whatever container it's in. The height remains determined by the data. This is great for vertical bar charts or line charts where you want them to span the full width of your dashboard.
- Fit Height: The opposite of Fit Width. The chart stretches vertically to fill the height of its container, while the width remains determined by the data. This is ideal for horizontal bar charts or timelines.
- Entire View: This option forces the chart to expand both horizontally and vertically to fill all available space in its container on the dashboard. It’s useful for maps, summary scorecards, and scatter plots, but can sometimes distort the proportions of bar or line charts, making them harder to read.
For most reports, starting with Fit Width for your charts is a good rule of thumb. It makes arranging them on a dashboard much more predictable.
Adjusting Cell and Mark Size
Beyond the ‘Fit’ control, you can also adjust the physical size of the visual elements themselves.
1. Changing Cell Size
For more granular control, you can manually adjust the "cell" that contains each data mark. This is especially helpful if your bars look too thin or spaced too far apart.
- Navigate to the top menu and select Format > Cell Size.
- A pane will open on the left with two sliders.
- Use the ‘Taller/Shorter’ slider to adjust the height of a mark’s cell.
- Use the ‘Wider/Narrower’ slider to adjust the width.
These controls are interactive, so you can see the results immediately. This is great for fine-tuning the visual density of your chart.
2. Changing a Mark’s Size
You can also control the size of the marks themselves, like the thickness of bars or the radius of circles on a scatter plot.
- On the ‘Marks’ card, click the ‘Size’ button.
- A slider will appear. Dragging it left makes the marks smaller (e.g., thinner bars), while dragging it right makes them larger (e.g., thicker bars).
This is different from changing Cell Size. Changing the mark size keeps the container cell the same dimension but shrinks or expands the visual element inside it.
How to Control Graph Size on a Tableau Dashboard
Once you’ve set the ‘Fit’ on your worksheet, it’s time to arrange it on a dashboard. Here, you have three primary methods for controlling the size: dragging borders, using layout containers, and setting fixed sizes in the Layout pane.
1. Dragging Dashboard Containers (Tiled vs. Floating)
When you drag a sheet onto a Tableau dashboard, you can add it as either Tiled or Floating.
- Tiled (Default): When you drop a tiled object, Tableau automatically places it into a grid layout that resizes to fill the screen. It can’t overlap with other tiled objects. To resize a tiled graph, hover your mouse over the border between two sheets. Your cursor will turn into a double-arrow. Click and drag the border to give one sheet more space and the other less.
- Floating: To add a floating chart, hold down Shift while dragging the sheet onto the dashboard. A floating chart can be placed anywhere, even on top of other objects. To resize a floating chart, simply click on it and drag any of the corners or edges, just like you would with an image in a presentation.
While floating offers more freedom, tiled dashboards are generally easier to manage and resize dynamically for different screen sizes.
2. Using Layout Containers for Precise Control
For the most professional-looking dashboards, use Layout Containers. These are objects that group your worksheets together, allowing you to organize your layout logically.
- Horizontal Container: Arranges all sheets placed inside it in a left-to-right row. All sheets inside will have the same height.
- Vertical Container: Arranges all sheets placed inside it in a top-to-bottom column. All sheets inside will have the same width.
To use them:
- Drag a Horizontal or Vertical container from the Objects pane onto your dashboard.
- Drag your worksheets into that container.
- Now, when you resize the container, everything inside resizes with it. You can even use the ‘Distribute Evenly’ option (by clicking the container's dropdown arrow) to make all charts inside it the exact same size instantly.
3. Fine-Tuning with the Layout Pane
For pixel-perfect final adjustments, use the Layout pane. This is where you can manually enter the exact position and size of any dashboard object.
- Click on the graph you want to resize on the dashboard.
- Go to the ‘Layout’ tab on the left-hand pane (next to the ‘Dashboard’ tab).
- Here you will see the object's Position (x,y) coordinates and its Size (W,H) in pixels. You can type in the exact numbers you want.
This is the best way to ensure multiple floating charts are perfectly aligned or that a tiled chart meets specific sizing requirements without relying on dragging.
Best Practices for Dashboard Sizing
Finally, keep a few high-level tips in mind to make your life easier and your dashboards more effective.
- Choose a Fixed dashboard size: In the 'Layout' pane, you can set the
Sizeof your entire dashboard. While 'Automatic' sounds helpful, it often results in your beautiful layout looking stretched or squished on different screen sizes. Manually setting a fixed size (e.g., 1000 x 800) ensures a consistent viewing experience for everyone. - Leave some white space: Don't cram every pixel of your dashboard with information. Leaving a little padding around your charts makes the entire report easier to read and less overwhelming. You can add blank objects from the Objects pane as spacers to create this effect.
- Fit Width is your friend: Setting worksheets to ‘Fit Width’ before you add them to a dashboard solves many common sizing issues, especially when using vertical layout containers.
- Keep it simple: The more charts you have on a single dashboard, the harder it will be to manage their sizes. Focus on presenting only the most necessary information needed to make a decision.
Final Thoughts
Mastering graph sizing in Tableau is all about understanding the relationship between the worksheet’s ‘Fit’ settings and the dashboard’s container-based layout. By configuring your charts correctly at the worksheet level, you can use tiled containers, floating objects, and the layout pane to build clean, professional, and easy-to-read reports every time.
While getting your pixels perfect in Tableau is a valuable skill, it often comes after hours of manual tweaking. We built Graphed because we believe creating an insightful dashboard shouldn't require fighting with layout containers or spending your afternoon formatting charts. Instead, you can describe what you want in plain English, and our AI instantly builds real-time dashboards from your connected data sources like Google Analytics, Shopify, or Salesforce - letting you focus on insights, not styling.
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.