On the "Value axis" tab, you can make settings for calculating and presenting the value axis of a bar chart or line diagram.
Primary axis/secondary axis: These charts support a second value axis. The second axis is enabled on the "Diagram" tab. Use the drop-down box to switch to the properties for the respective axis.
Property |
Description |
Value |
Description | ||
Coordinate value |
Here you specify the formula for the coordinate value (total turnover, average turnover, number of sales etc.). |
Formula |
Formula wizard | ||
Axis scale |
Type of axis scaling. |
0 1 2 Formula |
None (linear) Logarithmic, base 10 (decimal) Logarithmic, base 2 (binary) Formula wizard | ||
Maximum Value Automatic |
Do you want the value axis to continue until it reaches a certain maximum value or do you want to determine the end value automatically? You can limit the maximum height of the displayed area e.g. to cater for "anomalies�. If your values contain extremely high peaks, you can cap them by setting a maximum value and show the progression of the "small" values more clearly. If you keep the default value "No", the diagram will be adapted so that all values are displayed. |
True False Formula |
Yes No Formula wizard | ||
|
Threshold |
Maximum axis value |
Number |
Formula wizard | |
Minimum Value Automatic |
Do you want the value axis to start at a certain minimum value or do you want to determine the start value automatically? You can limit the minimum height of the displayed area, e.g. to cater for "anomalies�. If you keep the default value "No", the diagram will be adapted so that all values are displayed. |
True False Formula |
Yes No Formula wizard | ||
|
Threshold |
Minimum axis value |
Number |
Formula wizard | |
Width |
Bar/line width in percent |
Number |
Formula wizard | ||
Label on object |
Specifies whether a text is to be output on the objects. |
0 1 Formula |
No Yes Formula wizard | ||
|
Content |
Label text on the object. |
Formula |
Formula wizard | |
Coordinate lines |
Specifies whether coordinate lines are to be drawn on the background. |
True False Formula |
Yes No Formula wizard | ||
Zebra pattern |
Specifies whether the background is to be output in a zebra pattern. |
|
Transparent Pattern/block color Horiz. Gradient Vert. Gradient Horiz. 2-part gradient Vert. 2-part gradient Partly transparent | ||
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 coordinate label in degrees. |
Number |
Formula wizard | |
|
Fixed font size |
The font size is to be fixed (otherwise it will become smaller as necessary in order to prevent overlapping). |
True False Formula |
Yes No Formula wizard | |
Coordinate tick distance |
Calculation of the distance between two coordinate ticks. |
True False Formula |
Automatic Manual Formula wizard | ||
Legends |
Position of the legend for this axis. If you select "At axis", the values will be placed directly on the axis. |
|
None At axis | ||
Number of ticks |
The number of subdivisions separated by tick marks between the main coordinate markings. |
Number |
Formula wizard | ||