- Multi-Series Stacked

Multi-Series Stacked Charts

This tutorial will show how to create a multi-series stacked bar 2D graph via the following set of steps:

  1. Create a new SQL operation

    1. In the Advanced » JSP File field, input:

      1. See Figure 1

      1. /wow/fusion/jsp/fusionChart.jsp

      1. :

  1. In the Basic » Operation Code field, create an SQL operation similar to the format: SELECT column1, column2, column3 FROM schema.table

    1. Column 1 is the source of each group of data nodes

    2. Column 2 assigns the nodes within each group

    3. Column 3 is the source of the values of single data node

    4. Under the Display » Properties field, remove all existing code and insert the following code:

      1. Fusion { debugMode:0; type:StackedBar3D; width:800; height:1000; script:<chart caption='WOW Fusion' subCaption='WOW POWER' outCnvbaseFontSize='18' bgColor='C0C0C0' xAxisName='Items' yAxisName='Revenue' showValues='0' animation='1' showBorder='0' borderThickness='0' numberPrefix='$' chartTopMargin='1'>??WOW_DATA </chart> ;}

      1. See Figure 2

      1. The type value (in this case, StackedBar2D) may be changed to reflect the wanted graph type

      2. The width and height values may be changed to adjust the dimensions of the chart

      3. Chart section properties may be edited for more customization

  1. Insert the operation and run

Types of multi-series stacked charts include: StackedColumn2D, StackedColumn3D, StackedArea2D, StackedBar2D, StackedBar3D, and MSStackedColumn2D.