A radar chart is a visual tool for representing multiple variables with respect to a common reference point, with the variables represented on axes extending from that point. It is a very useful tool for comparing different data sets in the context of the same categories. This widget was implemented in version 2.3.
Properties
Series - the radar 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.
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
Example 1.
Suppose we want to compare the ratings of three different cars in different categories, such as acceleration, security, comfort, fuel economy and price. The data is retrieved using the lookup function.
The X axis represents the categories stored as text. Since the values are text, set the X-axis type to categories. By default, the data is sorted by the order in which it is retrieved from the table, so it is a good idea to enter the correct order in the categories.
The Y axis represents the values.
The radar chart shows how each car performs in these categories. Each car has its own set of lines on the graph, so you can quickly compare results.
Series
Radar chart
0 Comments