A bar chart is a graphical form of representing data by means of rectangular bars whose length corresponds to numerical values. It can be used to compare different values. This widget was implemented in version 2.3.
Bar chart - designer
Chart properties
Stacked - will allow you to see how revenues from each customer changed and how much the total amount was in a given year.
Stacked 100% - the chart shows the values as a percentage of each value in the total, which helps you see how each value affects the entire category in relation to its proportion.
Separate colors in series - allows you to define a different color for each point in the series
Bar overlapping - determines the placement relative to each other of bars from different series that have compatible values on the X axis.
- None
- Partical
- Full
Series
Series - a bar chart can contain several series
Name - this is the name of the series, which will be displayed in the legend and in the label when you hover over a bar on the chart.
Data - if the data comes from an external table or list, use a lookup formula to get the correct records. If the data is typed directly into the field or given as a cell address, you can leave the field blank.
X - if the data is retrieved using the lookup function, indicate the column from the related record. Otherwise, you can specify a range of cells or an array of values. If X values are not specified, columns will be assigned to consecutive natural numbers or categories.
Y - if the data is retrieved using the lookup function, indicate a column from the associated record. Otherwise, you can specify a range of cells or an array of values.
Data labels - labels that help the user read the values on the chart:
- Tooltip - When you hover over a point on the axis, its value will be displayed
- Fixed - values are displayed directly on the chart
- None - labels will not be displayed
Second Y-axis - allows you to assign values from this series to the second Y-axis displayed on the right side of the chart.
Example 1.
The chart shows revenue for 2023 and 2024 of a certain company. The data is taken using a lookup formula.
- The X axis represents the year stored as text. Since the values are text, set the X-axis type to categories. By default, the data is sorted by order in the table, so it is a good idea to enter the correct order in the categories.
- The Y axis represents financial values
Data series and their chart types:
- Expenses - shows the expenses incurred.
- Revenue - indicates the total revenue generated by the company.
- Profit - the difference between revenue and expenses
Properties
Bar chart
0 Comments