How to Change Scale on Google Sheets Graph

A default graph in Google Sheets is a great starting point, but it's rarely the final product. To tell a clear story with your data, you need to take control of how it's presented, and that often means changing the scale of your chart’s axes. Adjusting the minimum and maximum values on your graph can highlight subtle trends, provide an honest comparison, or simply make your visualization easier to read. This guide will walk you through exactly how to change the vertical (Y-axis) and horizontal (X-axis) scale on any Google Sheets graph.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Bother Changing the Chart Scale?

Before jumping into the "how," let's quickly cover the "why." Google's default settings are designed to automatically fit your data into the chart area. While this is helpful, it can sometimes create a misleading or confusing visual. Here are a few key reasons to customize your axis scale:

• To Improve Readability: If your data points are all clustered together within a tight range, adjusting the scale lets you "zoom in" on the action, making small but significant fluctuations easier to see.
• To Provide Honest Context: A classic example of a misleading chart is one where the vertical axis doesn't start at zero. For a bar chart showing sales figures of $10,100, $10,200, and $10,500, Google might start the axis at $10,000. This exaggerates the differences between the bars, making them look dramatic. Setting the minimum value to zero provides a more truthful perspective.
• To Standardize Comparisons: If you have multiple charts on a dashboard showing related metrics (like website traffic from different sources), you'll want to set them to the same vertical scale. This allows viewers to make fair, at-a-glance comparisons between them.
• To Plot Different Data Types: If you want to show two distinct metrics on one graph - like website traffic (in the thousands) and conversion rate (a small percentage) - they need different scales. This is handled by a secondary axis, which we’ll cover below.

How to Change the Vertical (Y-Axis) Scale

The vertical axis, or Y-axis, is the one you'll adjust most often. It represents the numeric value of your data points, like revenue, sessions, or quantity. Here is the step-by-step process to customize it.

Step 1: Select Your Chart

First, either create a new chart or click on an existing chart in your sheet. A selected chart will have a blue border around it. If you need to create one, just highlight your data, go to Insert > Chart, and Google Sheets will suggest a chart type for you.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Open the Chart Editor

Double-click anywhere on your chart. This will open the Chart editor sidebar on the right side of your screen. If you only single-clicked the chart, you might instead see three vertical dots in the top-right corner. Click those dots and select Edit chart.

The editor has two main tabs: Setup and Customize. The Setup tab is for changing the chart type and data ranges. For visual changes, we need the Customize tab.

Step 3: Navigate to the Vertical Axis Settings

Click on the Customize tab in the Chart editor. You’ll see a list of customizable elements like Chart style, Chart & axis titles, and Series.

Click on Vertical axis to expand its settings menu. If you have axes on the top, bottom, left, and right, you may see options for each. For most charts (column, bar, line), the primary value axis is the "Vertical axis."

Step 4: Set Your Minimum and Maximum Values

Scroll down within the Vertical axis menu. You'll find a section for 'Scale' with input boxes for Min and Max. By default, these boxes will be empty, and Google Sheets will handle the scaling automatically.

To override this, simply type your desired values into the boxes.

• In the Min box, enter the value where you want your axis to begin (e.g., 0).
• In the Max box, enter the value where you want your axis to end. This should be slightly higher than the largest value in your data set to give it some breathing room.

Example: Imagine you're charting monthly sales, and your figures range from $42,000 to $48,500. Google's default might create an axis from $40,000 to $50,000, making the fluctuations look extreme. To show the performance in the context of your overall revenue, you could set the Min to 0. The graph will instantly update to reflect your new scale.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Other Useful Vertical Axis Settings

While you're here, you'll see a few other powerful options:

• Log scale: Check this box if your data grows exponentially. A logarithmic scale can make trends in such data much easier to see.
• Number format: This allows you to format the axis labels as currency, percentages, or other numerical formats without changing your source data.
• Text color, font size, and font style: Use these to adjust the appearance of your labels for better readability.

Adding and Customizing a Secondary (Right) Axis

What if you want to plot two different metrics on the same chart, but their scales are completely different? For instance, plotting social media followers (tens of thousands) against the click-through rate (single-digit percentages). Forcing them onto the same axis would render one of the lines completely flat and useless.

The solution is a secondary axis. Here’s how to set it up.

1. In the Chart editor > Customize tab, click on the Series section.
2. You'll see a dropdown menu that says 'Apply to all series.' Click on it and select the specific data series you want to move to a new axis (e.g., your 'Click-Through Rate' data).
3. Once that series is selected, you'll see an Axis dropdown below, which is set to 'Left axis' by default. Change this to Right axis.
4. A new vertical axis will immediately appear on the right side of your chart, scaled appropriately for the data series you selected.

Now, back in the main Customize menu, you will see a new option called Right vertical axis. You can click on this and set the Min and Max values for this secondary axis independently, using the same steps described above.

How to Change the Horizontal (X-Axis) Scale

Customizing the horizontal (X-axis) scale is slightly different because it often represents categories (like months, products, or names) rather than continuous numerical data.

To find the settings, go to the Chart editor > Customize tab and click on Horizontal axis. The options available here will depend on your chart type.

For Line, Bar, and Column Charts

For most standard charts, the horizontal axis contains labels from your data. You cannot set a numerical Min and Max value, but you can control the appearance:

• Slant labels: This is incredibly useful when you have long labels (like full dates) that would otherwise overlap. You can choose an angle like 30°, 60°, or 90° to tilt the text and fit more labels neatly.
• Treat labels as text: Tick this box if your labels are numbers (e.g., years) that Google Sheets is mistakenly trying to treat as numerical values on a continuous scale. Ticking this forces each label to be treated as a distinct category.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

For Scatter Plots and Bubble Charts

Scatter plots are different because both the horizontal and vertical axes represent numerical values. In this case, you can set the Min and Max values for the horizontal axis just like you did for the vertical one.

In the Horizontal axis menu, you will see the same Min and Max input boxes. You can use these to "zoom in" on a specific quadrant of your scatter plot to better analyze the relationship between the data points in that area. For example, if you are plotting advertising spend (X-axis) vs. website conversions (Y-axis), you could adjust the horizontal axis to only show data where spending was between $1,000 and $5,000.

Final Thoughts

Mastering the axis scale in Google Sheets elevates your reports from simple data dumps to compelling, clear narratives. By thoughtfully choosing your minimum and maximum values, you gain fine-tuned control over your chart's clarity and message, ensuring your audience can quickly grasp the key insights you want to convey.

While tweaking charts in spreadsheets is a valuable skill, the process of manually editing dashboards can start to feel repetitive, especially when you need to pull in and update data constantly. At Graphed , we've designed a way to skip the manual setup and editing entirely. We let you connect your data sources - like Shopify, Google Ads, or HubSpot - and then simply ask for the chart you want in plain English. Instead of clicking through menus, you can just ask, "Show me a line chart of my Shopify revenue versus my Facebook ad spend for the last 90 days," and we instantly generate a live, interactive dashboard that updates automatically, helping you get to the insights faster.