Category Axes
In case of a multi-series donut a category axis is available.
Property | Description | Value | Description | ||
|---|---|---|---|---|---|
Use series to determine the values | For the category axis, you can also specify the values by means of series instead of formulas. This means that you define the different series (e.g. measured value/target value/actual value) with a single data record. Select the "Use rows as data source" entry from the drop-down list above the properties. This option changes the properties and the "Series Definition" property becomes available. You define the individual series by opening the "Series Definitions" dialog. You can define the properties differently for each series and move it with the arrow buttons. The property "Calculation Type" allows displaying e.g. a moving average or the aggregation of data. |
| Dialog | ||
Coordinate Value | Here you choose the data source for the coordinate, e.g. "name" with persons or "month" with dates. | Formula | Formula wizard | ||
Sort Coordinates | Specifies whether the coordinates are to be sorted (alphanumeric or numeric). | 0 1 2 3 4 5 | Ascending Descending Unsorted Result ascending Result descending Formula wizard | ||
Number of Records for Design | Sets the number of records for the preview. | Number | Formula wizard | ||
Assign Colors | Defines the assignment method of colors within their series. | 0 1 | By Index (Series Related) By Content (Series Overall) | ||
Filter | You can define a filter condition here. Only data records that fulfill the condition will then be used for the chart. All data will be used if you select "True". | True False Formula | True False Formula wizard | ||
Limit To | You can define a filter condition here. Only data records that fulfill the condition will then be used for the chart. All data will be used if you select "True". | Number Formula | Number of entries 0=No Limit -1=Minimum Percentage Formula wizard | ||
| Summarize Other Entries | Create a segment where the remaining values will be summarized |
| Yes No | |
| Label Others | The text that is used for the 'Others' segment. | Text | Formula wizard | |
Axis label | Defines the text for the axis label. | Formula | Formula wizard | ||
| Rotation | Rotation of the axis label in degrees. | Number | Formula wizard | |
Coordinate label | Defines the text for the coordinate label or the legend. | Formula | Formula wizard | ||
| Rotation | Rotation of the coordinate label in degrees (with long texts). | Number | Formula wizard | |
| Fixed font size | The font size is to be fixed (otherwise it will become smaller if necessary in order to prevent overlapping). | True False Formula | Yes No Formula wizard | |
Legend | Placement of the legend (values differ according to type and axis). |
| None At Axis Top, Left, Right, Bottom | ||
| Equidistant (only if placement is "bottom" or "top") | Describes, if the distance between legend entries is constant (Yes) or minimal (No). | True False | Yes No | |
| Border | Border of the legend. |
| Frame dialog | |
| Percentage for Legend | Percentage of the area of the available space for the legend. 0 means automatic calculation. | Number | Formula wizard | |
