I'm struggling with 2D Line and 2D Scatter plots in Numbers (v11.2). Consider that I have a very simple table where the first column is a header column :
|Stuff (header column)
I'd like to plot the curve of
Things as a function of
Stuff, but since
Stuff is not linear, I cannot use the 2D Line Plot because it does not scale the X-axis according to the values, they are spaced evenly. However, when I try to use a 2D Scatter Plot, I cannot select the Stuff column to be the X values. This simply does not work.
I can bypass this limitation with workarounds such as:
- remove the header column, create the scatter plot, then make it again a header column; and
- going to the "Series" menu and selecting the column manually.
However, this does not work in every situation, for instance, if the table is a Pivot Table (a recent feature) then I cannot use the Series menu nor remove the header columns.
Last, another related issue I'm facing: contrary to a line plot, I cannot find a way to change the intervals/steps between X-axis values, they seem to be automatically arranged. Is there a way to put specific values?
I searched in all menus but I was not able to find a viable option. Is there any solution to make it work properly or should I use a better-suited software that allows selecting any column with our restriction?.
However, I'm not able to reproduce the solution in my specific case, i.e. when the first column is a header column. The Apple documentation says that for a Scatter Plot you can select a column by clicking the letter of the column, but it does not work for a header column.