A simple Bar Chart is created when a Dimension is placed in the Columns deck and a Measure is placed in the Rows deck.
Download and connect to the sample data source. We are making this chart using 1 dimension and 1 measure.
1. Execute a select * 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 Card Type from Dimensions to the Columns deck.
4. Drag Freight from Measures to the Rows deck.
5. Select [Bar] in the Chart Properties dropdown.
Clustered Bar Chart
A Clustered Bar Chart is created when a Dimension is placed in the Columns deck and two or more Measures are placed in the Rows deck.
1. Execute a select * 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 Card Type from Dimensions to the Columns deck.
4. Drag Freight from Measures to the Rows deck.
5. Drag Profit from Measures to the Rows deck.
6. Select [Bar] in the Chart Properties dropdown.
7. Select [Merged Axes and Side-by-side] in the Axes Properties dropdown.
Stacked Bar Chart
A Stacked Bar Chart is created when a Dimension is placed in the Columns deck and 2 or more Measures are placed in the Rows deck.
1. Execute a select * 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 Card Type from Dimensions to the Columns deck.
4. Drag Freight from Measures to the Rows deck.
5. Drag Profit from Measures to the Rows deck.
6. Select [Bar] in the Chart Properties dropdown.
7. Select [Merged Axes] and [Stacked] in the Axes Properties dropdown.
Horizontal Bar Chart
A Horizontal Bar Chart is created when a Measure is placed in the Columns deck and a Dimension is placed in the Rows deck.
1. Execute a select * 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 Freight from Measures to the Columns deck.
4. Drag Card Type from Dimensions to the Rows deck.
5. Select [Bar] in the Chart Properties dropdown.
Charts can quickly be swapped from Vertical to Horizontal and vice versa by selecting [Analysis > Swap Rows and Columns] or clicking its button in the Toolbar.
For more on how to modify charts, such as showing Independent Axes and Dual Axes, see Chart Properties Axes.
Other Actions
Other actions that you can perform on a plotted bar 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 bars. Visual Analytics makes the highlighted bars 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.