1. Description

Select Chart. Click Chart Property – Style > Coordinate Axis > Category Axis to configure styles of category axes as shown below:

2. Axis category

Text Coordinate Axis

If the Category Axis applies normal texts for classification without strict limits on ordering, then the Text Coordinate Axis can be directly used by taking the data sequence of chart data source as the classification order;

Time Coordinate Axis

Time Coordinate Axis, a good tool of data analysis: as a kind of chart takes date as its axis value, the Category Axis can arrange these date values in ascending order (data sequence of chart data source may be disordered) so as to be a great reporting tool and business intelligence tool and the Time Coordinate Axis can be selected then. See Date Category Axis document for more details.

Default to use Text Coordinate Axis.

3. Axis title

We can determine display axis titles, which by default it is invisible, the axis title and its Font styles,position as shown below.

4. Axis style

4.1 Type and color

Line style and color of category axis can be configured. For example, in the following column chart, we can set lines of category axis as bold and red lines as shown below:

4.2 Graduation Line

Category defaults to display the graduation line, which is used to divide each category value. Users can set to display the graduation line or not as required, and can also set to display minor graduation line along with major graduation line. In addition, positions of major and minor graduation lines can also be configured, including external, internal and cross display as shown below:

5. Axis in Reverse Order

Axis in reverse order refers that coordinate axis or value axis are displayed in reverse order. See the Axis in Reverse Order Chart for more details.

6. Data format

Values of default tag indicate actual values of chart data source, such as dates like 2011-01-01. To display tags of category axis in the form of Jan. 1, you can use Data Format to configure display styles of tags by the same method as specified in cell Style document.

7. Tag

“Apple juice, milk, soda drink, etc.” displayed below refer to tags of category axis. We can control to display tags or not and configure display methods of tags.

7.1 Display mode

Display by line break

Under the corresponding category axis, reserve half of a character at both sides respectively for centered display of category tags. The tag line, which cannot contain all of these tags, will automatically wrap at a row spacing of 4px. After line wrap, displayed tag contents are centered and its overall height accounts for 28% of the chart area at most. If tags still cannot be displayed entirely subject to the height limit, then apply the thumbnail display … and move the mouse over it to pop up Tooltip Tip.

Note: if Text Direction is customized, displayed tags will be horizontally rotary. In addition, a tag including line breaks will continue to be displayed after line wrap as configured.

Interval display

If we horizontally display the wrapped tags as shown above, it can be imagined that spaces between tags will be rather limited and tags can even be displayed incompletely or overlapped. In such case, you can select the Tag Display Method as Interval Display, which includes Automatic Tag Interval and Customized Tag Interval, to avoid line wrap and truncated tags as shown below:

Automatic tag interval

The principle of automatic tag interval is to display a tag (as shown below) not covered by its previous tag as a tag will not be displayed if it is covered by its previous tag.

Customized tag interval

The automatic tag interval has strong randomness, which entirely depends on length of tags. If users expect to display a tag at an interval of n tags instead, making the chart more professional, in such case, we can customize the tag interval. For example, if we set the interval as 3, then a tag will be displayed every 3 tags as shown below:

Note: the number of tag intervals is given by the formula, so that not only can it be a fixed value, but it can also be set to a dynamic value, such as the value of a parameter.

7.2 Text direction

As shown above, if we configure “Apple juice, milk, soda drink, etc.” to be displayed horizontally in default, only part of tag values can be displayed in order to maintain a beautiful chart. If you want the tag to be fully displayed, while maintaining the beauty of the chart, you can set tags as vertical or rotate them to a certain angle as shown below:

When the rotation angle is 0 °, the upper right corner of the label text aligns the midpoint of the classification / series interval;

Label text is always left-aligned, and the length of each line of text in addition to the last line is same; when the text area is not enough for displaying all the label text, the unshown text can be replaced by suspension points.

Tags can be used to configure not only display modes and text direction, but also tag contents (i.e. font), which will not be repeated again.

Note: tag options in the Chart Attribute Table – Style should be distinguished from those of coordinate axis as the Tag of Style refers to Series tag and the tag of Coordinate Axis refers to coordinate axis tag.