27.9.1 Grouped Scatter - Indexed Data

Grouped Scatter Indexed Data.png

Data Requirements

Requires at least one Y column as input data. In addition, one or more column(s) provide grouping information.

Creating the Graph

Open the plot_gindexed dialog by one of two methods:

  • Select Plot > Categorical: Grouped Scatter - Indexed Data
  • Click the Button Grouped Scatter-Indexed Data.png button in the 2D Graphs toolbar
    Grouped Scatter Index Data Button From Toolbar.png

In the dialog that opens, select the input data range. Add at least one group column and determine where to put the Output Data. Click Preview, or OK to create your plot and close the dialog.

The plot_gindexed Dialog Box

Plot gindexed scatter dialog box.png
Data Column(s) This branch is used to specify the input data.
Group Column(s) This part includes a display box and a toolbar with five buttons Group List Toolbar.png:
  • Display Box
    The group range(s) selected using Add button will display in this box. The first selected group ranges will be set set primary categorization and form the bottom line of the column plot's group table; the secondary groups selected would continue grouping based on the primary categorization and forming the second layer of the group table, and so forth.
  • Add button Button Group List Add.png
    Click this button then choose a column from menu; or click Select Columns to open the Column Browser and add column(s) to the Display Box as grouping range(s). You can add up to 5 grouping ranges.
  • Remove button Button Group List Remove.png
    Remove the selected data range(s) from the Display Box. This button is available when you select one or more data ranges in the Group Column(s) box.
  • Move Up button Button Group List Move Up.png
    Move the selected data range(s) up in the Display Box. This changes the grouping sequence.
  • Move Down button Button Group List Move Down.png
    Move the selected data range(s) down in the Display Box. This changes the grouping sequence.
  • Select All button Button Group List Select All.png
    Select all data range(s) down in the Group Column(s).
Plot Type Specify Scatter. Note that there is a Column-Bar variant of this plot type.
Output Data Specify where to output the calculated data.

In addition, you can preview the final graph in this dialog.

  • The recalculate option in this dialog is set to Auto by default.
  • The grouping range will be sorted with default alphabetical order. If this is not acceptable , select the worksheet column, right Click and Set as Categorical. Then, you can modify list order on the Categories tab.
  • By default, we divide the columns into subsets by the first group column when we create a group column plot in this dialog. You can change the default properties of subset in the (Plot Details) Spacing Tab.


gSCATTER (installed to the Origin EXE folder)


  • Within each grouping, data points are plotted against row index. This will produce noticeably variable tick spacing on the horizontal axis, if there are significant differences in sample sizes among categories. In such cases, the user may find the Grouped Box Chart - Indexed Data, to be a better solution. Once the Grouped Box is created, open Plot Details, go to the Box tab and set Type to Data.
  • If there is more than one grouping range (datasets in the Group Column(s) box), the X axis tick labels will, by default, display as tables. You can control this behavior and formatting of the tick label table, by opening the Table tab in the Tick Labels tab of the Axis dialog.
  • You can modify the spacing between columns or column groups using controls on the Spacing tab of Plot Details as well.