Bar Chart
Overview
Bar charts represent summarized values by a set of categories. Each category is displayed as a bar, with the height of the bar displaying the value.
Example
SQL:
SELECT AMOUNT, SOLD_ON as MONTH, ITEM
FROM ITEM_SALES
where YEAR(SOLD_ON) = 2019
Now you will prepare your result set as shown in Data Preparation so that we have the SOLD_ON (MONTH) column sort as a month of the year.
Click the create a chart button to display the Create Chart dialog. Now you will select the appropriate columns to use for the chart. In this example the value will be amount and the category will be month.
Chart Specific Options
Option | Description |
Stacked Bars | When the legend column is selected it will split each category bar into one or more bars based on the number of legend items displayed. As the number of bars increase, the harder it is to quickly interpret the chart. In this case, select the stacked bars option which will represent each category as a stacked set of values in one bar only. |
After clicking Create Chart, the bar chart will be displayed.
No Legend
Legend
Stacked Bars Option