29.10.2 Grouped Columns

grouped-column-index-data

Data Requirements

You need to have at least one Y column as input data. Optionally, you can have an additional associated Y error column for each Y column. Another column provides grouping information.

Creating the Graph

Open the plot_gindexed dialog by one of three methods:

• Select Plot > Categorical: Grouped Columns... menu items
• Click the button in the 2D Graphs toolbar

  

In the dialog that opens, select the input data range. Add at least one group column and determine where to put the calculated data. You can then generate a grouped column plot.

You can refer to the section below for the detailed dialog controls:

The plot_gindexed Dialog Box

To plot the graph from Summarized Data

In this example, all sales data will be plotted as bars against the groups(on X axis) selected in Group Columns.

To plot the graph from Raw Data

In this example, the mean values of height and weight data will be plotted as bars against the groups(on X axis) selected in Group Columns.

For Summarized Data

By default, the Data Form has been set to Summarized Data. This mean the input data is indexed data.

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

For Raw Data

If you choose Raw Data for Data Form dropdown list, two options about statistics will appear to let you specify which statistic information of selected Input data will be shown as columns or bars and their error bars; and another option Stack Data will show up for Column and Bar plot type, which is used to specify the data to stack.

• Bar Statistic: You can choose one kind of statistical values to be shown as columns or bars. There are Mean, N, N Missing, Median, Min, Max, Sum, SD, Geometric Mean, Harmonic Mean and Variance available under the drop-down list.
• Error Bar Statistic: You can choose one kind of statistical values to be shown as error bars for the columns or bars. There are None, SD, SE of Mean, 95% CI of Mean, 10%-90%, 5%-95%, 1%-99%, Q1-Q3, Min-Max and Median Absolute Deviation available under the drop-down list.
• Stack Data: Specify the data to stack. When Variables is selected, stack columns by input variables for each subset in layer level cumulatively. When Last Group is selected, stack columns by last group column. Note: Stack last group is only supported when the number of group columns is greater than 1.

  

Other options are same as that of Summarized Data.

Examples

Create a new workbook and click the button to import the Categorical Data.dat file under <Origin EXE Folder>\Samples\Graphing path. Highlight column B and select Plot > Categorical: Grouped Columns... from top menu to open the plot_gindexed dialog. In the Group Column(s) section, click the Add button in the top right corner and add column D as the first grouping range, then similarly add column C as the second grouping range. Click OK to output the plot data and graphs into the newly generated sheets.

For a more extensive tutorial, you can try Grouped Column with Error Bars and Data Labels. The tutorial addresses such things as Fill Pattern and the use and customization of tick label tables (seen in the above graph) for labeling the X axis.

Template

gColumn.otpu (installed to the EXE folder of Origin)

Notes

• If there is more than one grouping range (in the Group Column(s) box), X axis tick labels will, by default, display as tables. You can control this behavior and formatting of the tick labels table, in general, by opening the Table tab in the Tick Labels tab of the Axis dialog.
• By default, this plot uses Indexing to apply fill color, but there are other options. The following figure shows three variations of the same graph, the difference being in the way that color is applied to the bars:

• In the graph on the left, bar color is indexed to subgroup (Gender). This is the default and should work for most situations including unbalanced plots.
• In the middle graph, bar color is indexed to main group (Drug).
• In the graph on the right, bar color is set to increment, with subset size of 8.

For more information, see:

• Indexing
• Using a Saved Increment List
• Plot Details Spacing Tab, Subset

• You can modify the spacing between columns or column groups using controls on the Spacing tab of Plot Details as well.
• If you want to create a grouped bar plot, just change the Plot Type to Bar in the plot_gindexed dialog. Alternately, you can create a grouped column plot using the menu command, then choose Graph: Exchange X-Y Axis.
• If you want to created a grouped scatter plot, just change the Plot Type to Scatter in the plot_gindexed dialog. The source data will be sugrouped according to your Grouping column.

Version Information