Axis range for Charts in Numbersl

I've encountered a peculiar behavior using Numbers on my iPad. I'm using version 15.1 of Numbers and iPadOS 26.2.1.



As a test, I created both the table and graph. It's just a simple graph of the sine function from π to 2π.


When I select the x and sin(x) columns starting at the headers and create an x/y scatter chart, the x axis of the graph starts at zero even though the range of x in the table starts at pi.


When I look at the dialog box to set the minimum and maximum x axis range, both fields show Auto. I thought Auto would scale the x axis of the graph based on my table in the range of π to 2π, but the x axis starts at zero.


Thus, I need to manually adjust the axis scale (min of 3.142 and max 6.283) in the chart fornatting section.


I thought Auto in the X and Y axis max and min fields meant that the scale of each axis would get its values from my table. If each field is set to Auto shouldn't that mean that the graph would use my table's values to scale the chart?


Any help would be greatly appreciated.


Thank you.

iPad Air

Posted on Feb 6, 2026 3:49 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 6, 2026 11:31 AM

Your problem is that your X values are not in a header column.


Numbers uses the header column to determine the axis range. Your table has X values in column D, but column A is your header column, and it's column A that's its basing the axis on.


Move your data left so that the X values are in a header column and you should be good to go:



That isn't an absolute requirement - you can override the setting to use whatever range you want, but if you want Numbers to do it automatically, then header columns are your key.

7 replies
Question marked as Top-ranking reply

Feb 6, 2026 11:31 AM in response to gulmatan

Your problem is that your X values are not in a header column.


Numbers uses the header column to determine the axis range. Your table has X values in column D, but column A is your header column, and it's column A that's its basing the axis on.


Move your data left so that the X values are in a header column and you should be good to go:



That isn't an absolute requirement - you can override the setting to use whatever range you want, but if you want Numbers to do it automatically, then header columns are your key.

Feb 6, 2026 2:13 PM in response to gulmatan

> Why is my chart supposed to be the chart on the lower left and not the x/y scatter chart?


In general, scatter plots are best used to compare non-linear, discrete data.. maybe you're a runner and you want to compare your race time to the ambient temperature so you can see if there's a correlation between your pace and the weather, or maybe you're an investor looking for stock picks and want to visualize various companies' earning vs. their employee count (or any other metric that interests you)

In these cases, any single data point is unconnected to others e.g. Company A's earnings/employees is not directly connected to Company B's earnings/employees, but you might see a pattern, or find the outliers that are high (or low) value investments.

In these. charts you can look at the overall to see patterns, but the space between the values is irrelevant.


Line charts, on the other hand, generally show connected or linear data. Like your x -> sin(x), there is a direct linear progression, and the view can infer values of sin(x) from looking at the graph, even if there isn't a direct data point for the x value in question.


> how am I supposed to format the number of subdivisions of the major & minor X & Y axis lines?


If you select the table itself (not a data series), you should have options in the Inspector -> Axis


For the Y axis you can override the Min and Max values, as well as define how many major/minor steps to break the chart into. Further down you can choose the line weight and color for the major and minor lines:



If you switch to the X axis you can choose how many of the X-axis categories should be shown, and the format of the gridlines between them.

Feb 6, 2026 12:56 PM in response to Camelot

Hi. I wish that would work. But, after trying that over 10 times and after deletinv & reinstalling Numbers that many times, it still doesn't work. And, I've updates to iPad and iOS 26.2.1. Plus, as I've reinstalled Numbers I'm running the laters Numbers version, 15.


What chart type are you selecting? The one in the last row of graphs with two plot lines or the X/Y scatter graph with data points as x marks?

Feb 6, 2026 1:23 PM in response to Camelot

Thanks. Logically, I'd think should select an x/y scatter plot. Why is my chart supposed to be the chart on the lower left and not the x/y scatter chart? And, if it's supposed to be the chart type on the lower left, how am I supposed to format the number of subdivisions of the major & minor X & Y axis lines?


I've tried adjusting the X axis major and minor subdivisions, but I can only set those for the Y axis.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Axis range for Charts in Numbersl

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.