How to Change Y-Axis Range in Tableau

Having trouble getting your Tableau charts and graphs to look just right? Often, the default view is good enough, but to really tell a compelling story, you need to take control of how your data is displayed - starting with the Y-axis. Adjusting its range can help you zoom in on important details or standardize visualizations across a dashboard. This guide will walk you through exactly how to change the Y-axis range in Tableau, from setting a simple fixed range to creating interactive, dynamic axes.

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 Customizing the Y-Axis Range in Tableau Matters

Before jumping into the "how," it's helpful to understand the "why." By default, Tableau automatically sets the axis range to accommodate all your data points, from the minimum to the maximum value. While this is efficient, it’s not always ideal for analysis. Here are a few reasons why you’d want to manually adjust it:

• Focusing on Specific Data: If you have one or two major outliers, Tableau's automatic axis might zoom out so far that the meaningful variations between smaller data points become invisible. Setting a specific range lets you cut out the noise and focus on the data that matters.
• Comparing Visualizations: When you place multiple charts side-by-side on a dashboard, you want them to be comparable. If one chart has an axis from 0 to 1,000 and the other goes from 0 to 100, a bar that looks tall on the second chart might barely register on the first. Manually setting both axes to the same range (e.g., 0 to 1,000) provides a true apples-to-apples comparison.
• Improving Readability: Sometimes, you need to highlight performance against a target that isn't at the top of the scale. Fixing the axis to extend slightly beyond a Key Performance Indicator (KPI) makes it easier for your audience to see who is meeting the goal.

The Primary Method: Using the Edit Axis Dialog Box

The main control center for any axis in Tableau is the Edit Axis dialog box. All the methods we’ll cover start here. Accessing it is simple:

1. Navigate to your worksheet with the chart you want to modify.
2. Hover your cursor over the Y-axis (the vertical axis) of your chart.
3. Right-click on the axis header.
4. Select "Edit Axis…" from the context menu that appears.

This will open a new window with several tabs. For changing the axis range, you'll mainly work within the General tab, specifically the Range section.

By default, the Range is set to "Automatic." Let's look at how to change that.

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

Walkthrough 1: Setting a Fixed Axis Range

A fixed axis is the most common and straightforward way to customize your Y-axis. It locks the axis to a specific start and end point that you define. This is perfect for when you already know the exact range you want to display.

Example Scenario: You're looking at monthly sales, and most values fall between $50,000 and $150,000. However, a single sale in December hit $500,000, skewing the chart and flattening the rest of the data. You want to zoom in on the typical monthly performance.

Here’s how you set a fixed range:

1. Open the Edit Axis dialog box by right-clicking your Y-axis and selecting "Edit Axis…"
2. In the window, locate the Range section.
3. Select the Fixed radio button.
4. Two new fields will appear: Fixed start and Fixed end.
5. Enter "50000" into the Fixed start field and "150000" into the Fixed end field.
6. You can leave the tick mark settings on "Automatic" or manually define them further down if needed.
7. Click "Close" (the 'X' button) to apply the changes.

Your chart will immediately update, showing only the data between $50,000 and $150,000. Data points outside this range won't be visible, but the axis gives a clear and focused view of your core performance.

Walkthrough 2: Creating a Dynamic Axis Range with Parameters

What if you want to give your viewers control over the axis range? This is extremely useful for interactive dashboards where different users might want to explore different parts of the data. For this, we can use Parameters. This method is a bit more involved but unlocks powerful interactivity.

Example Scenario: You’ve built a sales performance dashboard for regional managers. Each manager is interested in a different sales band - some want to see top performers above $200k, while others want to analyze underperforming products below $20k. A dynamic axis will let them decide what to see.

Step 1: Create Your Parameters

First, we need to create two parameters: one for the minimum axis value and one for the maximum.

• On the Data pane (top left), click the dropdown arrow next to the search bar and select "Create Parameter…".
• Configure the first parameter for your minimum value:
• Click "OK."
• Repeat the process to create your maximum value parameter:
• Click "OK."

