Combination charts - Example 1

This example creates a combined column and line a chart which represents sales of all products over twelve months. In this example, you duplicate an existing data series and assign the Column chart type to the existing series and the Line chart-type to the duplicate data series.

To create this example:

  1. In cells C9:D9, create a hyperblock from the Product dimension.
  2. In cell D8, create a hyperblock from the Period dimension.
    The value cells of the two hyperblocks overlap in cell D9.
  3. Insert a CELLGET function in cell D9.
  4. Click the border of the Product hyperblock. In the List Designer, select only the All Tires element.
  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 a single column for each month of 2016. The columns represent sales of All Tires in each month.
  7. In Design mode, double-click a blank area of the chart.
    A hashed border is displayed.
  8. Right-click and select Data Source.
    The Data Source dialog is displayed. The current data series is displayed in the List of Series.
  9. Click Add.
    The current data series is duplicated in the List of Series.
  10. Click OK.
    In View mode, two columns are displayed for each month.
  11. In Design mode, double-click the chart.
    Three columns of sample data are displayed. The legend displays {Product-}, {Product-} 1, and {Product-} 2.
  12. Click the {Product-}1 column to select it.
  13. Right-click and select Chart Type.
    The Chart Type dialog is displayed.
  14. Select Lines as the chart type and select one of the chart subtypes and click OK.
    In View mode, the line chart links the tops of the columns. Both charts represent the same, single, data series.