Combination charts - Example 2

This example creates a combined column and line chart in which the columns represent the sales of all products over twelve months, and five lines represent sales of four individual product groups: All Season Tires, Summer Tires, Winter Tires, and SUV (4x4) Tires.

In this example, you assign the Column chart-type to one data series and the Line chart-type chart type to the remaining data series.

  1. In cells C30:D30, create a hyperblock from the Product dimension.
  2. In cell D29, create a hyperblock from the Period dimension.
    The value cells of the two hyperblocks overlap in cell D30.
  3. Insert a CELLGET function in cell D30.
  4. Click the border of the Product hyperblock. In the List Designer, select the All Tires element, All Season Tires, Summer Tires, Winter Tires and SUV (4x4) Tires.
  5. Click the border of the Period hyperblock. In the List Designer, use the Descendants function to select Descendants of 2016 at Level Month
    In View mode, the 12 months of 2016 are displayed.
  6. Highlight the overlapping hyperblocks and use the Chart Wizard to create the default column chart.
    In View Mode, the chart displays four columns for each month of 2016. The columns represent sales of All Tires and of the selected product groups in each month.
  7. Double-click the chart and click the second column of sample data.
    The column is selected.
  8. Right-click the column, and select Chart Type.
    The Chart Type dialog is displayed.
  9. Select Lines as the chart type and select one of the chart subtypes and click OK.
  10. Select Lines as the chart type for the third column of sample data.
  11. Click OK.
    In View mode, the columns of the chart represent sales of all products over twelve months. Four lines represent the sales of the individual product groups over the same period.