Axis are the wrong Scale for my Data

Question

Level 1

0 points

Axis are the wrong Scale for my Data

Im inserting a scatter graph using Numbers and putting the data into two columns.

After I select the data, and select the "Scatter Graph" option, the data graphs in the correct shape, but for some reason does not show the correct values in the Y or X axis. I have tried everything I could think of.

And also, very sorry if this is a simple 'click-fix' problem 😉

I have attached pictures to explain what I mean. Oh and ignore the random "legend" passing through the x-axis. I just plotted it quickly to upload to AppSup.

Thanks! 😀

e

MacBook Pro, OS X Mountain Lion

Posted on Aug 9, 2012 4:55 PM

Reply

Answer 1

daveg9993 Author

Level 1

0 points

Aug 9, 2012 4:56 PM in response to daveg9993

*the Y-axis is correct, I just cannot fix the y-axis scaling issue. 🙂

Reply

Answer 2

Aug 9, 2012 5:16 PM in response to daveg9993

select the two columns in the data table, then select the chart from the charts menu:

to select the column select the table then click and hold in the column "A" header and drag to "B", then release

Reply

Answer 3

Badunit

Level 7

25,802 points

Aug 9, 2012 5:53 PM in response to daveg9993

The problem is that your X data is in a header column. Scatter charts require all data to be in non-header columns. What it is plotting as the X data is 1,2,3,4...14 instead of your actual X data. Your true X axis data is evenly spaced, which is why the shape of the chart looks correct even though it is using 1,2,3 etc for the X data instead.

Reply

Answer 4

Aug 9, 2012 6:03 PM in response to daveg9993

I left out that step and did it instinctively-- making the first row a header.

Reply