Versions Compared

Old Version 66

changes.mady.by.user Hideo Fujii

Saved on

compared with

New Version Current

changes.mady.by.user Wall-E

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

(ORG-2523)(star)

Product Page of Box Chart

Sample OPJ to download to try: Box Plot.opj

Table of Contents
maxLevel4
minLevel2

...

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.

Image RemovedImage Added

Image RemovedImage AddedImage RemovedImage Added

How to:

  • Indexed Data: 
    Add group info column to Group List. This will break the origin column into subcolumns and plot each one as a box.
  • Row Raw Data: 
    Select the number of group level in Group Number dragdown  dropdown list, specify the label rows for each group level. Each column will be plotted as a box.

Note:

Grouped-Plot-Only Style Controls

 

 

 

Image Added

 

Image Added

Image Added

How to:

  • Increment Settings within Subgroups: 
    Go to Plot Details: Plot Properties: Box tab, check Use incrementing check box.
  • Separated Spacing Control Between or Within Subgroups: 
    Go to Plot Details: Plot Properties: Spacing tab.

Box

...

Position with

...

Information from Column Label Rows

  (ORG-1943,  ORG-40944094) (ORG-8275)

Image RemovedImage AddedImage RemovedImage Added

How to:

  • Position boxes by a column label row: 
    Go to Plot Details: Plot Properties: Box tab, choose label name in  X Position dragdown dropdown.
  • Horizontal Graph: 
    Click Graph: Exange X-Y Axes menu.

More Control of Data and Box

  (ORG-1943, ORG-981, ORG-5901, ORG-5881, ORG-1905)

Index check  checkbox and set Scaling Factor. data dragdown

Image Added		Image RemovedImage Added
Image RemovedImage AddedImage Removed

Image Added
Image Removed

Image Added

How to:

  • Specify boxes width by a column label row: 
    Go to Plot Details: Plot Properties: Box tab,
  • select Box Width by Parameter
  • check box, choose label row 
    name in  Box Width(%) dropdown list..
  • Label box and whisker with data value:
    Go to Plot Details: Plot Properties: Box tab, check Box Labels check box and Whisker Labels. choose Values 
    from the Show dropdown list
  • Draw data on top of boxes: 
    Go to Plot Details: Plot Properties: Box tab, check Draw Data on Top of Box checkbox.
  • Set Data display width:
    Go to Plot Details: Plot Properties: Data tab, input Bins Alignment: Data Width(%). If set it to 0, 
    for example,
  •  data points will be in a line.
  • Indexing or mapping for data symbol color: 
    Go to Plot Details: Plot Properties: Symbol tab. Set Symbol Color
  • dropdown list to be Indexing/Color Mapping, 
    and specify a column to be the reference.

...

More Box Style

  (ORG-7839)

...

, ORG-9426 , ORG-8656)

Image AddedImage Added
Image AddedImage Added
Image AddedImage Added

Image Added

How to:

Go to Plot Details: Plot Properties: Box tab, set Box: Style to be I-shaped/Notched Box.

You can also change the parameters to custom your own box style.

Individual Controls for Whiskers Caps Median Mean and Distribution curve

(ORG-816)

Image RemovedImage Removed

 

Image AddedImage Added

How to:

Go to Plot Details: Plot Properties: Lines tab.

Outliers in Line

(ORG-4305)

Image AddedImage Added

How to:

  1. Go to Plot Details: Plot Properties: Box tab
    You need to set Type to be Box or Box+Data to show outliers.
  2. Check Outliers checkbox.
  3. Check Outliers in Line checkbox to line them up.

Box Chart Legend

(ORG-4346 , ORG-8960)

Image Added
Image AddedImage Added

How to:

  1. Right click the origin legend in the graph and choose

...

  1. Legend

...

  1. :Box Chart Components.

...

Image Removed                

...

  1. ...
  2. In Legendbox dialog, select the elements you want to show in the new legend.

Built-in Box Chart Themes

(ORG-7916)

Image Added

How to:

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.

Image Removed

 

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

