| T O P I C R E V I E W |
| MCV |
Posted - 03/08/2017 : 06:22:08 AM
Origin Ver. and Service Release: 2017
Good day,
I have a large set of data which I would like to plot. Each data column has a name with the following format:” TEST##_VoltageXX_TemperatureYY”. The voltage and temperature values change in a known range. Is it possible to automatically set Origin to plot only the data at a selected value of voltage or temperature? In other words, could I program origin to plot only the data at XX voltage (all the temperatures) or at a selected temperature (all the voltages)?
Thank you in advance for your help.
|
| 4 L A T E S T R E P L I E S (Newest First) |
| MCV |
Posted - 03/10/2017 : 03:35:19 AM
Thanks again,
This is an excellent option. I will use this one.
All the best,
Mario |
| arstern |
Posted - 03/09/2017 : 4:56:01 PM
Hi Mario,
Glad to hear my suggestions were helpful. One more suggestion that became aware to me is that you can select the columns that you want to plot by Selecting Edit --> Select ... The Select dialog box will appear. See image below. The string example that I typed specifies that all the columns for Test10 with Voltage 20 will be selected.
 |
| MCV |
Posted - 03/09/2017 : 03:09:10 AM
Dear Aviel,
Thank you for your detailed answer. It was very useful.
All the best,
Mario |
| arstern |
Posted - 03/08/2017 : 4:51:52 PM
Hi Mario,
I am going to list two methods:
1)
A quick and simple way to plot specific columns (if your data is not too large):
1) Activate worksheet (with columns not selected)
2) Select Plot and select your graph type
3) The Plot Setup dialog box will appear
4) Here you can select which columns you want to graph
http://www.originlab.com/doc/Origin-Help/GraphRef-PlotSetup-Dialog
2) Due to your post, I am expecting that you have a very large dataset where the first method may be not be very helpful. Below is a way to plot specific columns for very large datasets.
You will basically 1) stack the columns then 2) filter the columns and then 3) plot the filter columns.
1) Stack columns
- Activate your worksheet
- Select the Worksheet tab at the top of the project
- Select Stack Columns
A new sheet in your workbook will be created. Column A should list the Long Name (assuming that your file name is listed under Long Name) and Column B should list the data.
Tutorial on stack columns:
http://www.originlab.com/doc/Origin-Help/Wks-Stacking-Cols
2) Create Filter
- Select Column A (The column that lists the Long Name)
- Select the Filter icon
- Now you can filter your data to show specific datasets.
Tutorial on Filter:
http://www.originlab.com/doc/Tutorials/Data-Filter
3) Plot your data with the filter applied
4) To apply a symbol color to correlate with the long name
- Double click the graph
- Select symbol tab
- Select symbol color
- Select By points
- Select Mapping: Long Name
Tutorial:
http://www.originlab.com/doc/Tutorials/Symbol-Plot-with-Color-Transparency
5) To make your legend display the long name with symbol color
- Activate Graph
- Select Graph at the top of the project
- Select Legend ---> Select Categorical Values --> Select OK.
--Aviel Stern
OriginLab
|
