A scatter chart is used to show the relationship between two variables by plotting points on a coordinate system. Each point corresponds to one pair of values, making it possible to see patterns, relationships and potential outliers graphically. This widget was implemented in version 2.3.
Scatter chart - designer
Properties
Chart subtype - this is the type of chart (scatter, bubble)
Separate colors in the series - allows you to define a different color for each point in the series
Series - a point 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 point 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, 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.
Z - for a bubble chart, the Z parameter specifies the size of the bubble in the chart. If a lookup is specified in the “Data” field, use the columns from the associated record in the formula to calculate the value for each point. If not, specify arrays of values or a range of cells.
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.
Example 1.
The chart shows a comparison of revenue for the years 2023 and 2024, with the data taken using the lookup function.
The X axis represents the months stored as text. The values are text, so change the X-axis type to categories. By default, the data is sorted by order in the table, so it is a good idea to set the correct order in the categories.
The Y axis represents revenues
The first series of data refers to 2023, and the second to 2024.
Chart properties
Scatter chart
Example 2.
This chart shows the relationship between sales, profit and the number of units sold of various products. When the bubble chart subtype is selected, an additional parameter Z is added to the data, which is responsible for the size of the bubble on the chart.
- The X axis represents the sales revenue of a product. Since product names are text, you should set the X-axis type to categories. By default, the data is sorted by order in the table, so it's a good idea to set the correct order in the categories.
- The Y-axis represents the profit from a given product, expressed in thousands of dollars.
- The Z-axis (bubble size), represents how many units of the product were sold
With a bubble chart, it is possible to visualize the relationship between three variables at the same time, where each point is assigned two coordinates (X, Y) and an additional feature expressed by the size of the bubble (Z).
Properties
Bubble chart
0 Comments