Category and Series Axes

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 chart)

For the series axis (y-axis) in a three-axis chart, 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 chart.

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.

Calculation Type

Allows to display e.g. a moving average.

0

1

2

3

4

5

6

7

Normal

Cumulative Sum

Cumulative Average

Simple Moving Average

Symmetrical Moving Average

Difference to Previous Value

Average

Line Of Best Fit

Presentation

Visual presentation.

1

2

5

6

7

8

Formula

Cylinder

Bar

Line

Symbols

Line+Symbols

Octaeder

Formula wizard

Line Type

0

1

2

3

Formula

Automatic

Solid

Dots

Lines

Formula wizard

Symbol

-1

0

1

2

3

4

5

6

7

8

9

Formula

Automatic

Circle

Square

Rhombus

Star

Triangle 1 (top)

Triange 2 (bottom)

Triangle 3 (right)

Triangle 4 (left)

Hexagon

Pentagon

Formula wizard

Number of Records for Design

Sets the number of records for the preview.

Number

Formula wizard

Axis scale

Type of axis scaling.

0

1

2

Formula

None (linear)

Logarithmic, base 10 (decimal)

Logarithmic, base 2 (binary)

Formula wizard

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

Signal Ranges

The properties of the signal ranges. You can signalize an optimum range. You define the Appearance (Area, Axis Marker), Background, Start value and End value in a dialog.

True

False

Show

Hide

Dialog

Position

The "From" and "To" values describe the two offsets of the axis markers relative to their axis.

Value

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.

If '0' is selected, the fixed colors are ignored. Then a color with an exactly matching group is searched, e.g. 1=1, this has priority. If no group is found, all color entries with group '0' (universal group) are checked. If no group is found, the default is used.

Number

Formula wizard