Sample OPJ to download to try: Column_Plots.opj
(ORG-946)
Grouped Column Graph (ORG-5344)
Menus are available under Plot: Column/Bar/Pie menu.
Buttons are available on 2D Graphs toolbar.
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.
If user wants to plot all BMW together and Ferrari together, open Plot Details, Set Subgroup Size to be 3 on Group tab.
Check Use Subgrouping (in Group tab) for Cumulative checkbox on Stack tab
The graph will turn into the following:
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)
The actual data is presented as the column width stored in the column C ("w").
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.
The graph will turn into the following:
