Chart Axes: Regular report, web application

To open the Category Axis (X), Value Axis (Y), and Value Axis (Secondary) group of parameters, select the chart and click the Parameters button on the toolbar, then select the required group.

To open the Value Axis (Secondary) group of parameters, select the chart, click the Parameters button on the toolbar, select the Plot on Secondary Axis checkbox for one or several chart data series in the Data Series group of parameters, then select the group of parameters on the parameters panel.

It is available for value axis (Y), secondary axis, category axis (X) of bubble chart, and value axis(X) of scatter chart.

Select method for setting maximum and minimum axis values in the drop-down list:

Auto. Default value. The value is calculated automatically based on source data.
Fixed. Set maximum or minimum values in the corresponding boxes.

It is available for X and Y axes. It is unavailable for radar charts.

In the Crosses Y Axis/Crosses X Axis drop-down list specify the layout option for the category axis (X) or the value axis (Y):

Auto. Default value. It crosses the Y/X axis at the minimum value.
At the Specified Point. It crosses the Y/X axis at the specified point. Specify point value in the box.
Maximum Value. It crosses with Y/X axis in the maximum value. Value labels are outside the plot area.

It is available for value axis (Y). It unavailable for radar charts, bubble charts and scatter charts.

Select the Position Axis between Tick Marks checkbox to position axis between the specified point and the following one. The checkbox is deselected by default.

The checkbox is available if the the In the Specified Point option is set for the Y axis.

It is unavailable for radar charts.

To position axis categories/values in reverse order, select the Reverse Order of Categories/Values checkbox. If reverse order or categories is set, the Y axis is positioned at the right, and the secondary axis is positioned at the left. If reverse order of values is set, the X axis is positioned at the top. The checkbox is deselected by default.

Set up axis lines/gridlines:

Line Type. Select line type in the drop-down list.

Line Color. Select line color in the drop-down palette. One can select standard and custom colors. The palette contains only standard colors by default.

To create a custom color:

Click the Add Color button. The advanced color palette opens.

Select a color in the advanced color palette, use color picker to select color on a browser page, or set color code in the RGB or HEX format.

After executing the operations the custom color is created and added to the palette.

NOTE. The maximum possible number of custom colors in the a palette is 23.

To delete custom color from the palette, select the Delete item in the selected color's context menu.

Line Width. Set the required line width using the keyboard or the value editor.

It is available for category axis (X). It unavailable for radar charts, bubble charts and scatter charts.

Set axis position option in the drop-down list:

In Categories. Category axis crosses value axis in the middle of the category.
Between Categories. Category axis crosses value axis at the beginning of the category. Default value.

It is unavailable for radar charts.

To show tick marks, select a line in the drop-down list.

It is unavailable for radar charts.

Select line solid fill color in the drop-down palette.

One can select standard and custom colors. The palette contains only standard colors by default.

To create a custom color:

Click the Add Color button. The advanced color palette opens.

Select a color in the advanced color palette, use color picker to select color on a browser page, or set color code in the RGB or HEX format.

After executing the operations the custom color is created and added to the palette.

NOTE. The maximum possible number of custom colors in the a palette is 23.

To delete custom color from the palette, select the Delete item in the selected color's context menu.

It is unavailable for radar charts.

Set the required line width using the keyboard or the value editor.

It is available for category axis (X). It unavailable for radar charts, bubble charts and scatter charts.

Set tick marks position in the drop-down list:

On Categories. Tick marks are positioned in the middle of the category. Default value.
Between Categories. Tick marks are positioned at the beginning of the category.

It is available for value axis (Y), secondary axis, category axis (X) of bubble chart, and value axis(X) of scatter chart.

To set distance between tick marks, select options in the drop-down list:

Auto. Distance between tick marks is calculated automatically.
Fixed. Set the number of distances between tick marks in the box.
Guaranteed Distance. Set distance between tick marks in millimeters in the box.
Other. Select scale plot mode:

Clustering Scaling. The mode is used for non-uniform data, for example, there are values equal to 1 and 1000. The mode enables the user to display data, omitting uninformative scale intervals. The output scale becomes uneven, but the graph becomes more obvious.
In the box select absolute step of scaling expressed in scale units. If the increment of the next series relative to the previous one is greater, the increment on the scale is limited to this step. In this case series are considered in ascending order.
Distributed Scaling. This mode is similar to clustering, but the scaling step in the box is set in percents of difference between two sorted neighbor series.
Logarithmic Scale. Scale values are calculated with the base-10 logarithm depending on the available data.

Select one of the available fonts in the drop-down list. If required, one can load custom fonts.

Set the required font size. Size is set in points, it can be selected in the drop-down list or entered using the keyboard. The range of available values: [8; 72].

Select text color in the drop-down palette.

One can select standard and custom colors. The palette contains only standard colors by default.

To create a custom color:

Click the Add Color button. The advanced color palette opens.

Select a color in the advanced color palette, use color picker to select color on a browser page, or set color code in the RGB or HEX format.

After executing the operations the custom color is created and added to the palette.

NOTE. The maximum possible number of custom colors in the a palette is 23.

To delete custom color from the palette, select the Delete item in the selected color's context menu.

Select font style:

B. Bold.
I. Italic.
U. Underline.

When the button is pressed, the corresponding font style is used. Several styles can be used simultaneously, for example, pressed B and I buttons result in bold italic font style.

Specify label rotation angle using the keyboard or the value editor.

It is available for the X axis. It is unavailable for radar charts, bubble charts, and scatter charts.

When the checkbox is selected, intervals between labels are calculated automatically.

It is available for value axis (Y), secondary axis, category axis (X) of bubble chart, and value axis (X) of scatter chart.

Select format of axis values in the Format drop-down list.

Depending on the selected format, advanced settings of displaying values are available:

When the Number, Currency, Percentage or Exponential value format is selected, the Decimal Places box becomes available, in which determine the number of displayed decimal places using the value editor or the keyboard.
When the Currency value format is selected, the Symbol drop-down list becomes available, in which select the required currency.

It is available for value axis (Y), secondary axis, category axis (X) of bubble chart, and value axis (X) of scatter chart.

If it is required to display large values on the axis, they can be scaled. Therefore, they will occupy less space on the axis. Values are scaled according to the formula: X = A * B, where A is initial value, B - scale coefficient. Select data scaling coefficient in the Scale drop-down list:

No. Default value. B = 1;
Hundreds. B = 0.01;
Thousands. B = 0.001;
Millions. B = 0.000001;
Billions. B = 0.000000001;
Trillions. B = 0.000000000001.

For example, the axis displays the values: 45000, 46000, and so on. After the Thousands scale is applied, the axis displays the following values: 45, 46, and so on.

Select one of the available fonts in the drop-down list. If required, one can load custom fonts.

Set the required font size. Size is set in points, it can be selected in the drop-down list or entered using the keyboard. The range of available values: [8; 72].

Select text color in the drop-down palette.

One can select standard and custom colors. The palette contains only standard colors by default.

To create a custom color:

Click the Add Color button. The advanced color palette opens.

Select a color in the advanced color palette, use color picker to select color on a browser page, or set color code in the RGB or HEX format.

After executing the operations the custom color is created and added to the palette.

NOTE. The maximum possible number of custom colors in the a palette is 23.

To delete custom color from the palette, select the Delete item in the selected color's context menu.

Select font style:

B. Bold.
I. Italic.
U. Underline.

When the button is pressed, the corresponding font style is used. Several styles can be used simultaneously, for example, pressed B and I buttons result in bold italic font style.

Chart Axes

Parameters

Tick Marks

Labels

Caption