| Author |
 Topic  |
|
|
MatthiasW
Germany
6 Posts |
 Posted - 01/30/2018 : 12:28:25 PM
|
Hey Guys,
My Problem:
I want to make some kind of (automatically) data analysis.
Only one step is missing:
I've made a worksheet with frequency counts of temperature of different users.
Now i want to use a template to make a graph out of these frequencies
(all in one worksheet in a single workbook --> this seems to be my problem).
The Longname of these frequency counts is always the same (generated by OriginLab). They only got different comments, which should simbolize the data source.
Now my question:
How is it possible to make a template if I'm in this situation with only a sinlge worksheet and the same longnames?
Maybe you can help me with a discription of the settings I have to use or something like this.
Thank you in advance,
hope you got some ideas,
Matthias
|
|
|
YimingChen
1632 Posts |
Posted - 01/30/2018 : 2:51:46 PM
|
Hi Matthias,
Would you please be more specific on your question? Do you expect an analysis template or a graph template? You have one worksheet in your workbook, which seems like you are looking for a graph template. Then please check this tutorial video see if a cloneable graph template works for your scenario, thank you.
https://www.originlab.com/Index.aspx?go=Support/VideoTutorials&pid=3186
James, |
 |
|
|
MatthiasW
Germany
6 Posts |
Posted - 01/30/2018 : 4:52:42 PM
|
Sorry for my fault, but I'm not a native speaker.
I want a graph template. I've tried the same way as mentioned in the video, but it hasn't worked out in my case.
So i try to be more prcisely:
I got 2 worksheets in 1 workbook.
Sheet 1.):
Data input
Sheet 2.):
frequency counts from different groups out of the same data
(i will attach an image)
These frequency counts all have the same longname, but a different comment (with names of the different groups out of sheet 1).
And now I want to have a template, whereby I can generate quickly new graphs with the same design.
But it looks like I have to make different worksheets whereon is only 1 frequency count of a single group?!
(This way it worked out with the cloneable graph template)
Or I'm not able to find the right way to do it with only one worksheet.
Matthias
 |
|
|
|
YimingChen
1632 Posts |
Posted - 01/31/2018 : 08:38:57 AM
|
Hi Matthias,
In the save graph as template dialog, if you check Mark as Cloneable Template checkbox, the Match Plot Columns by is default to Index. This means the graph template will find the plot column by its index instead of column header name, e.g. long name. So no worry about that.
Also in your case, you can embed the graph as a new sheet in your workbook and save the entire workbook as an analysis template. To do that, right click on your second sheet tab, and select Add graph as sheet... and select the graph you want to include. You can then run batch processing for similar data files in the future, please check the tutorial page for details.
https://www.originlab.com/doc/Tutorials/AnalysisTemplate-BatchProcess
Hope I didn't miss any point since your attached picture is not displaying. Thanks,
James |
|
|
|
MatthiasW
Germany
6 Posts |
Posted - 01/31/2018 : 11:07:24 AM
|
Hi YimingChen,
I've made it the same way you mentioned first.
I try it again with the image:
And now I want to generate a template of the graph made out of the data from A(X), C(Y), E(Y)
to generate new graphs with the data out of A(X), F(Y), H(Y) and so on.
I hope, that you can understand what I mean.
Thanks in advance
Matthias |
|
|
|
YimingChen
1632 Posts |
Posted - 01/31/2018 : 12:31:43 PM
|
Dear Matthias,
It's easier in your case to run Labtalk script to do the plotting. Make a plot with col(C) and col(E), customize it as desired and save the graph template with name test. Then activate the worksheet, run the following script in Window:Script Window... dialog. Here presumably you are plotting XYY data with column index (1,3,5), (1,6,8), (1,9,11) and so on.
int nc = (wks.nCols-2)/3;
strBook$ = %H;
loop (ii, 1, nc)
{
win -a %(strBook$);
plotxy iy:= ((1,$(3*ii)),(1,$(3*ii+2))) plot:=202 ogl:=<new template:=test>;
}
You can also contact us via <tech@originlab.com> with your project file if more questions. Thank you.
James, |
Edited by - YimingChen on 01/31/2018 12:33:31 PM |
|
|
|
MatthiasW
Germany
6 Posts |
Posted - 02/01/2018 : 06:20:17 AM
|
Hi James,
Thanks for your Information, but I‘m not able to do it with the normal cloneable template? Or is there another way to do it with the cloneable template?
Matthias |
|
|
|
YimingChen
1632 Posts |
Posted - 02/01/2018 : 10:04:47 AM
|
Dear Matthias,
Cloneable graph template is not suitable here. Because your data are not saved in different worksheets with same structure but rather all in one worksheet. Please check the following notation:
"Cloneable templates are intended for "smart plotting" of data that always display some common structure. Cloneable templates do not require you to pre-select data before choosing the template (in fact, data selections are ignored when plotting to a cloneable template). If the data structure of the active workbook or matrix book matches the data structure stored with the cloneable template, the dolly icon at the left-bottom corner of the cloneable template will be blue, then you can select the template in the Template Library and click the Plot button."
quoted from the page:
https://www.originlab.com/doc/Origin-Help/Graph-Template-Basics#Cloneable_Templates
Here you may only need a normal graph template (When save graph template, uncheck the Mark as Cloneable Template checkbox). But you need to specify columns manually each time using the graph template. Then letting LabTalk to select columns fed into graph template will automate this process. Hope this answers your question. Thank you.
James
|
|
|
| |
Topic |
|
|
|
Making graphs automatically (by using templates)