Bars/Lines: Category and Series Axes

combit List & Label Designer

combit List & Label

Bars/Lines: Category and Series Axes

If you have decided in favor of a three-axis diagram, you have both of these axes at your disposal (x axis and x axis). With two-axis charts (e.g. a simple bar chart), you only need the category axis (x axis).

Property

Description

Value

Description

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 alphabetic).

True

False

Formula

Yes

No

Formula wizard

Number of sample records

The Designer does not yet have the "real" data that appears in your chart when it is printed. So that you can still get a picture in the Designer preview of how your chart will look, you can use this option to specify the number of sample records that are to be displayed in the Designer.

Number

Formula wizard

Filter

You can define a filter condition here. Only data records that fulfill the condition will then be used for the diagram. All data will be used if you select "True".

True

False

Formula

True

False

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

Position of the legend.

When you select "At axis", the values are placed directly on the axis. Otherwise the label is placed on the right, left, upper or lower side of the chart.

 

None

At axis

Top

Left

Right

Bottom

Use series to determine the values

 

For the series axis (y-axis) in a three-axis diagram, you can also specify the values by means of rows instead of formulas.

This means that you define the different rows (e.g. measured value/target value/actual value) with a single data record and can show them parallel e.g. in a line diagram.

Select the "Use rows as data source" entry from the drop-down list above the properties. This option changes the properties of the series axis and you also have the "Row definition" property. You define the individual rows by opening the "Row Definitions" dialog. You can define the properties differently for each row and move the rows with the arrow button.