(ORG-2523)
Sample OPJ to download to try: Box Plot.opj
...
- Highlight the rows for A386 of "CC.MI" sheet
- Type script below in the Script Window and press Enter. (If Script Window is not opened yet, open it from menu, Window: Script Window)
colstats; - Set the sheet name as A386_CC.MI
- Do the same to have C334_CC.MI sheet
How to customize to make Graph1:
...
12> Click OK to apply the settings and close dialog
Now, we are going to add a legend to explain thescatter points
1> Delete the legend
2> Select Graph: Add/Update Lgend Entries: Categorical Values from the Origin menu to add new legend to the graph.
3> Double click on the legend to be in edit mode, update the text as below
%(1,m1,1)
%(1,m2,1)
To customized the box plot
-------------------------------------------------------------------------
To set subgroup size:
1). Go to "Plot Details" dialog, Plot Properties level, "Group" tab, You will find a new control group called "Subgrouping".
2). You can choose the subgroup size in the drag-down list. Origin9.1 support subgroup size up to 14 boxes.
3). Checking the "Use Increment" checkbox to repeat the increment list in each subgroup.
-------------------------------------------------------------------------
To set tick label tables:
1). Open Axis Dialog, go to "Tick Labels" page under the axis you want to put tables on.
2). Check "Table" checkbox, and detailed setting interfaces will show in the dialog.
-------------------------------------------------------------------------
To index data point color:
1). Go to "Plot Details" dialog, Plot Properties level, "Box" tab, and set "Type" to show the data points. (In Graph1, type is set to "Box[Right]+Data[Left]")
2). Go to "Symbol" tab, set your symbol type and choose the index column in color drag-down list. (In Graph1, symbol is open circle and edge color is indexed by col(B))
-------------------------------------------------------------------------
To custom Whisker, Cap, Median, Mean or Distribution Curve:
1). Go to "Plot Details" dialog, Plot Properties level, "Lines" tab.
2). Each line details can be customized. (In Graph2&4, whisker color is set to Gray and Cap length is 0, mean/madian line s are also customlized)
-------------------------------------------------------------------------
To set I-Shape Box and Outliers aligned in a line:
1). Go to "Plot Details" dialog, Plot Properties level, "Box" tab, and set "Style" to "I-Shape box".
2). Check "Outliers" checkbox and "Outliers in a line" checkbox to show outliers. (Graph3)
-------------------------------------------------------------------------
...
How to customize to make Graph2:
Graph2 illustrate 3 improvements of the Box Chart in 9.1
1) Separated control of Whisker and Cap -->Plot Details dialog, Line tab
2) Grouped Box plot -->Plot Details dialog, Group tab
3) Table option for the tick labels. -->Axis dialog, Tick Labels>Bottom/Top Node, Table check box
1> Active Book5 in the project. Go to sheet "CC.MI", highlight column E through column J, select "Plot: Statistics: Grouped Box Charts - Raw Data" from Origin menu
2> In the opened dialog, apply the settings as below and click OK button to create a graph
* Group Number = 2
* 1st Group Row = Comments
* 2nd Group Row = Long Name
* Graph Theme = <Original>
Then, we are going to customize the box plots
1> Double click on the plot to open the Plot Details dialog
2> Select Group tab, apply settings as below
* Border Color>Details = (1: Red, 2: Navy)
* Box Color>Increment = By One
* Box Color>Details = (1: Red, 2: Navy)
3> Select Spacing tab, apply settings as below
* Gap Between Subgroups (in %) = 5
* Gap Within Subgroups = 50
4>Select Percentile tab, apply settings as below
* Edge Color = White
5>Select Lines tab, apply settings as below
* Whisker group, Color = Gray
* Caps Length = 0
* Median Line group, Color = White
Then we are going to customize the axis and tick labels
1>. Double click on the bottom axis to open the Axis dialog.
2>. Go to the X Axis>Tick Labels node
* Select Show Major Labels on Top Axis
3> Choose Bottom1 in the left panel, In the Bottom1 page,
* Table branch
*> Number of Rows = 1. Click Apply button to apply the setting.
* Display branch
*> Display = Column headings
* Format branch
*> Size = 22
* Table branch
* >Table Layout branch
* >> Fill Color = White, * >>Uncheck Far Parallel Border, * >>Uncheck Perpendicular Border, * >> Select Gap Between Subgroups/Subsets
4> Choose Top in the left panel. In the Top page
* Display branch
*> Display = Comments,
* Format branch
* >> Font Size = 24, *>> Select Bold checkbox
* Table Branch
*> Fill Color = LT Gray
5> Choose Grids in the left panel.
* Major Grid Lines branch
* > Select Show check box
* > Color = Black
* Minor Grid Lines branch
* > Select Show check box
* > Style = Solid
* > Color = LT Gray
6> Choose "Y Axis>Scale" in the left panel, in the Scale page
* From = -2500
* To = 20000
* Major Ticks branch
* Value = 5000
7> Choose "Y Axis>Grids" in the left panel, in the Grids page
* Major Grid Lines branch
* > Select Show check box
* > Color = LT Gray
8> Choose "Y Axis>Tick Labels>Left" in the left panel. In the Left page
* Display branch
* Display = Scientific: 10^3
9> Click OK to apply the settings and close dialog