How to Change Intervals on Excel Graph

Excel has a knack for creating charts that are almost perfect, but it often stumbles on the details - like choosing sensible intervals for your graph's axes. Instead of clean, round numbers, you might get an axis cluttered with awkward values that make your chart hard to read. This guide will walk you through exactly how to take control and change the intervals on any Excel graph, so you can present your data clearly and professionally.

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

What Are Graph Intervals and Why Change Them?

When you create a chart in Excel, it automatically determines the scale for your axes. This includes the start and endpoints (the bounds) and the steps between the labeled tick marks (the major interval). The smaller, unlabeled tick marks are called minor intervals.

Excel’s automatic settings are fine for a quick look, but they often lack finesse for professional reporting. You'll want to change them for several common reasons:

• Improve Readability: Imagine a sales chart where Excel sets the vertical axis interval to $4,371. It’s technically correct, but incredibly difficult for anyone to quickly interpret. Changing the interval to a clean $5,000 makes the entire visualization more intuitive.
• Reduce Clutter: If you're plotting daily data over an entire year, showing a label for every single day on the horizontal axis would create an unreadable mess. Setting the interval to show a label only once a month declutters the chart and highlights the broader trend.
• Focus on a Specific Range: Sometimes, the most important part of your data exists within a narrow band. For instance, if you're tracking production quality that only fluctuates between 98.5% and 99.5%, starting the vertical axis at 0% wastes a huge amount of space. By adjusting the axis bounds (minimum and maximum values), you can "zoom in" on the meaningful fluctuations.
• Standardize Your Reporting: When creating multiple charts for a single report or dashboard, you want them to be easily comparable. Manually setting consistent intervals and bounds across related graphs (e.g., ensuring all sales charts use a $10k interval) makes your reporting look more professional and your data easier to compare.

Ultimately, learning to adjust a graph's intervals is about storytelling. It allows you to guide your audience's focus and ensure the main takeaway from your data isn't lost in a confusing, poorly formatted chart.

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

How to Change the Vertical (Value) Axis Interval

The vertical or "Y" axis is the one you'll adjust most frequently. This axis typically displays numerical values like sales, quantities, percentages, or temperatures. Let's say you've created a bar chart showing monthly revenue, but Excel has automatically set the major interval to something odd like $12,500.

Here’s how to change it to a cleaner $10,000 interval.

Step-by-Step Instructions:

1. Select the Axis: First, click on your chart to make it active. Then, move your mouse over the vertical axis labels - the numbers running up the left side of the chart. Right-click on one of the numbers.
2. Open the Format Axis Pane: In the context menu that appears, select Format Axis... This will open a settings pane on the right side of your Excel window titled "Format Axis."
3. Navigate to Axis Options: At the top of the Format Axis pane, make sure the icon that looks like a small bar chart (displaying "Axis Options") is selected.
4. Adjust the Units: Look for the "Units" section. You will see two main boxes: Major and Minor. The "Major" box controls the labeled gridlines on your graph. It is likely set to "Auto" by default. Simply click in the box, erase "Auto," and type your desired interval. In our example, you would type 10000.

As soon as you enter the value and press Enter, you'll see your chart update in real time. The awkward $12,500 gridlines will disappear, replaced by clean, easy-to-read lines at $10,000, $20,000, $30,000, and so on.

Pro Tip: Adjust the Bounds to Zoom In

While you're in the "Format Axis" pane, notice the "Bounds" section just above "Units." This is another powerful tool for improving clarity.

If all your monthly revenue figures fall between $75,000 and $120,000, you don't need your chart's axis to start at zero. A giant empty space at the bottom of the chart can flatten the visual differences between the months. To fix this, you can set a new minimum bound.

• In the "Minimum" box, replace "Auto" with a value slightly below your smallest data point, like 70000.
• Similarly, you can set a "Maximum" bound if needed.

Changing the bounds effectively zooms in on your data's variance, making trends and differences much more apparent. Just be careful - this technique can also exaggerate small differences, so use it thoughtfully.

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

