Apple Event: May 7th at 7 am PT
I want to enter two values on a chart, draw a line through them and read the positions of other data points from that line. But when I try to make a chart in Numbers 3.6.1, the x-axis doesn't seem to be able to have fixed increments, so the data points don't occur in a fixed relationship to each other. I hope that makes sense; it's not easy to describe.
2.16 GHz Intel Core 2 Duo, Mac OS X (10.4.11)
Hi tupppi,
What type of chart are you using?
There is a 2-D Scatter which has a linear X axis. Most other types are category graphs (each X value is a category).
A screen shot of some of your data table will help us see what you want to achieve.
Regards,
Ian
Hi Yellowbox, thanks for your reply. It's a 2D line. I tried 2D scatter but it wanted to put one data point on the x-axis and the other one on the y-axis!
Screen shot is attached.
Jane
Hi Jane,
No screen shot.
Regards,
Ian.
Okay. It went with the email as an attachment and I tried to send it inline as well but it wasn't posted. Now I've signed in so I've pasted it here. I hope this works!
The information was displayed when I replied last, but when I reloaded the page it was missing. So now I'm linking it via this page. Fingers crossed.
Hi Jane,
Uncross your fingers. The screen shot came through.
I'm not sure of your aim, so I played with some charts.
Here is a 2-D Line. The categories are in a Header Column.
Columns A and B selected for the chart.
Here is a 2-D Scatter.
Only Columns B and C (not Header Columns) selected for the chart
Please reply with questions.
Regards,
Ian.
Thanks, Ian, the 2D scatter was what I wanted because it shows the range of body weights on the x-axis. I had tried a scatter chart but it didn't work; I tried arranging the columns that way, too but still no result, not sure why. My brain was definitely on low-power mode yesterday. Anyway, thanks again. This is the chart:
Hi Jane,
Glad it finally worked and thanks for the green tick and your feedback.
Keep posting in this forum with other questions.
Regards,
Ian.
Can I have fixed value increments on both axes, like a piece of graph paper?
