Versions Compared

Key

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

Table of Contents
minLevel2

  

Sample OPJ to download to try: 

...

Column_Plots.opj

(ORG-946)(star)

Product Page of Column and Bar Plot

Table of Contents
maxLevel3
minLevel2

Grouped Column Graph (ORG-5344

...

Origin supports plotting grouped column graph including error bars from indexed data.

Image Removed

, ORG-9449)

Menus are available

...

under Plot: Column/Bar/Pie

...

 menu.

Buttons are available

...

on 2D Graphs

...

Image Removed

Grouped Stacked Column Graph (ORG-949)

 

After plotting Stacked Column Graph, user can set subgroup size of a stacked column on Group tab of Plot Details dialog. E.g the following data.

 

Image Removed

If user wants to plot all BMW together and Ferrari together, open Plot Details, Set Subgroup Size to be 3 on Group tab.

Image Removed

Check Use Subgrouping (in Group tab) for Cumulative checkbox on Stack tab

Image Removed

The graph will turn into the following:

 

 Image Removed

Variable Column/Bar Width (ORG-4155)

After plotting Stacked Column Graph, e.g from the following data.
Here, %Share in column F is not the actual data, but the calculated X center positions of columns
using the Set Column Formula:

 i==1?(col(C)[i]/2):(col(F)[i-1])+(col(C)[i-1]/2)+(col(C)[i]/2)

...

Image Removed

To set the column width from a dataset, set the dataset to Width field in Spacing tab in Plot Details.
You also need to set the Scaling Factor to 0, which is the new 9.1 feature (ORG-6010) to indicate the width data  or symbol size data from worksheet is in the same unit as the X axis.

Image Removed

The graph will turn into the following:

Image Removed

 

...

 toolbar, Image Added.

Image AddedImage Added
Image Added

Image Added

Image Added

How to:

  • Click Select Columns... to add multiple grouping columns into Group List orjust select the fly-out one by one.
    You can modify the sequence in Group List by Move Up/Down and Remove.
  • Uncheck Sort Groups if you don't want to sort the groups in alphabetical order of group name.
  • Set Plot Type as Bar.
  • Go to Plot Details: Plot Properties: Spacing tab, input Gap Between Subsets(%) to specify gap size between subgroups.
  • Double click Tick Labels to open Axis dialog. Each row of the table has one node under Tick Labels node. Right click the node to move/delete it.


Note:

  • The size of input range and all the group ranges must be equal.

Grouped Stacked Column/Bar Graph (ORG-949)

Image AddedImage Added
Image AddedImage Added
Image Added

 

Image Added

How to:

  1. Go to Plot Details: Plot PropertiesGroup tab, set Subgroup Size.
    This means how many columns/bars will be stacked to become a new column/bar.
  2. Go to Plot Details: Layer Properties: Stack tab, choose Offset to be Cumulative and check Use Subgroup (in Group tab) for Cumulative checkbox.

Subgrouping in Normal Column Plot

Image AddedImage Added

Image Added

How to:

  • Within the same dataset:
    Go to Plot Detail: Plot Properties: Spacing tab, set Subsize Size and Gap Between Subsets(%).
  • In different dataset:
    Go to Plot Details: Plot PropertiesGroup tab, set Subgroup Size.
    Use increment checkbox indicated to repeat increment list within each subgroup.