Category and Series Axes

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

Minimum share (only rel. stacked charts)

Especially if you have a lot of values that have small shares, it's sometimes a good idea to group them together under "others". You can define threshold values here which specify when individual segments are to be grouped together in one segment.

Number

Formula wizard

Sort coordinates

Specifies whether the coordinates are to be sorted (alphanumeric or alphabetic).

0

1

2

3
 
 
 
 

4
 
 
 
 

5

Ascending

Descending

Unsorted

Result (Coordinate Value of value axis) ascending

Result (Coordinate Value of value axis) descending

Formula wizard

Use series to determine the values
(only series axis in a three-axis diagram)

For the series axis (y-axis) in a three-axis diagram, 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 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 "Series Definition" property. 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 to display e.g. a moving average or the aggregation of data.

Number of Records for Design

Sets the number of records for the preview.

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

Limit To

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".

Number
 

Formula

Number of entries

0=No Limit

-1=Minimum Percentage

Formula wizard

Summarize Other Entries

Create a row or column where the remaining values will be summarized

Yes

No

Label Others

The text that is used for the 'Others' column (or row).

Text

Formula wizard

Round Start and end values

Sets axis start values and axis end values to round interval limits in cases where the exploited data range is not too small (at least 80% of the entire value of the axis).

True

False

Formula

Yes

No

Formula wizard

Coordinate Lines

Sets whether coordinate lines should be drawn in the background.

True

False

Formula

Yes

No

Formula wizard

Coordinate label "Others"

Coordinate label text for the "Others" segment.

Formula

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

Marker Color

Color of the coordinate marker lines (tickmarks)

Color

Formula wizard

Number of ticks

The number of sub-ticks between two major coordinate ticks.

Number

Formula wizard

Group for fixed colors

Defines the group within the fixed colors.

Number

Formula wizard