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.

In cells B28:C28, create a hyperblock from the Product dimension.
In cell C27, create a hyperblock from the Period dimension.
The value cells of the two hyperblocks overlap in cell C28.
Insert an ROC function in cell C28.
See ROC.
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.
Click the border of the Period hyperblock. In the List Designer, use the Descendants function to select Descendants of 2004 at Level 4
In View mode, the 12 months of 2004 are displayed.
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 2004. The columns represent sales of All Tires and of the selected product groups in each month.
Double-click the chart and click the second column of sample data.
The column is selected.
Right-click the column, and select Chart Type.
The Chart Type dialog is displayed.
Select Lines as the chart type and select one of the chart subtypes and click OK.
Select Lines as the chart type for the third column of sample data.
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.