A Combination Chart can be created when 2 or more Measures appear in either the Columns or Rows decks. Each Measure receives its own Chart Properties item to allow choosing a Chart Type specific to that Measure.
To create a Combination Chart:
1. Execute a select * from bistudio_example within the query analyzer on the bistudio_example.xlsx file
2. Click the [Visual Analytics] icon in the Query Analyzer Grid Results toolbar.
3. Drag DueDate from Dimensions to Columns.
4. Right click on DueDate in Columns and select [Month] date grouping from the top half of the Date Grouping format options.
5. Drag Tax Amount, Freight and Profit from Measures to Rows.
6. Notice in the Chart Properties there are 3 additional rows (one each for Tax Amount, Freight and Profit).
7. Click on Tax Amount in the Chart Properties and select [Bar] for its Chart Type.
8. Click on Freight in the Chart Properties and select [Line] for its Chart Type.
9. Click on Profit in the Chart Properties and select [Line] for its Chart Type.
10. Click on [All] at the top of the Chart Properties. Its Type should now indicate Multiple. Click its [Axes] button and select [Merged Axes].
11. You should now see a Combination Chart that includes lines for Freight and Profit, as well as vertical bars for Tax Amount.
The charts are layered on top of one another with the right most Measure in the Rows or Columns deck appearing on top. Drag them into new positions to stack the chart layers how you like.
Cell Space in Combination Charts
When a Combination Chart is created, measures in the chart get their own Cell Space within a Field label. Cell Spaces for a Field Label are rendered in the same physical area in a Combination Chart to allow overlays of Chart Types in the same View within a Merged Axis. Cell Spaces make possible displaying a Line Chart on top of a Bar Chart. In the case of multiple bars, multiple measures in the same Cell Space are rendered in the same location.
This may make it appear that some of your measures are not being rendered, when in fact they are. Changing which measures appear farthest right on your decks can assist in revealing them.
Other Actions
Other actions that you can perform on a plotted combination chart are as follows:
- You can sort data by using various sort options available in the chart view or the Advanced dialog. For more information, see Sorting.
- You can use highlight actions to focus on selected combinations. Visual Analytics makes the highlighted combinations and its data labels prominent while dimming others in the view. For more information, see Highlight Actions.
- You can filter records directly from the chart view without manually adding any fields to the Filters Deck. For more information, see Filters.
- You can export worksheets containing visualization to Image, HTML, and PDF formats. For more information, see Export Visualizations.