How to Use the Combination Chart

To apply series (split in categories):

1. On the authoring bar, click to open the Data in analysis flyout.

2. In the flyout, drag the column you want to split by series to the center of the visualization.

   Response: Drop targets are shown in the middle of the visualization.

3. Drop the column on the Color 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.

4. In the legend, specify whether to display the series as bars or a line. See 'To switch between bars and lines' below.  

To switch between bars and lines:

1. Click 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 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 the visualization and select Show All as Bars or Show All as Lines to set all series to bars or lines.

To mark bars or lines:

1. Click a line or a bar once 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.

To sort the combination chart:

1. Right-click 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.

To change the aggregation type:

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

2. Select a new aggregation measure from the drop-down list.

   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.

To use multiple columns on one axis:

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 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.

   Response: (Column Names) is automatically selected in the Series by column selector. For more information on (Column Names), see the Non-Column Selections page.

3. If you want to display the values from one of the columns as a line instead of as bars, click the icon in the legend representing that column and select Show as lines.

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

To add more than one scale to the Y-axis:

 When the measures on the Y-axis are of completely different magnitudes, you might benefit from using more than one scale on the axis.

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

   You can also go to the Y-axis page in the Visualization Properties dialog and click the Dual scales or 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 side.

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

To add a reference line to the combination chart:

1. Right-click 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 Add to define a new line.

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

To add a curve fit to the combination chart:

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

2. Go to the Lines & Curves page.

3. Click 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.

To create a new combination chart:

1. On the authoring bar, click    to open the Visualization types flyout.

2. Drag the Combination chart visualization to the wanted position on the analysis page.

   Response: A first attempt to set up a combination chart is made. Initially only bars are shown. How to display lines as well as bars is described in To apply series and To switch between bars and lines.

3. 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.