numbers charts

Question

Level 1

22 points

numbers charts

I am trying to create an x-y scatter chart in Numbers. The directions published everywhere seem simple but don't work for me. I have also seen posts which have the same problem I have but no solution.

I select two different data columns command clicking on the column letter name, I insert a 2D scatter chart, and get a straight line of dots. The data from one column only is used on both axis. I go to the formatting sidebar and try to change one of the axis. Either nothing changes or the other axis changes to agree. Always a straight line. What am I missing?

Mac mini 2018 or later

Posted on Apr 10, 2022 5:29 PM

Reply

Answer 1

Best reply

Badunit

Level 7

26,656 points

Apr 10, 2022 7:04 PM in response to thermo2

Unlike the other charts, the scatter chart requires the X axis data to be in "regular" cells, not in a header column or header row. It sounds like your X data is in the header column and, as such, it is being ignored. When there is no X data it plots Y vs Y, which will be a straight line.

It is probably easiest to start over on the chart. In your table, move your data rightward one column so X and Y are both in "regular" cells or, alternatively, leave them where they are, go to the Table tab in the sidebar and set the number of header columns to zero. Now make the chart.

Reply

Answer 2

SGIII

Level 8

35,504 points

Apr 10, 2022 8:46 PM in response to thermo2

If you haven't done so already, be sure to have a look at the working examples of X-Y Scatter (and other) charts in the 'Charting Basics' template at File > New in your menu.

Charts often require experimentation, and it can be helpful to study examples to see what works.

SG

Reply

numbers charts

Similar questions