how do i draw a inverse ratio trend line?

You may want to consider Numbers, or better still — Excel. Paste the screen shots back into Pages. For the same data points, Numbers understands what one wants to do, and charts it accordingly, whereas charts in Pages behaves very differently. The following was a linear trend in Numbers. When you select the chart, the Format panel provides a Series tab where one can choose type of trendlines. Is the following what you were wanting to achieve?

If it is not among the trendlines choices, then your only recourse is MS Excel. I very much doubt that Apple will add this feature at this point in time.

Apple's iWork and follow-on applications are not Microsoft Office clones, and there was never a design goal to have them match feature for feature with their Microsft counterparts.

Hi Viktor,

Thanks for the data tables. I have placed what I think you want into a new table (Graph Data) and used that to create a Scatter Plot in Numbers app.

(I was lazy, and typed L instead of lambda for wavelength 😉)

Click on the Scatter Plot, click on the Edit Data References Button and tick Plot Rows as Series. Untick Share X Values.

The lines are Connection Lines, not Trend Lines

Click on a Series (Close-end or Open-end) and Format Panel > Style > Connection Line > Straight.

If you want Trend Lines, you will have to decide which mathematical formula best fits.

I am thinking that a new Row for the Y values (wavelength=1/frequency) may be what you want.

Happy graphing!

Regards,

Ian.

Hi Viktor,

I am making a chart to present my experiment data, the relationship of frequency and wavelength, which is in inverse proportion.

Please post an example of your data. Perhaps someone here can help with "inverse proportion".

Regards,

Ian.

Hi Viktor,

Thanks for the graph. It will be more helpful if you copy and paste your data table into a reply. Then we can try to recreate the graph from your data and see what trendline(s) will fit. I suspect an inverse equation such as wavelength=speed of sound/frequency (y=constant/x).

Regards,

Ian.