SetSet-cmd
Brief Introduction
Change the attributes of the specified dataset, data plot, or worksheet.
Syntax
set name [option] [value];
Specifying Worksheet, Dataset or Data Plot
We usually specify worksheet, dataset or data plot by name.
- If name is a worksheet, all datasets on the worksheet are affected.
- If name is a dataset or data plot, only that dataset or data plot is affected.
/Tip_icon.png) | As of Origin 2017, name can refer to multiple plots of the same worksheet dataset, using a Book_N:n syntax. For the following example, create Book1 and fill columns A and B with row numbers in rows 1 - 32:
plotxy iy:=(1,2)[1:16] plot:=201 color:=1; // creates a scatter plot
%A = %H; // puts the active window title into %A
win -a Book1; // activates Book1
plotxy iy:=(1,2)[17:32] plot:=201 color:=2 ogl:=[%A]1!; // adds plot 2 to the graph and sets color to red
win -a Graph1; // activates Graph1
set Book1_B -z 24; // changes symbol size of plot 1 to 24;
set Book1_B:2 -z 24; // changes symbol size of plot 2 to 24
|
Specifying Data Point
We can specify the data point by providing a number after the dataset name. For example:
set %C 13 -c 2; //This sets the color of 13th datapoint to Red
Note: This datapoint notation can be only applied to the following options:
Scatter/Symbol+Line Related Option
|
-z , -c , -cse , -csf , -k , -ka , -kf , -lh , -lhc , -lhs , -lhw , -lv , -lvc , -lvs , -lvw
|
Bar/Column Related Option
|
-pbc , -pbs , -pbw , -pfb , -pfc , -pfp , -pfw
|
|
Specifying Pattern
From Origin 2017 SR1, if you want to set the pattern properties for a multiple pattern plot, you can specify the pattern index after “p” in option directly. That is to say, p is the first pattern, p2 is the second pattern, p3 is the third pattern and etc.For example:
set %C -pf 1; // Turn on '''Fill Area Under Curve''' option
set %C -pfv 9;// Set to '''Fill to next data plot – Above Below Colors'''
set %C -pfb 2; // Set the fill color of “Pattern Above”
set %C -p2fb 3; // Set the fill color of “Pattern Below”
Note: This pattern notation can be only applied to the following options:
Bar/Column Related Option
|
-pfb, -pfc, -pfm, -pff, -pfp, -pfw
|
|
Options
The option switch determines which attribute is set to value. (Read these attributes with the get command.)
Some of the values have a built-in list in Origin (color, shape, etc.), user can use the index number to complete the set, indicated by value#.
Option for Columns
Option
|
Description
|
no option
|
Open the Plot Details dialog box
|
-at
|
Do not save the dataset with the project
|
-b
|
Set the beginning of the data display range
|
-b3o
|
Set the start value from which the 3D Bars are drawn
|
-bs
|
Temporarily set the beginning of the range of a dataset to the index given by value
|
-dc
|
Set the dataset as categorical
|
-e
|
Set the end of the worksheet display range
|
-e
|
Reset the data plot to the full range
|
-em
|
Set the end of the worksheet display range
|
-er
|
Set the number of rows available on the named worksheet
|
-es
|
Temporarily set the end of the range of a dataset to the index given by value
|
-ez
|
Set the end of the worksheet display range
|
-f
|
Set the corresponding X value for the first data point
|
-f1
|
Set the function to plot from xvalue
|
-f2
|
Set the function to plot to xvalue
|
-hbb
|
Set the begin value of the histogram bin data
|
-hbe
|
Set the end value of the histogram bin data
|
-hbs
|
Set the histogram bin size
|
-i
|
Set the X increment for the dataset
|
-it
|
Set the internal data type for the name dataset or matrix to the value dataTypeValue
|
-set
|
Force Text & Numeric datasets to show numeric values as text elements
|
Option for Data Plots
Option
|
Description
|
-a
|
Set the plot to the animate mode to be used for animation
|
-an
|
Turn on or off the animate mode
|
-b3c
|
Set the color map of surface plot to be from the specific matrix
|
-b3t
|
Set the fill mode of the 3D surface plot
|
-b3cc
|
Set individual color as 3D surface plot color fill
|
-b3cm
|
Set matrix as 3D surface plot color map
|
-b3cn
|
Set matrix as 3D surface plot color index
|
-b3cn
|
Set matrix as 3D surface plot color with direct RGB
|
-b3m
|
Set the mesh on 3D surface plots
|
-c
|
Set the plot line color and symbol edge color, or map color to a dataset of index values
|
-cf
|
Set the fill color following the color palette
|
-ci
|
Set the plot line color and symbol edge color to be increment
|
-cl
|
Set the plot line color following the color palette
|
-cli
|
Set the plot line color to be increment
|
-clm
|
Set the plot line color to be colormap
|
-cln
|
Set the plot line color to be indexing
|
-cm
|
Set the plot line color and symbol edge color to be colormap
|
-cmc
|
Fill to contour lines or grid lines on matrix based contour plots
|
-cmd
|
Show data points on workbook based contour plots
|
-cmf
|
Show color fill on contour plots
|
-cmg
|
Show grid lines on workbook based contour plots
|
-cn
|
Set the plot line color and symbol edge color to be indexing
|
-clr
|
Set the plot line color to be RGB
|
-cpal
|
Set the color palette to the data plot or matrix
|
-cr
|
Set the plot line color and symbol edge color to be RGB
|
-cse
|
Set the plot symbol edge color following the color palette
|
-csei
|
Set the symbol edge color to be increment
|
-csem
|
Set the symbol edge color to be colormap
|
-csen
|
Set the symbol edge color to be indexing
|
-cser
|
Set the symbol edge color to be RGB
|
-cset
|
Set the plot symbol edge color pattern
|
-csf
|
Set the plot symbol fill color following the color palette
|
-csfi
|
Set the symbol fill color to be increment
|
-csfm
|
Set the symbol fill color to be colormap
|
-csfn
|
Set the symbol fill color to be indexing
|
-csfr
|
Set the symbol fill color to be RGB
|
-cu
|
Set the custom increment list for plot line/symbol edge/column or bar color
|
-cue
|
Enable or disable the custom increment list for plot line/symbol edge/column or bar color
|
-czn
|
Set the Z level for level n in a color mapped data plot
|
-gtl
|
Set the gap between leader line and label (also the gap between leader line and symbol)
|
-lczm
|
Removing missing values in Z for XYZ contour/surface
|
-md
|
Plot-level override of global and page mask
|
-pc
|
Modify plot data to skip columns by the specified start column and increment
|
-r
|
Delete special points, selectively or all
|
-so
|
Access the original plot for 3D scatter or trajectory plots
|
-spi
|
Set the index column for triangle patch
|
-sx
|
Set the X offset
|
-sx
|
Access the YZ projection for 3D scatter or trajectory plots
|
-sxs
|
Set the scaling factor of X value after stacking for a data plot
|
-sy
|
Set the Y offset
|
-sy
|
Access the XZ projection for 3D scatter or trajectory plots
|
-sys
|
Set the scaling factor of Y value after stacking for a data plot
|
-sz
|
Access the XY projection for 3D scatter or trajectory plots
|
Option for Symbols
Option
|
Description
|
-k
|
Set plot symbol shape (Built-in symbols)
|
-ka
|
Set plot symbol shape (user-defined and ASCII)
|
-kf
|
Set plot symbol interior
|
-kh
|
Set plot symbol Edge Thickness
|
-ki
|
Set plot data symbols to italic
|
-kn
|
Set plot font for alphanumeric symbols
|
-ku
|
Set plot data symbol to underline
|
-kt
|
Symbol tab Construction details radio choices
|
-z
|
Set data point symbol size
|
-ksi
|
Set symbol shape increment
|
-kfi
|
Set symbol fill type increment
|
-ksn
|
Set indexing symbol
|
-kfn
|
Set indexing fill symbol
|
-kss
|
Set single symbol
|
Option for Lines
Option
|
Description
|
-d
|
Set the line style
|
-dn
|
Set indexing line style
|
-l
|
Set plot line connection method
|
-lhc
|
Set the horizontal drop line color
|
-lhs
|
Set the horizontal drop line style
|
-lhw
|
Set the horizontal drop line width
|
-lvc
|
Set the vertical drop line color
|
-lo
|
Show/hide drop lines on Z direction
|
-lh
|
Show/hide drop lines on X direction
|
-lv
|
Show/hide drop lines on Y direction
|
-lvs
|
Set the vertical drop line style
|
-lvw
|
Set the vertical drop line width
|
-wn
|
Set indexing line width
|
Option for Text Labels
Option
|
Description
|
-tf
|
Set the text label font
|
-tj
|
Set text label justification
|
-tr
|
Set the text rotation in angle
|
-ts
|
Set text label font size
|
-tts
|
Set what kind of text is going to be displayed for text label
|
-tx
|
Set the Y offset for the plot data label
|
-ty
|
Set the X offset for the plot data label
|
Option for Bar and Column Plots
Option
|
Description
|
-pbc
|
Set plot bar or column border color
|
-pbci
|
Set bar or column border color as Increment
|
-pbcm
|
Set bar or column border color to be colormap
|
-pbcn
|
Set bar or column border color to be indexing
|
-pbcr
|
Set bar or column border color to be RGB
|
-pbs
|
Set plot bar or column border line style
|
-pbw
|
Set plot bar or column border line width
|
-pfb
|
Set plot bar or column fill color
|
-pfbi
|
Set bar or column fill color as Increment
|
-pfbm
|
Set bar or column fill color to be colormap
|
-pfbn
|
Set bar or column gradient fill color to be indexing
|
-pfbr
|
Set bar or column gradient fill color to be RGB
|
-pfc
|
Set plot bar or column fill pattern color
|
-pfci
|
Set bar or column pattern color as Increment
|
-pfcm
|
Set bar or column pattern color to be colormap
|
-pfcn
|
Set bar or column pattern color to be indexing
|
-pfcr
|
Set bar or column pattern color to be RGB
|
-pff
|
Set bar or column gradient fill color
|
-pffi
|
Set bar or column gradient fill color as Increment
|
-pffm
|
Set bar or column gradient fill color to be colormap
|
-pffn
|
Set bar or column gradient fill color to be indexing
|
-pffr
|
Set bar or column gradient fill color to be RGB
|
-pfm
|
Control the mode of gradient fill
|
-pfp
|
Set plot bar or column fill pattern
|
-pfpd
|
Set bar or column fill pattern as Indexing
|
-pfpi
|
Set bar or column fill pattern color as Increment
|
-pfpn
|
Set bar or column fill pattern by patter file name
|
-pfw
|
Set plot bar or column fill pattern line width
|
-vg
|
Set the bar and column plot gap
|
-vw
|
Set the bar and column plot border width (in points)
|
Option for Error Bars
Option
|
Description
|
-o
|
Plot the values in the name dataset as Y error bars for the plotted Ydataset
|
-om
|
Plot the values in the name dataset as Y (minus) error bars for the plotted Ydataset
|
-op
|
Plot the values in the name dataset as Y (plus) error bars for the plotted Ydataset
|
-or
|
Plot the values in the name dataset as Y error bars (relative) for the plotted Ydataset
|
-ox
|
Plot the values in the name dataset as X error bars for the plotted YDataset
|
-oxm
|
Plot the values in the name dataset as X (minus) error bars for the plotted YDataset
|
-oxp
|
Plot the values in the name dataset as X plus (error) bars for the plotted YDataset
|
Option for Data Plot Labels
Option
|
Description
|
-lm
|
Extend plot line when there are missing values
|
-q
|
Turn the data label on or off
|
-qa
|
Turn the Auto Orientation of label on or off in 3D graph
|
-qb
|
Set the data label to bold
|
-qc
|
Set the data label font color
|
-qf
|
Set the data label font
|
-qi
|
Set the data label to italic
|
-ql
|
Set the connection type of leader lines on OpenGL 3D graph
|
-qlc
|
Set the color of leader lines on OpenGL 3D graph
|
-qlw
|
Set the width of leader lines on OpenGL 3D graphs
|
-qm
|
Set the data label form
|
-qmi
|
Label points at specified row indices or by space-separated dataset
|
-qmie
|
Enable or disable show of labels at indices specified by -qmi
|
-qms
|
Customize the data label display string
|
-qn
|
Specify the normal vector of the plane for label orientation in 3D graph
|
-qnx
|
Specify the x component of normal vector of the plane for label orientation in 3D graph
|
-qny
|
Specify the z component of normal vector of the plane for label orientation in 3D graph
|
-qnz
|
Specify the z component of normal vector of the plane for label orientation in 3D graph
|
-qp
|
Set the data label position
|
-qr
|
Set data label rotation degree
|
-qs
|
Set data label font size
|
-qu
|
Set underline for the data label
|
-qw
|
Set data label whiteout or not
|
-qx
|
Set data label X offset value
|
-qy
|
Set data label Y offset value
|
Option for Transparency
Option
|
Description
|
-tpl
|
Set transparency for line
|
-tps
|
Set transparency for symbol
|
-tpp
|
Set transparency for pattern
|
Other Options
Option
|
Description
|
-gn
|
Set the LongName of the plot group in which the specified data plot is.
|
-j
|
Disable the use of substitution notation (% and $) in the argument string
|
-m
|
Set the specified data plot as movable/not movable with the cursor
|
-n
|
Rename loose dataset
|
-pd
|
Show/hide vertical drop lines
|
-pf
|
Turn the fill area option on or off
|
-pfv
|
Control the Fill Area Under Curve setting
|
-pfn
|
Control the mode of Fill to next data plot
|
-s
|
Show/hide the data plot
|
-skip
|
Display every nth symbol in a line+symbol data plot
|
-spf
|
Control the flatten-mode for 3D surface plot
|
-spz
|
Set the Z offset by percent of the scale range for 3D surface plot
|
-tb
|
Control the data plot rendering mode
|
-u
|
Set (update) the current display range for name in the active layer to be true for name in all layers
|
-ui
|
Update Origin when you type or paste data into an Excel workbook sheet
|
-w
|
Set connecting line width
|
-x
|
Associate an X dataset with a Y dataset
|
-yx
|
Set the dataset to be plot
|
Example
Example 1
The following script sets the beginning of the display range for col(B) to 10.
range rr = [Book1]Sheet1!B;
set rr -b 10;
Example 2
The next script sets the line width to 2 pts.
//set the line width of 2nd plot on graph to be 2pts
range rr = !2;
set rr -w 1000;
Example 3
The next script hides data plot from col(B) in graph.
range rr = [Book1]Sheet1!B;
set rr -s 0;
Example 4
The following script opens the Plot Details dialog box correspond to active data plot.
set %C;
Example 5
The next script sets the active scatter data plot to display row numbers as data point symbols.
set %C -k 11;
Example 6
The next script adds an XY data plot (col(B) in Book2 sheet1 as Y, col(A) in Book1 sheet1 as X) to the active layer.
range r1 = [Book2]Sheet1!B;
range r2 = [Book1]Sheet1!A;
layer -i r1;
set r2 -x r1;
rescale;
Example 7
In this example, open a new project and import the WIND.DAT file from the Samples\Graphing\ folder. Select the Month column and then move to Last. Set this column as a label column. Select the Power and Month column and select Plot:Scatter. Then run the following script to set the label data plot display attributes.
ii = font(Arial);
//use font function to find Arial index #
range rr = [Wind]Wind!A;
set rr -tr 90; //rotate 90 degrees
set rr -ty 50; //50% y offset
set rr -tj 0; //left justify
set rr -tf ii; //set as Arial font
Example 8
In this example, we first plot a XY line and then add some other dataset into the graph. Then give each dataset different settings.
newbook; //New a workbook
string wname$ = page.name$; //Get new workbook's name
wks.ncols=10; //Set column numbers to be 10
int nn = wks.ncols;
csetvalue formula:="i-1" col:=1;
Loop(ii, 2, nn)
{
csetvalue formula:="(i-1)/(2/(ii-1))" col:=$(ii);
}; //Gave every column values
set %c -em 10; //Only display 10 values
plotxy iy:=(1,2) plot:=201; //Plot a scatter graph with first 2 columns
for(jj=3; jj<=nn; jj++)
{
range rr = [%(wname$)]sheet1!col($(jj));
string bb$ = %(nameof(rr)$); //change dataset name
layer -i201 %(bb$); //add new plot to the same layer
};
int tt = 3;
repeat 8
{
int tt2 = 1+mod(tt,3);
range rr = $(tt-1);
set rr -c $(tt-1); //set symbol color
set rr -z $(9+(tt-2)); //set symbol size
set rr -k $(tt2); //set symbol type
tt++;
};
rescale;
Example 9
In this example, we first plot a XY scatter, set it to be colormapped and then add some other dataset into the graph. Useing the first plot's setting values to modify the others.
Newbook;
string wname$ = page.name$; // Get workbook name
wks.ncols = 5; // Set number of coiumn to be 5
int nn = wks.ncols;
col(1) = {2000:2010}; // Let the first column be our colormap
Loop(ii, 2, nn)
{
range rr = [%(wname$)]1!wcol(ii);
rr = {0:1*(ii-1):10*(ii-1)};
if(ii>2)
{
if(ii==3)
{
plotxy iy:=(2,3) plot:=201; // Plot the first scatter using col(3) and col(2)
set %c -cse $(524389+ii-1); // Set Col(1) be color index
set %c -cset 2; // Set color pattern to be colormapping
}
else {layer -i201 %(nameof(rr)$)}; // Add the rest to the layer
}
else
{
wks.col$(ii).type = 4; // Set col(2) to be X for plotting
};
};
for(jj=1;jj<4;jj++)
{
string pp$ = %(wname$)_%(char(jj+66)$);
switch (jj)
{
case 1:
get %(pp$) -cse t1;
get %(pp$) -cset t2;
get %(pp$) -z t3;
get %(pp$) -k t4; // Get the first plot's setting values
break;
case 2 3:
set %(pp$) -cse $(t1+jj-1);
set %(pp$) -cset t2;
set %(pp$) -z $(jj*t3);
set %(pp$) -k $(jj+t4-1); // Make some changes and apply to the other 2 plots
break;
default:
break;
};
};
rescale;
Example 10
Use Increment for symbol color and enable the usage of custom color list:
//Create new workbook, fill data and plot as scatter
newbook;
col(A) = data(1,12);
col(B) = col(A);
plotxy (1,2);
//Use Increment to define symbol color
set %c -ci 1;
//Enable the usage of custom color
set %c -cue 1;
//Define the color indices in the custom color list
set %c -cu 2 4 6 8;
See Also
Get (command)
|