A pie chart is a graphical tool that allows you to present data in the form of a division of the circle into elements, where each element represents a proportional share of a category in the total.
Properties
Chart subtype - selection of pie chart or donut chart
Separate colors in the series - allows you to define different colors for each element
Selected element - allows you to highlight one value on the chart, by bringing it to the outside. The formula must return the value of the category assigned to the element.
Series - the pie chart has only one series.
Name - this is the name of the series that will be displayed in the label when you hover over a particular part of 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.
Categories - if the data is retrieved using the lookup function, indicate the appropriate column from the associated record that contains categories, such as month names, expense types or customer groups. Categories must be of text type in order for the chart to correctly assign values to the appropriate labels. If data is entered manually, a range of cells or an array of values can be specified, such as [“January”, “February”, “March”]. If the category field is left blank, the chart will automatically assign the generated names in slice form for each value, and a numerical value will be displayed below it.
Value - if a lookup formula is used in the “Data” field, indicate the 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
Chart pie Chart donut
Chart pie - one color Chart donut - one color
Example 1.
Shows a pie chart of the number of trainings conducted in different categories. The data is retrieved using the lookup function, which means that the numerical values (e.g. number of trainings) are dynamically retrieved from an external data table.
The pie chart shows the three categories as parts of a circle, and their size (proportion) depends on the number of trainings in the category. Since in the pie chart each part represents a certain proportion of the whole, we see that the “Training” category will have the largest piece of the circle (40 trainings), followed by “sales” with 29 trainings and “HR” with 10 trainings.
Selected element - "Sales"
0 Comments