Helo, i have a very basic problem. My x data is in column D and my y data in column G. Categories (different ratios) in column B.
I managed to plot the data and to color it according to the categories. So far so good. Now I would like to make a nonlinear fit for each category without manipultaing the tables layout. I tried in the fit dialog to find something like fit according categories, however without success. Can anyone help me?
Origin Ver. Pro 2023b and Service Release SR1 10.0.5.157 (Select Help-->About Origin): Operating System: Windows 10
Hello, You will need to unstack data first by column B and then select all unstacked data to plot and fit.
E.g. Select D and G columns, then choose Worksheet: Unstack Columns... (in newer versions it's under Reconstruct menu) Set Group Columns as B. Click OK.
A new sheet with pairs of each category will be created. Select all data then to plot. Since it's multiple Y, they will show different colors automatically. Then open Nonlinear Curve Fit dialog. Choose fitting function. Go to "Data selection" tab, click the > next to "Input Data" and choose Add all plots in active page. (note: you need to do this because by default only 1 plot will be fitted.) Then do the fit.