Page History
...
- Execute a select * from bistudio_example within the query analyzer on the bistudio_example.xlsx file
- Click the [Visual Analytics] icon in the Query Analyzer Grid Results toolbar.
- Drag DueDate from Dimensions to Columns.
- Right-click on DueDate in Columns and select [Month] date grouping from the top half of the Date Grouping format options.
- Drag Tax Amount, Freight, and Profit from Measures to Rows.
- Notice in the Chart Properties there are 3 additional rows (one each for Tax Amount, Freight, and Profit).
- Click on Tax Amount in the Chart Properties and select [Bar] for its Chart Type.
- Click on Freight in the Chart Properties and select [Line] for its Chart Type.
- Click on Profit in the Chart Properties and select [Line] for its Chart Type.
- Click on [All] at the top of the Chart Properties. Its Type should now indicate Multiple. Click its [Axes] button and select [Merged Axes].
- You should now see a Combination Chart that includes lines for Freight and Profit, as well as vertical bars for Tax Amount.
| Info |
|---|
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. |
...
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
...