A mixed chart is a type of data visualization that combines different types of charts on a single axis, such as column, line and layer charts. This widget was implemented in version 2.3.
Properties
Series - a mixed chart can contain several series
Name - this is the name of the series that will be displayed in the legend and in the label when you hover over a point on the chart.
Type - this is the type of chart that will be used to represent the series, such as line, spline, area, area spline, column. You can choose a different type for each series.
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, the points on the X axis will be assigned to consecutive natural numbers or categories.
Y - if the data is retrieved using the lookup function, specify a column from the associated record. Otherwise, you can specify a range of cells or an array of values.
Data bullet - determines the shape of the points on the chart.
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 points from this series to the second Y-axis displayed on the right side of the chart.
Properties
Example 1
The chart shows the financial data of the company, which is taken directly from the table section. In this case, the Data field is left blank, because the values are not retrieved by the lookup formula but from the section - table.
The X axis represents consecutive years, written as text (e.g. “2023”, “2024”, etc.). Since the values are text, the X-axis type should be set to categories. By default, the values on the X-axis are sorted in the order in which they are taken from the table, so it's a good idea to specify the correct order of years manually to avoid a wrong layout.
The Y-axis shows financial values.
Data series and their chart types:
Customers - displayed as a column chart, indicates how many customers the company served in a given period.
Costs - displayed as a compound curve, shows the expenses incurred.
Profit - displayed as a layer chart, shows the difference between revenue and expenses
Revenue - presented as a line graph, indicates the total income generated by the company.
Series
Mixed chart
0 Comments