Now, right-click on each of the new parameters in the Data pane and select "Show Parameter" to make them visible on your worksheet.

Step 2: Connect Parameters to the View with Reference Lines

This is where the magic happens. We'll add invisible reference lines to the chart that are tied to our parameters. When the parameter values change, a hidden reference line moves, and the axis automatically rescales to include it.

• Navigate to the Analytics pane (next to the Data pane).
• Drag a Reference Line from the Analytics pane and drop it onto the chart canvas. Choose the scope - typically "Table" or "Pane" will work.
• In the settings window for the reference line:
• Click "OK."
• Repeat this entire process, but connect the second reference line to your "Max Y-Axis Value" parameter.

Now, when you or your dashboard users type new values into the "Min Y-Axis Value" and "Max Y-Axis Value" boxes, the chart axis will automatically resize to fit those boundaries! This gives your audience complete control over their analysis.

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

Walkthrough 3: Synchronizing Dual Axes

A dual-axis chart is a fantastic way to compare two different measures with different scales, like plotting Sales (in dollars) and Profit Ratio (in percentage) on the same chart. The challenge is that Tableau creates two independent Y-axes - one on the left and one on the right - that may not align.

Example Scenario: You are charting Sales (ranging from $10k to $100k) and Quantity Ordered (ranging from 50 to 300). Without synchronized axes, a slight dip in Sales might look like it aligns with a big spike in Quantity, which could be misleading.

Synchronizing the axes forces both to use the same scale, aligning the data marks proportionally. Here's how:

1. Create your dual-axis chart. (You do this by adding two measures to the Rows shelf, then right-clicking the second pill and selecting "Dual Axis").
2. You will now have a Y-axis on the left and a Y-axis on the right.
3. Right-click on the right-side Y-axis.
4. Select "Synchronize Axis" from the menu.

That’s it! The two axes will immediately lock to the same range, resolving any scaling misinterpretations and giving you a true, integrated view of how the two measures trend together. As a final touch, you could right-click the right-side axis again and uncheck "Show Header" to declutter the view, since it's now redundant.

Best Practices and Common Pitfalls

Changing the Y-axis range is a powerful tool, but it's important to use it wisely to avoid creating misleading charts.

Mind the Zero Baseline on Bar Charts

Bar charts are understood by comparing the length of the bars. Starting your Y-axis at a value other than zero can dramatically exaggerate the differences between them. A chart comparing sales of $95k and $100k looks completely different if the axis starts at 90k instead of 0. For bar charts, always try to start your Y-axis at zero unless you have a compelling reason not to.

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

When It’s Okay to Start Above Zero

For line charts that visualize changes over time, starting above zero is often acceptable and necessary. If you're plotting a stock price that fluctuates between $150 and $155, starting the axis at 0 would make the line appear almost flat, hiding the very volatility you want to show.

Consider a Logarithmic Scale

If you have data with an incredibly wide range of values (e.g., website traffic for a few small cities and one giant one), the small values can get lost. In the "Edit Axis" dialog, you can check the box for Logarithmic scale under the "Scale" section. This plots your data on an exponential scale, making it much easier to see proportional changes across vastly different magnitudes.

Final Thoughts

Mastering a small detail like the Y-axis range can dramatically improve the clarity and impact of your Tableau visualizations. Whether you are locking in a fixed view for clear comparisons, empowering users with dynamic parameters, or synchronizing dual axes, you now have the tools to make your charts tell the exact story you intend.

While Tableau offers detailed control over your visualizations, we know manually setting up reports and tweaking axes still takes time. We built Graphed to remove these steps entirely. Instead of configuring dashboards piece by piece, you can connect your data sources and simply ask in plain English for what you want to see. For example, asking "Show me a dashboard of a Facebook Ads funnel with spend vs. revenue by campaign" instantly creates a real-time view, letting you skip the setup and get straight to the insights you need.