How to Change the Horizontal (Category) Axis Interval

Adjusting the horizontal or "X" axis interval is common when you’re working with dates or a large number of text categories.

For Charts with Date-Based Axes

Let's say you have a line chart plotting your website traffic for every single day over the last quarter. Excel will try to display a label for each day, making the horizontal axis crowded and illegible.

1. Open the Format Axis Pane: Just as before, right-click on the horizontal axis labels (the dates) at the bottom of your chart and select Format Axis...
2. Identify the Axis Type: Excel is smart enough to recognize that this axis contains dates. In the "Axis Options" tab, you'll see that "Date axis" is automatically selected.
3. Adjust the Date Units: Under the "Units" section, you’ll find options more specific to dates. The "Major" Unit box lets you define the interval. You could, for instance, set it to show a label every 7 Days to mark each week, or every 1 Month to give a high-level overview.
4. Select a Base Unit: Use the dropdown next to the number to choose your base unit: Days, Months, or Years. Changing the Major unit from a daily interval to a monthly one can turn a chaotic chart into a clean, clear trendline.

For Charts with Text-Based Categories

What if your axis isn’t dates, but a long list of product names, employee names, or survey responses? Too many categories can also create a cramped, unreadable axis.

1. Open the Format Axis Pane: Right-click the horizontal axis and select Format Axis...
2. Find Label Options: In the "Axis Options" tab, look for a section called "Labels."
3. Specify the Label Interval: Under "Interval between labels," select the radio button next to Specify interval unit. The default value will be 1, meaning Excel shows a label for every category.

To show every other label, enter 2. To show every fifth label, enter 5. This is a quick way to thin out the category labels without removing any data from the chart itself.

Changing Intervals on Special Chart Types

While line charts and column charts are common, some charts like scatter plots and histograms have unique needs when it comes to intervals.

Scatter Plots (XY): Both Axes are Values

Unlike a line chart where the horizontal axis is a category, the scatter plot treats both the X and Y axes as numerical values. For this reason, the process for changing the intervals on the horizontal (X) axis is exactly the same as it is for changing the vertical (Y) axis. You just right-click on the horizontal axis labels, open the Format Axis pane, and adjust Bounds and Units as needed.

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

Histograms: Bins as Intervals

A histogram is all about grouping numerical data into bins. Changing the interval on a histogram means changing the number or size of bins.

• Select the Axis: Right-click on the horizontal axis at the bottom of the chart and select Format Axis...
• Adjust Bin Options: In the Format Axis pane, look for "Axis Options." You’ll see four different ways to define your bins:
• By Category: Use separate columns for each category label. This is not related to numerical intervals.
• Automatic: Lets Excel decide the optimal bin size. This is the default setting.
• Bin Width: This is where you manually enter a specific width for each bin. For example, if you're analyzing test scores, you could set a bin width of 10, creating groups like 60-69, 70-79, etc.
• Number of Bins: Instead of entering a specific bin size, you tell Excel how many total bins you want. If you enter 5, Excel will divide your entire data range into 5 equal bins.

The choice between bin width and the number of bins depends on your goals. Use "Bin Width" if you have a logical range in mind (like "ten-year age groups"). Use "Number of Bins" when you just want a quick overview of how your data is distributed.

Final Thoughts

Taking control of your chart axes is a simple yet powerful skill that can dramatically improve the clarity and professionalism of your Excel reports. Rather than accepting Excel's awkward automatic settings, you can confidently set clear, intuitive intervals that make your data easier to understand and interpret.

While manually adjusting charts in Excel is effective, it can become time-consuming when you need to manage dozens of data series or build recurring reports. We built Graphed as a faster way to get from raw data to dashboards in seconds. Instead of wrestling with axis options in Excel, you could simply ask it to create a comparative chart with 10,000 revenue intervals and have it generate the visualization instantly, saving you time and enhancing your insights.