How to Use the Combination Chart


  1. In the Filters panel, click and hold down the left mouse button on the filter representing the column that you want to split by series.

    Comment: Series by is also available in the Visualization Properties dialog.

  2. Drag the filter to the center of the visualization.

    Response: Drop targets appear in the middle of the visualization.

  3. Release the mouse button on the Series target.

    Comment: If you want to use multiple columns on the Y-axis, and set each of these as a series, you should select to series by (Column Names) in the legend or the Visualization Properties dialog.

  1. Click on the bar or line symbol next to the series in the legend and select Show as Bars or Show as Line.

    OR

  2. Right-click on the visualization and select Properties from the pop-up menu.

  3. Go to the Series page, select a series and define it as bars or a line.

    Comment: It is also possible to right-click on the visualization and select Show All as Bars or Show All as Lines to set all series to bars or lines.

  1. Click once on a line or a bar to mark the line or bar.

    Comment: If you have stacked bars, only the bar segment will be marked.

    OR

  2. Click and drag with the mouse to mark all bar segments, bars and parts of lines included in the selection.

    Comment: You can select items in different parts of the visualization by pressing Ctrl and clicking and dragging with the mouse.

  1. Right-click on the visualization and select Properties from the pop-up menu.

  2. Go to the Appearance page.

  3. Select a series to sort the X-axis by.

  1. Click on the axis selector on the Y-axis. This is where it says Sum([Column Name]), Count(...), or similar.

    Response: A drop-down menu is displayed.

  2. Select Aggregation > and a new aggregation measure from the submenu.

    Comment: You can also select Custom Expression... from the menu and create your own expression.

    Response: The combination chart is updated to show the new information.

This is an example of how to use two columns on the Y-axis. The columns will be represented by a line or a set of bars.

  1. Click on the arrow next to the plus sign on the axis of your choice.

  2. Select a new column from the menu.

    Comment: A column can also be dragged and dropped from the filters panel.

  3. Select (Column Names) in the Series by column selector.

    Comment: For more information on (Column Names), see the Non-Column Selections page.

    Response: The columns are represented by a line or a set of bars in the combination chart.

  1. Right-click on the Y-axis and select Multiple Scales from the pop-up menu.

    Comment: By default, you will get one scale for each color that is defined under Series by.

  2. You can also go to the Y-axis page in the Visualization Properties dialog and click the Multiple scales radio button. This is also where you change the settings for the different scales and determine whether a certain scale should be located on the left or the right Y-axis.

    Comment: If you are using values from different columns on the various scales, you can also use drag and drop to move columns from one side to another.

  1. Right-click on the visualization and select Properties from the pop-up menu.

  2. Go to the Lines & Curves page.

  3. Select the check box for any of the default lines or click on Add to define a new line.

    Comment: You can only add lines to the X-axis when it is in continuous mode. Right-click on the scale labels and select Continuous Scale from the pop-up menu.

  1. Right-click on the visualization and select Properties from the pop-up menu.

  2. Go to the Lines & Curves page.

  3. Click on Add and select a suitable curve fit from the drop-down menu.

    Comment: You can select from a number of predefined curve fits, or define your own curve using Curve Draw. See Curve Fit Models for more information about the different options.

  4. Once the curve has been created, you can change its settings on the Lines & Curves page. Some of the curve settings are also available from the pop-up menu in the visualization.

  1. Click on the New Combination Chart button on the toolbar, comb_new_combination_chart_button.png.

    Comment: You can also select Insert > New Visualization > Combination Chart from the menu.

    Response: A first attempt to set up a suitable combination chart is made by the application.

  2. Adjust the combination chart to display the categories and measures of your choice.

    Comment: For more information about how to change what to show on the two axes, see Column Selectors.

See also:

What is a Combination Chart?

Combination Chart Properties