It sounds like you're looking for the line chart option in FileMaker, not a scatter plot.
no, it should be scatter with line. The line chart cant perform the ralation between torque and speed.
Ah, OK. You want a scatter plot with a regression line. You can calculate the regression in FileMaker, but you do need a web viewer-based chart to get the visual presentation you're after. You could plot just the regression line or just the scatter plot in one of FileMaker's built-in charts, but not both superimposed on each other. After you're done dealing with the immediate issue, you might consider submitting a feature request to FileMaker.
It seems work. but i have never used xmchart and it costs 129$, so i have to be careful,as the company pays for the software. I will explain to u the details of the App.
This is how i did using the chart function.
1.creat a new table:Motor characteristic including 3 points data of the motor characteristic(Torque,Speed), as the picture below(a part of the data), one type means same motor and same Voltage
2. set up the realtionship
3.creat a chart in the layout:details from table:database.
4.chose the x,y data
5.set up the data source
6.specify the sort order
do u understand the App? if yes, can u confirm that the xmchart can do this and add the straight line?
aha,there is a demon version, i will try first