In this article:

Maximum, Minimum Values and Axis Intervals

Format

Scale

Crosses the Axis

Labels

Caption

Gridlines/Tick Mark Lines/Axis Lines

Chart Axes

Axes are chart components that are used to organize data on a chart. Headers of table rows and columns form a coordinate grid that enables the user to determine each cell's address. The similar function is executed with by the category axis (X) and the value axis (Y) on a chart. Axes are displayed on all charts, except for pie charts.

A secondary axis is an auxiliary value axis, which can display:

One or several data series can be shown in the secondary axis.

A grid is a set of lines perpendicular to the axis. Major gridlines start from each major tick mark and cross the entire chart plot area, minor gridlines start from each minor tick mark.

Major tick marks are labeled perpendicular strokes at the axis line, while minor tick marks are strokes that bear no labels, positioned on the axis line between the major tick marks.

To set up chart axes, use the Category Axis (X), Value Axis (Y) and Value Axis (Secondary) tabs on the parameters panel.

NOTE. To set up radar chart axes, use the Value Axis group of parameters.

Open the Category Axis (X), Value Axis (Y), and Value Axis (Secondary) group of parameters

Set the parameters:

Maximum, Minimum Values and Axis Intervals

The parameter is available for the value axis Y and for the secondary axis.

NOTE. The parameter is also available for the category axis X of scatter chart.

Set minimum and maximum values and axis intervals using the drop-down list:

Format

The parameter is available for the value axis Y and for the secondary axis.

NOTE. The parameter is also available for the 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:

Scale

The parameter is available for the value axis Y and for the secondary axis.

NOTE. The parameter is also available for the 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:

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.

Crosses the Axis

The Crosses Y Axis parameter is available only on the Category Axis (X) group of parameters of the parameters panel. The Crosses X Axis parameter is available only on the Value Axis (Y) group of parameters of the parameters panel.

NOTE. The parameters is not available for radar chart.

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

Labels

To set up table axis tick mark labels, set the following parameters:

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.

NOTE. The parameter is not available for scatter chart.

To reset label settings, click the Delete button.

Caption

To show a caption, enter the text to be displayed in the axis caption area in the corresponding box and determine caption font settings:

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.

NOTE. Setting caption is not available for radar chart.

To reset caption settings, click the Delete button.

Gridlines/Tick Mark Lines/Axis Lines

To set up gridlines/tick mark lines/axis lines, set the parameters:

NOTE. Line setup is not available for radar chart.

To reset line settings, click the Delete button.

See also:

Data Visualization as Charts