The Origin Forum - Automatic select data to plot

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum

Automatic select data to plot

New Topic

Reply to Topic

Printer Friendly

Author

Topic

MCV

Switzerland
3 Posts

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.

arstern

USA
237 Posts

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

MCV

Switzerland
3 Posts

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

USA
237 Posts

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

Switzerland
3 Posts

Posted - 03/10/2017 : 03:35:19 AM

Thanks again,
This is an excellent option. I will use this one.
All the best,
Mario

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000