(ORG-2523)
Sample OPJ to download to try: Box Plot.opj
Grouped Box Chart
(Indexed ORG-948, Raw ORG-8510)
Origin supports plotting grouped Box chart from both Indexed Data or Raw Data. Menus are available under Plot: Statistics menu. Buttons are available from 2D Graphs toolbar. | |
How to:
|
Box width and position with information from Column Label Rows
How to:
|
More Control of Data and Box
(ORG-5901, ORG-5881, ORG-1905)
How to:
|
I Shape Box
(ORG-7839)
How to: Go to Plot Details: Plot Properties: Box tab, set Box: Style to be I-shaped Box. |
Individual Controls for Whiskers Caps Median Mean and Distribution curve
(ORG-816)
Box Chart Legend
(ORG-4346)
Right click graph and choose Add/Update Legend Entries:Box Chart Components.
Built-in Box Chart Themes
(ORG-7916)
With Box chart graph window active, open Tools:Theme Organizer.
We provide some common box chart themes. User can apply it to quickly change box chart.
How to
The Sample OPJ includes 6 sample graphs (4 in "1. Grouped Box Plot and Axis Ticks Table" folder, and 1 for both
"2. Box Plot Position By Variables" and "3. Box Width By Variable" folders) to show the remarkable improvements
in box chart
Grouped Box Plot with Color-indexed Data Points
How to plot the basic form of the grouped box plot:
- Active the workbook in the folder, highlight column E through column J, select "Plot: Statistics: Grouped Box Charts - Raw Data" from Origin menu
- In the opened dialog, apply the settings as image below and click OK button to create a graph
Before we set the axes of the box chart, we prepare the number of data points of each column in "CC.MI" sheet by steps as below
- 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:
Graph1 illustrate 3 improvements of the Box Chart in 9.1
1) Data symbol color supports indexing (grouping) -->Plot Details dialog, Symbol 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 the workbook Book 5 in the folder, 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>
Before we set the axes of the box chart, we prepare the number of data points of each column in "CC.MI" sheet by steps as below
1>. Highlight the "A386" rows [1:21] of col(E)~col(J) in sheet "CC.MI"
2>. 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 -r 2 sd:=<optional> q1:=<new> q3:=<new>;
3>. Set the sheet name as A386_CC.MI
4> Highlight the "c334" rows [22:42] of col(E)~col(J) in sheet "CC.MI", do the same to have C334_CC.MI sheet
Then, we are going to customize the box plots
1> Double click on the plot to open the Plot Details dialog
2> Select Box tab, apply these settings
* Type = Box[Right] + Data[Left]
3> Select Symbol tab, apply these settings
* Size = 5
* Symbol Color = Indexing: Col (B)
* Shape = 2 Circle
* Interior = Open
4> Select Data tab, apply these settings
* Distribution Curve group, Type = Normal
* Bins Alignment group = Right
5> Select Group tab, apply settings as below
* Box Color>Increment = By One
* Box Color>Details = (1: Red, 2: Navy)
* Border Color>Details = (1: Red, 2: Navy)
6>Select Lines tab, apply settings as below
* Whisker group, Color = Gray
* Caps Color = Gray
* Median Line group, Color = White
* Distribution Curve group, Color = Gray
7>Select Percentile tab, apply settings as below
* Edge 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 = 3
* >Uncheck Merge Labels
* >Select Independent Formats
* >Table Layout branch
*>>Fill Color = LT Gray
* >>Check Near Parallel Border
* >>Uncheck Perpendicular Border
* >>Select Independent Layouts
* Display branch
* >Type = Text from dataset
* >Dataset Name = [Book5]"C334_CC.MI"!C"N"
* Format branch
* >Color = Dark Gary
4>Choose Bottom2 in the left panel. in the Bottom2 page
* Display branch
* >Type = Text from dataset
* >Dataset Name = [Book5]"A386_CC.MI"!C"N"
* Table Layout branch
* > Fill Color = Gray
* >Uncheck Near Parallel Border
* >Uncheck Perpendicular Border
* Format branch
* >Color = White
5>Choose Bottom3 in the left panel. in the Bottom3 page
* Display branch
* >Type = Column Name or Label
* >Display = Column headings
* Table Layout branch
* >Uncheck Perpendicular Border
* Format branch
* >Size = 22
6>Choose Top in the left panel. in the Top page
* Display branch
* >Type = Column Name or Label
* >Display = Comments
* Format branch
* >Size = 22
* >Select Bold
* Select Table check box
* >Uncheck Perpendicular Border
* >Uncheck Gap Between Subgroups/Subsets
* > Fill Color = LT Gray
7> Choose Grids in the left panel
* Major Grid Lines branch
* >Select Show
* >Color = Gray
8> Click OK to apply the settings
9> Double on the tick labels of the Y Axis to open the Axis dialog
10> Select Y Axis>Scale in the left panel
* From = -2000
* To = 20000
* Major Ticks branch
* >Value = 5000
11> Select Y Axis>Tick Labels>Left in the left panel
* Display branch
* >Display = Scientific: 10^3
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)
-------------------------------------------------------------------------