Bars/Lines: Value Axis Settings

combit List & Label Designer

combit List & Label

Bars/Lines: Value Axis Settings

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