How to

...

make the basic form of the grouped box plot

...

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)

 

How to customize to make Graph2

...

  1. Active the workbook in the Book5 in "1. Grouped Box Plot and Axis Ticks Table" 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 image below and click OK button to create a graph
    Image Removed

 

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

...

How to customize to make Graph1

Graph1 illustrate 3 improvements of the Box Chart in 9.1

...


  1. Image Added

How to Customize the Table-liked Tick Labels

Image AddedImage Added

How to:

  1. Table-liked Tick Labels
    Select Table check box
  2. Define Rows in Table
    Expand the Table tree node and select in the Number of Rows drop-down list, Bottom N node will be shown in the 
    left panel. You can select and specify the settings in the Bottom N page (right panel)
  3. Different Style of Each Row
    Select Independent Layouts check box, specify the style in the Table Layout branch of each Bottom N page.
    Each row can be hided individually if selected Hide Table Row
  4. Different Font Color and Style in Each Row
    Expand the Table tree node and select Table: Independent Formats check box and specify the format in the 
    Format branch of each Bottom N page
  5. Set Background Color of the Row
    Expand the Table tree node and select from the Fill Color colorlist.

  6. Set Border of the Row
    Expand the Table Layout tree node under the Table branch, select or clear the Near Parallel Border,
    Far Parallel Border, Inside Border and Outside Border check box
    Image Added

Image AddedImage Added

How to:

  1. Merged Cells
    Expand the Table tree node and select Merge Labels check box. Please note that only  adjacent cells containing 
    the same text will be merged
  2. Gap Between Subgroups
    Expand the Table Layout tree node under the Table branch, Select Gap Between Subgroups/Subsets check box. 
    Go to Grids node in left panel, turn on Major Grid Lines: Show check box.
    Note: The options only works for grouped plots. The spacing between subsets are controlled in the Plot Details dialog
    Image Added

How to customize to make Graph1

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

...

Image Added

How to:

Graph1 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. Indexing or mapping for data symbol color
  2. Grouped box chart from Raw Data
  3. Table-liked Tick Labels
  4. Legend for the Color-indexed Data Points

How to customize to make Graph2

Image Added

How to:

Graph2 illustrate 3 improvements of the Box Chart in 9.1

  1. Grouped box chart from Raw Data
  2. Separated control of Whisker and Cap
  3. Outliers aligned in a line
  4. Table-liked Tick Labels

How to customize to make Graph3

Image Added

...

How to:

Graph3

...

4> Choose Bottom 2 in the left panel
    * Format branch
        *> Size = 14
    * Table Layout branch
        * > Fill Color = LT Gray
5> Choose Top in the left panel
    * Display branch
        *> Type = Column Name or Label,       *> Display = Machine

    * Table Layout branch
        * > Fill Color = LT Gray
6> Click OK to apply the settings
7> Choose Grids in the left panel, in the Grids page
    * Major Grid Lines branch
        * > Select Show check box,    * > Color = Gray
    * Minor Grid Lines branch
        * >Select Show check box,    * >Color = LT Gray,    * > Style = Dash
8> Click OK to apply the settings and close dialog

 

 

 

 

 

...

 illustrate 4 improvements of the Box Chart in 9.1

...

 

...

  1. Grouped box chart from Raw Data
  2. I-Shape Box
  3. Separated control of Whisker
  4. Table-liked Tick Labels

How to customize to make Graph4

Image Added

How to:

Graph4 illustrate 3 improvements of the Box Chart in 9.1

  1. Grouped box chart from Raw Data
  2. Show median and mean line and support separated style
  3. Table-liked Tick Labels

How to customize to make Graph5

Image Added

How to:

Graph5 illustrate 2 improvements of the Box Chart in 9.1

  1. Position boxes by a column label row
  2.  Horizontal Graph

How to customize to make Graph6

Image Added

How to:

Graph6 illustrate 3 improvements of the Box Chart in 9.1

  1. Box width defined by a column label row
  2. Draw data on top of boxes
  3. Label the box and whiskers with data value