Data Analysis and Reporting with Intelligence Clients

Combination (Bar/Line) Charts

Combination charts combine some of the strengths of bar charts with the advantages of line charts. Solid bars can be used for the most important data against which other dimensions are represented in lines. In this way, emphasis is given to a portion of data based on its importance. A combination chart is especially useful for comparing two numeric values, such as amount and units of sales.

To create a combination chart that compares values:

Select Bar-Line from the Chart drop-down list.
Drag two values from the Catalog pane to the Y-Facts pane in Outliner.
Drag label items from the Catalog pane to the X-Categories and Z-Categories panes in Outliner.

To create a combination chart that compares categories within a label:

Select Bar-Line from the Chart drop-down list.
Drag a value item from the Catalog pane to the Z-Categories pane in Outliner.
Drag one or more value items from the Catalog pane to the Y-Facts pane in Outliner.
Drag a label to the X-Categories pane in Outliner.



	Note   A combination chart is most effective when the Y-Facts pane contains only two value items. It represents one value as bars and the other value as a line. When more than two values are present, the chart alternates between bars and lines in depicting the values (1st, 3rd, 5th … items are bars; 2nd, 4th, 6th … items are lines).