Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 86 Next »

 

(ORG-2523)(star)

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:

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

Box position with information from Column Label Rows

  (ORG-1943,  ORG-4094)

How to:

  • Position boxes by a column label row: 
    Go to Plot Details: Plot Properties: Box tab, choose label name in  X Position 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)



How to:

  • Index boxes width by a column label row: 
    Go to Plot Details: Plot Properties: Box tab, check Box Width by Parameter checkbox and set Scaling Factor.
  • Show value for box chart range:
    Go to Plot Details: Plot Properties: Box tab, check Box Labels checkbox and Whisker Labels.
  • 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.

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)

How to:

Go to Plot Details: Plot Properties: Lines tab.

Outliers in Line

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)

How to:

  1. Right click the origin legend in the graph and choose Legend:Box Chart Components....
  2. In Legendbox dialog, select the elements you want to show in the new legend.

Built-in Box Chart Themes

(ORG-7916)

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.

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

  1. Active 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

 

How to Customize the table-liked Tick Labels

 

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
    Expand the Table Layout tree node under the Table branch, Select Independent Layouts check box, specify 
    the style in the Table branch of each Bottom N page
  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


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. Have Gap between each subgroups
    Expand the Table Layout tree node under the Table branch, Select Gap Between Subgroups/Subsets check box. 
    Note: The options only works for grouped plots. The spacing between subsets are controlled in the Plot Details dialog


How to customize to make Graph1

How to:

Graph1 illustrate 3 improvements of the Box Chart in 9.1

  1. Indexing or mapping for data symbol color

 


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

==Steps==
1> Active the workbook Book5 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)

 

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

==Steps==
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

 

How to customize to make Graph3

Graph3 illustrate 4 improvements of the Box Chart in 9.1
1) I-shape box -->Plot Details dialog, Box tab
2) Separated control of Whiskers --> Plot Details dialog, Lines tab
3) Grouped Box plot -->Plot Details dialog, Group tab
4) Table option for the tick labels. -->Axis dialog, Tick Labels>Bottom/Top Node, Table check box

==Steps==
1> Active the worksheet Book3 in the folder, highlight column C through column N, 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 = 3,    * 1st Group Row = Machine,    * 2nd Group Row = Comments,    * 3rd Group Row = Long Name,    * Graph Theme = Box_I-shaped

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
    * Subgrouping group
        * >Subgroup size = 2
    * 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 %) = 0
4>Select Lines tab, apply settings as below
    * Whisker group, Style = Dash,    * Caps Length = 50,    * Caps Style = Solid
5> Click OK button to apply the settings and close dialog

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>Bottom1 node in the left panel.
    * > Right-click to select Move to Opposite from the context menu.
3> Choose Bottom 1 in the left panel
    * Table branch
        * > Select Independent Formats check box
    * Table Layout branch
        * > Fill Color = LT Gray,       * > Select Independent Layout check box

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

 

How to customize to make Graph4

Graph4 illustrate 4 improvements of the Box Chart in 9.1
1) Outliers aligned in a line  -->Plot Details dialog, Box tab
2) Show median and mean line and support separated style  --> Plot Details dialog, LInes tab
3) Grouped Box plot  -->Plot Details dialog, Group tab
4) Table option for the tick labels.  -->Axis dialog, Tick Labels>Bottom/Top Node, Table check box

==Steps==
1> Active the workbook Book1 in the folder, highlight column N1 through column I, 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 = Long Name,    * 2nd Group Row = Comments,    * 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, 3: Dark Yellow),    * Box Color>Increment = By One,    * Box Color>Details = (1: Red, 2: Navy, 3: Dark Yellow)
3> Select Percentile tab, apply settings as below
    *Edge Color = White
4>Select Lines tab, apply settings as below
    * Whisker group, Color = Black,    * Median Line group, Color = White,    * Select Mean Line check box,    * Mean Line Width = 3,    * Mean Line Color = White
5>Select Spacing tab, apply settings as below
    * Gap Within Subgroups = 40
6> Click OK button to apply the settings and close dialog

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 in the left panel. in the X Axis page
    * Uncheck Show Top Axis check box
3> Choose Tick Labels>Bottom1 node in the left panel. In the Bottom1 page,
    * Format branch
        * >Color = Wine
        * >Font branch
            * >> Font = Times New Roman
    * Table branch
        * > Select Independent Formats check box
        *> Table Layout branch
            *>> Fill Color =  Cyan,    *>> Select Gap Between Subgroups/Subsets check box,     *>> Select Independent Layouts check box

4> Select Bottom 2 node in the left panel, in the Bottom 2 page
    * Format branch
        * >Font branch
            * >> Font = Times New Roman,    * >> Size = 16
    * Table Layout branch
        * > Fill Color = LT Cyan,    * > Select Near Parallel Border check box,    * > Select Far Parallel Border check box,
        * > Select Perpendicular Border check box,    *> Select Gap Between Subgroups/Subsets check box
