I. Overview
1) The bar chart indicates the data volume by the height or length of the bar with the same width. The data volume can be visually indicated and compared.
2) The bar chart is simple and intuitive, so it is easy to see the value according to the length of the column, and it is easy to compare the difference between each group of data. But it is not suitable for the presentation of larger datasets.
3) There are four sub-types of bar charts: ordinary bar chart, stacked bar chart, percentage stacked bar chart and custom bar chart.
Ordinary bar chart: The differences between data quantities are compared according to the length of columns.
Stacked bar chart: The numerical values of each variable are stacked in order into the total quantity, and the difference between each number area is the actual numerical value. It is suitable for showing the change of total quantity, the contribution of each variable and its change.
Percentage stacked bar chart: the percentage of each variable's value in the total amount is stacked in turn, and the total amount always corresponds to 100%. It is suitable for displaying the proportion of each variable and its change.
Custom bar chart: Users can customize the attributes of stacking and axes.
4) Suggested Reading: Chart Data, Chart Style, Chart Special Effects
| You will learn |
|---|
|
II. Steps
In this document, the custom bar chart is taken as an example, and the chart settings of other subtypes are similar.
1. Data preparation
Create a new template data query ds1, and select FRDemo for data connection. Enter the following query statement:
SELECT * FROM
Product JOIN ProductCategory
ON Product.CategoryID=ProductCategory.CategoryID
WHERE Category_name!="Daily necessities"
ORDER BY Category_name
2. Insert a chart
Take the floating chart as an example. Reference Insert Floating Chart:
Pop up the [Chart Type] panel, and select [Bar Chart] on the left.
Select [Custom]
Click [OK] to complete the insertion of the custom bar chart.
3. Data Binding
Make the following settings for custom bar chart data:
Double-click the chart
Click [Cell Element] on the right panel. Click [Data].
Select [Dataset data] for [Data source] and [ds1] for [Dataset].
Select [Category_name] for [Category]
Use field names as series names, add [Inventory_quantity], [Order_quantity] and [Re_order_quantity], and the summary method is [Sum]
4. Style Setting
1) General style
Select the chart and click on [Style]. There are various types of charts, but most of the style settings are common, which can be set by referring to Chapter Chart Style. Here we make the following settings:
Change the chart title:
Click [Title]
Change [Text] of the title to Bar Chart.
2) Special style
Some settings in the [Style] of the bar chart are different from the basic style, and will be introduced separately:
Custom axis: For custom bar charts, under [Style]>[Axis], you can add additional X and Y axes, and set the attributes of the new coordinates. For example, there are two X axes here, X Axis and X Axis2
Series-Axis Stacking: For custom bar charts, the newly added axes need to correspond to different series. You can find the settings of [Stacking and Axis] under [Style] > [Series], and customize the stacking attributes of axes and correspondence of series.
For example, here make the first series (i.e. Inventory_quantity) correspond to X-Axis, and do not select stacking or percentage stacking.
Make the second and third series (i.e. order_quantity and re_order_quantity) correspond to X-Axis2, and select stacking instead of percentage stacking.
5. Set special effects
See Setting of General Special Effects in Chapter Chart Special Effects for detailed introduction of special effects settings.
6. Preview
1) Save and preview.
2) You can see that the first series Inventory_quantity corresponds to the lower X-Axis, and order_quantity and re_order_quantity correspond to the upper X-Axis 2
3) Order_quantity and re_order_quantity are stacked on the same column, and the length of the column is the sum of the two.
