Chart Axis

Version

Application Scenario

The chart axis is a setting item in Chart Style, where you canchange the display style and format of the chart axis (X axis and Y axis), as shown in the following figure.

Note:

You can customize multiple X axes or Y axes, as well as the position and value order for each axis in column charts, bar charts, line charts, area charts, and combination charts.

Function Description

The chart axis settings include X axis settings and Y axis settings, as shown in the following figure.

1. X Axis

Seven settings are available for the X axis, including Type, Title, Label, Axis Line Style, Position, Display Strategy, and Format, as shown in the following figure.

2. Y Axis

Seven settings are available for the Y axis, including Title, Label, Value Definition, Axis Line Style, Position, Display Strategy, and Format, as shown in the following figure.

Note:

For most chart types, the X axis settings are the same as the Y axis settings, except the Value Definition setting of the Y axis.

Type

There are three types of the X axis: Category Axis, Time Axis, and Value Axis.

There is only one Y axis type Value Axis.

In addition, there are Simple Value Axis, Polar Angle, Polar Axis, Project Axis, and Time Axis, as shown in the following table:

Title

After you set the axis title, the title text will be displayed at the axis during the front-end display. The axis title is hidden by default, which means no axis title is set.

After you click Display, you can define the axis title. The introduction of the title setting items are as follows:

• Content: You can directly edit the title content in the content editing box, or click the formula button on the right, and enter text on the formula editing page.

• Use HTML to Parse Text Content: The title will be displayed correctly during preview only when the title is HTML text, and the button      is selected to be highlighted. Otherwise, the title will be displayed as a string by default. For more information, see: Custom Chart Title/Label/Prompt.

• Position: You can set Position to left align, center, or right align, which is set to center by default.

• Character: Theme is selected by default. You can customize font style, font size, color, italic, and bold.

• Text Rotation: You can set the rotation angle of the title, from positive 90 degrees to negative 90 degrees.

Label

Axis label is the text displayed in the axis area, and you can customize the style of the axis label text by setting the label items.

Display Mode

There are three display modes. When the axis label text is too long and overlaps, optimization strategies can be used. The logics of the three display modes are as follows:

• Interlaced Display: If a label is obscured by the previous label, the obscured label will not be displayed. This process continues until an      unobscured label is displayed. Therefore, when the label is too long, only a part of the label will be displayed.

• Abbreviated Display: When the axis label exceeds the category interval, the excessive part is represented by an ellipsis.

• Wrapped Display: When the axis label exceeds the category interval, the label is automatically displayed in multiple lines.

Note:

You can set the display mode of the label in column charts, line charts, bar charts, area charts, combination charts, and box plots. Among them, bar charts only allow you to set the Y axis, and other charts only allow you to set the X axis.

Text Rotation & Label Gap

• Text Rotation: You can set the rotation angle of the label, from positive 90 degrees to negative 90 degrees.

• Label Gap: You can select Auto to use the default gap. You can select fixed, andcustomize the gap.

For example, you can set Text Rotation of the X axis label of the column chart to 30, and the fixed gap to 2. The following figure shows the effect.

Note:

The label options in the chart attribute Style need to be distinguished from the label options in the coordinate axis. The labels in the style refer to series labels, while the labels in the coordinate axis refer to coordinate axis labels.

Value Definition

Y axis: The Y axis setting includes Custom Maximum Value, Custom Minimum Value, Custom Main Unit, Custom Minor Unit, and Custom Log Base. For more details, see: Chart with Custom Multiple Axes.

Note:

The bar chart X axis has this function, while the Y axis does not.

Axis Line Style

Axis Line Style includes Type, Color, Main Tick, and Minor Tick.

• Type: You can select the axis line type.

• Color: You can set the color of the axis line.

• Main Tick: You can set whether to enable the main tick.

• Minor Tick: You can set whether to enable the minor tick.

Position

Position settings: The position settings include Axis Label Position and Axis Reverse Order.

• Axis Label Position: You can set the display position of X axis and Y axis labels. The X axis label is displayed at the bottom by default, and the Y axis label is displayed on the left by default. If the value of the axis label position is set to Zero, all value axis labels align with the axis perpendicular to it, and the number of interval scales of each value axis is the same. For more details, see 0 Value Alignment on X Axis in a Column Chart.

• Axis Reverse Order: If you need to display the coordinate axis in the reverse order, you can select On for Axis Reverse Order. For      more details, see Custom Value Order on Axes.

Display Strategy

Display Strategy: You can control the size of the coordinate axis label display area. Size is unlimited by default. When selecting a limit, you can set the maximum proportion below, as shown in the following figure.

Format

You can set the display format of the axis labels, as shown in the following figure.

Note:

1. When the date type data in the program dataset is used as the category of the bar chart, the X axis format setting does not take effect. In this case, you can convert the date type to a string format of date data.

2. When you export the charts (images, Excel, and PDF), only some tags are supported: <b>, <strong>, <i>, <em>, <br/>, <span>.