5>. Choose Grids in the left panel, in the Grids page
    * Major Grid Lines branch
        * > Select Show check box,    * > Color = Wine,    * > Thickness = 1
    * Minor Grid Lines branch
        * >Select Show check box,    * >Color = Olive,    * > Style = Dot,    * > Thickness = 1
6> Choose Y Axis in the left panel, in the Y Axis page
    * Uncheck Show Right Axis check box
7> Choose "Y Axis>Tick Labels>Left" node under the Y Axis, in the Left page
    * Display branch
        * > Display = Scientific: 10^3
8> Click OK to apply the settings and close dialog

 

How to customize to make Graph5

Graph5 illustrates the following two improvements with box chart in 9.1:
1 ) The X position of multiple box plots can be defined by the parameter in a column label row.  --> Plot Details dialog, Box tab
2) Horizontal box plots  --> "Graph: Exchange X-Y Axes" menu

==Steps==
1> Active the worksheet "USMeanTempera" in the folder, highlight column D through column O, select "Plot: Statistics: Box Chart" from Origin menu

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>Increment = None
3> Select Pattern tab,  apply settings as below
    * Border group, Color = Dark Gray,    * Fill group, Color = White

4> Select Box tab, apply settings as below
    * Box group, Box Width (%) = 60,    * Select Outliers check box,    * Select Outliers in Line check box,    * X Position  = Comments
5> Click Apply button
6> Select Symbol tab, apply settings as below
    * Size = 3,    * Shape = 2 Circle
7> Select Percentile tab apply settings as below
    * Size = 0
8>Select Lines tab, apply settings as below
    * Caps Length = 0
9> Choose Layer1 in the left panel and select Background tab
    * Color = LT Gray
10> Click OK button to apply the settings and close dialog
11> Delete the Legend on graph.

Select Graph: Exchange X-Y Axes from Origin menu to exchange X, Y Axes. Then we are going to customize the axis and tick labels
1>. Double click on the left axis to open the Axis dialog.
2> Choose X Axis>Scale node in the left panel. In the Scale page
        * > Select Reverse
   * From = 0.5,    * To = 12.5,
   * Major Ticks group
        * > Value = 1
3> Choose X Axis>Tick Labels>Left node under the X Axis branch in the left panel. In the Left page,
    * Display branch
        * >Type = Tick - indexed string
        * >Display = January February March April May June July August September October November December
4> Choose X Axis>Grids node in the left panel
     * Additional Lines branch
         * > Select Opposite check box

4> Choose Y Axis node in the left panel
    * > Unselect Show Bottom Axis,    * > Select Show Top Axis

5> Choose Y Axis>Grids node in the left panel
    * Major Grid Lines branch
        * > Select Show check box
        * > Color = White
    * Additional Lines branch
        * > Select Opposite check box
6> Click OK to apply the settings and close dialog

How to customize to make Graph6

Graph6 illustrates the following two improvements with box chart in 9.1:
1) Box width of multiple box plots can be defined by the parameter in a column label row.  --> Plot Details dialog, Box tab
2) Draw data on top of boxes  --> Plot Details dialog, Box tab
3) Values of the box and whiskers can be added to label the box plot  --> Plot Details dialog, Box tab

==Steps==
1> Active the worksheet "BoxData" in the folder, highlight column B through column D, select "Plot: Statistics: Box Chart" from Origin menu

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>Increment = None

3> Select Pattern tab,  apply settings as below
    * Border group, >Color = Blue
       * >Border Style = Solid,    * > Border Width = 2
    * Fill group,    * Color = Custom (Red:156, Green: 190, Blue: 254)
4> Select Box tab, apply settings as below
    * Type = Box + Data Overlap,    * Select Box Width by Parameter,    * Box Width (%) = Width,    * Select Outliers check box
    * Select Outliers in Line check box,    * Select Box Labels check box,    * Select Whisker Labels check box
5> Select Data tab, apply settings as below
    * Data Width (%) = 10
6>Select Symbol tab, apply settings as below
    * Size = 5,    * Shape = 7 (Cross(x))
7> Click Apply button to apply the settings
8> Select Layer1 in the left panel, select Background tab, apply settings as below
    * Color = Custom (Red:177, Green: 237, Blue: 254)

Then we are going to customize the axes
1> Double click on the left axis to open the Axis dialog.
2> Choose X Axis>Grids node in the left panel
     * Additional Lines branch
         * > Select Opposite check box
3> Select "Y Axis: Scale" node in the left panel, apply settings as below
    * From = 510,    * To = 2750,    * Major Ticks group, Increment = 250,    *Minor Ticks group, Count = 0
4> Select "Y Axis: Grids" in the left panel, apply settings as below
    * Major Grid Lines group
        * > Select Show check box,    * > Color = LT Gray,    * > Style = Dot
    * Additional Lines branch
        * > Select Opposite check box
5> Click OK the apply the settings and close dialog


 

  • No labels