6.7.6 Clustered-Stacked Column Chart

Summary

This tutorial will show you how to create a clustered-stacked column chart in Origin. This graph consists of two graph layers, each of which has a stacked column.

Clustered-Stacked Column Chart.png

Minimum Origin Version Required: Origin 8.5.1 SR0

What will you learn

This tutorial will show you how to

  • Create a stacked column graph.
  • Create a graph that has two stacked column graphs.
  • Customize a column chart.

Steps

After version 2015, Origin supports to set subgroup for mutilple stacked column plots in a layer. And it is easier to plot the grouped stacked columns graph. Please refer this tutorial: Grouped Stacked Column


  1. Import the sample data Data 1 and Data 2 into different worksheets in Origin. Set the first line as Long Name for them and set the sheet names as 2010 and 2011 respectively.
    Clustered-Stacked Column Chart 00.png
  2. Create a new graph layer by selecting File : New : Graph from the main menu. And then select Insert: New Layer: No Axes(Link XY Scale and Dimension) from the main menu to add another layer to the graph window you just created.
  3. Select Graph: Plot Setup... from the maint menu to open the Plot Setup dialog. In this dialog, select Column/Bar in the Plot Type box, select worksheet 2010 and 2011 in the top panel respectively, assign col(A) as X and col(B)~col(D) as Y in the middle panel, and then click the Add button to add them to Layer 1 and NoAxes layer respectively.
    Clustered-Stacked Column Chart 01.png

    In order to show all three panels in Plot Setup dialog, please expand Plot Type panel by clicking Button Expand Preview Up.png and expand Available Data panel by clicking Button Expand Preview Up.png again.

    Please refer to Plotting using Plot Setup for more information.

  4. Click OK button to close the Plot Setup dialog. Click the Rescale button, you will get a graph with two column graphs overlapped as shown below:
    Clustered-Stacked Column Chart 02.png
  5. Double-click on the graph to open the Plot Details dialog. Select Layer1 level in the left panel, go to Stack tab in the right panel, and select the Cumulative option. Select NoAxes level, do the same setting.
    Clustered-Stacked Column Chart 10.png
  6. Select Graph1 level in the left panel, go to the Miscellaneous tab in the right panel, and check the Column/Bar Gap/Offset Across Layers check box.
    Clustered-Stacked Column Chart 03.png
  7. Click OK button, you will see the plot with two stacked columns will show side by side with an auto gap.
    Clustered-Stacked Column Chart 04.png
  8. Double-click on the graph to open the Plot Details dialog again. Set the Border Color and Fill Color respectively, as shown below:
    Clustered-Stacked Column Chart 05.png
    Clustered-Stacked Column Chart 07.png
  9. Go to the Pattern tab to set the Transparency as 40, Border Width as 0.2, and Gradient Fill as shown for both graph layers:
    Clustered-Stacked Column Chart 06.png
  10. Click OK button to close the Plot Details dialog.
    Clustered-Stacked Column Chart 08.png
  11. Right-click on the graph legend, select Update Legend from the context menu to open the LegendUpdate dialog. Set the Update Mode as Reconstruct, Legend as One Legend for All,Layer Order as Descending and Plot Order within Layer as Ascending.
    Clustered-Stacked Column Chart 09.png
  12. Click OK button to close the dialog and then update the axis labels, you will get the final graph shown below:
    Clustered-Stacked Column Chart.png

Sample Data

Data 1

Product A Product B Product C
Jan 42 33 40
Feb 88 85 37
Mar 99 34 82
Apr 51 43 38
May 21 66 52
Jun 74 31 28

Data 2

Product D Product E Product F
Jan 96 87 35
Feb 62 66 15
Mar 65 86 51
Apr 32 24 87
May 77 26 34
Jun 69 33 71