BackPrevious Page Next PageNext

Format Category (X) Axis

This dialog appears when you double-click the category (X) axis of a chart in a report, or right-click it and then select Format Axes > Format Category (X) Axis from the shortcut menu. It helps you to format the category (X) axis of a chart.

The dialog contains the following tabs: Axis, Tick Mark, Font, Orientation, Format, Range and Behaviors (some tabs are available to specific chart types only).

OK

Applies the changes and closes the dialog.

Cancel

Does not retain any changes and closes the dialog.

Apply

Applies all changes and leaves the dialog open.

Help

Displays the help document about this feature.

Axis

Specifies the general properties for the axis.

Format Category (X) Axis dialog - Axis

Option

Specifies the options for the axis.

Line

Specifies the line style for the axis.

Label

Specifies the label properties for the labels on the axis.

Tick Mark

The tab consists of three sub tabs: Major Tick Mark, Minor Tick Mark, and Scale.

Major Tick Mark

Specifies properties of the major tick marks on the axis.

Format Category (X) Axis dialog - Tick Mark - Major Tick Mark

Type

Specifies the type of the major tick marks on the axis.

Line

Specifies the line properties of the major tick marks on the axis.

Option

Specifies the other properties of the major tick mark labels on the axis.

Minor Tick Mark

Specifies properties of the minor tick marks on the axis.

Format Category (X) Axis dialog - Tick Mark - Minor Tick Mark

Type

Specifies the type of the minor tick marks on the axis.

Line

Specifies the line properties of the minor tick marks on the axis.

Option

Specifies the other properties of the minor tick marks on the axis.

Scale

Customizes the way in which to label the major and minor tick marks on the axis with constant interval. This sub tab is activated only when the field on the category axis is one of the following types: Number, Date, DateTime, and Time (for a bubble chart only when the category field is one of the above types and the Bubble X Axis uses the category field). The sub tab is not available to scatter charts.

Format Category (X) Axis dialog - Tick Mark - Scale

Use Constant Interval

Specifies whether to use a constant interval to label the tick marks. If checked, the values of the tick marks will be increased continually on the axis based on the following properties instead of just using the data values, and the customized major tick mark labels in the Axis tab are ignored.

Minimum

Specifies the minimum value which will be used to label the tick marks.

Maximum

Specifies the maximum value which will be used to label the tick marks.

Major Unit

Specifies the unit between two adjacent major tick marks.

Minor Unit

Specifies the unit between two adjacent minor tick marks.

Font

The tab consists of two sub tabs: Major Label and Minor Label.

Major Label

Specifies the font format of the major tick mark labels on the axis.

Format Category (X) Axis dialog - Font - Major Label

Font

Specifies the font format of text in the major tick mark labels.

Effects

Specifies the special effects of text in the major tick mark labels.

Sample

Displays a sample of the specified font and any text effects.

Minor Label

Specifies the font format of the minor tick mark labels on the axis.

Format Category (X) Axis dialog - Font - Minor Label

Correlate with Major Label

If checked, the font format of the minor tick mark labels will correlate with that of the major tick mark labels automatically. Only when it is unchecked can the font properties of the minor tick mark labels take effect.

Font

Specifies the font format of text in the minor tick mark labels.

Effects

Specifies the special effects of text in the minor tick mark labels.

Sample

Displays a sample of the specified font and any text effects.

Orientation

The tab consists of two sub tabs: Major Label and Minor Label.

Major Label

Specifies the rotation angle of the major tick mark labels on the axis.

Format Category (X) Axis dialog - Orientation - Major Label

Automatic

Specifies to adjust the rotation angle of the major tick mark label text on the axis automatically according to the length of the label text, in degrees.

When this option is checked by default:

Angle

Specifies to customize the rotation angle of the major tick mark label text on the axis. When you change the rotation angle in the text box, the red line in the spin box will change correspondingly, and vice versa.

Minor Label

Specifies the rotation angle of the minor tick mark labels on the axis.

Format Category (X) Axis dialog - Orientation - Minor Label

Correlate with Major Label

If checked, the orientation setting of the minor tick mark labels will correlate with that of the major tick mark labels automatically. Only when it is unchecked can the orientation properties of the minor tick mark labels take effect.

Automatic

Specifies to adjust the rotation angle of the minor tick mark label text on the axis automatically according to the length of the label text, in degrees.

When this option is checked by default:

Angle

Specifies to customize the rotation angle of the minor tick mark label text on the axis. When you change the rotation angle in the text box, the red line in the spin box will change correspondingly, and vice versa.

Format

The tab consists of two sub tabs: Major Label and Minor Label.

Major Label

Specifies the data format of the major tick mark labels on the axis.

Format Category (X) Axis dialog - Format - Major Label

Category

Lists the category types. Select one to customize its format.

Format

Lists all the formats of the selected category. Select the required one and click Add to add it as the format of the specified category. You can add only one format for each category.

Properties

Displays the properties of the format you select. If the formats listed in the Format box cannot meet your requirement, define the format in the text box and then click Add to add it as the format of the specified category.

Sample

Displays the selected format effects.

Stack

Lists all the formats you select from different categories.

Add

Adds a format to the Stack list box.

Remove

Removes a format from the Stack list box.

Apply

Applies the specified format in the Stack list box to the major tick mark labels.

Truncate

Specifies whether to truncate the label text when the text is more than 10 characters.

Minor Label

Specifies the data format of the minor tick mark labels on the axis.

Format Category (X) Axis dialog -Format - Minor Label

Correlate with Major Label

If checked, the data format of the minor tick mark labels will correlate with that of the major tick mark labels automatically. Only when it is unchecked can the format properties of the minor tick mark labels take effect.

Category

Lists the category types. Select one to customize its format.

Format

Lists all the formats of the selected category. Select the required one and click Add to add it as the format of the specified category. You can add only one format for each category.

Properties

Displays the properties of the format you select. If the formats listed in the Format box cannot meet your requirement, define the format in the text box and then click Add to add it as the format of the specified category.

Sample

Displays the selected format effects.

Stack

Lists all the formats you select from different categories.

Add

Adds a format to the Stack list box.

Remove

Removes a format from the Stack list box.

Apply

Applies the specified format in the Stack list box to the minor tick mark labels.

Range

The tab is available only when the chart is of the Bar, Bench, Line, or Area type. It helps you to divide the category values into different range groups and edit data labels for them, and consists of two sub tabs: Properties and Data Label.

Properties

Specifies the properties of the range groups.

Format Category (X) Axis dialog - Range - Properties

Enable Range

Specifies whether to enable the range function.

Gridline

Specifies the style for the range separating lines.

Fill

Specifies the fill effects for each range group.

Data Label

Specifies the properties of the data labels in the range groups.

Format Category (X) Axis dialog - Range - Data Label

Show Data Labels

Specifies whether to show data labels for the range groups. Available only when the option Enable Range in the Properties tab is checked and range groups are defined.

Data Label Type

Specifies the display type for values in the data labels of each range group. It can be value, percent, value and percent.

Percent within Group

Specifies whether to calculate the percent value within each range group or across all range groups. Available only when percent or value and percent is select from the Data Label Type drop-down list.

Alignment

Specifies the alignment style for the data labels in each range group.

Size

Specifies the size of the data label area on the range groups.

Fill

Specifies the fill effect for the data label area.

Border

Specifies the properties of the border line for the data label area.

Margin

Specifies the distance between the edges and the borders.

Padding

Specifies the distance between the data labels and the borders.

Behaviors

Specifies some web behaviors to the axis. This tab is only available to charts in library components.

 Format Category (X) Axis dialog - Behaviors

Add button

Adds a new web behavior line.

Remove button

Removes the selected web behavior.

Move Up button

Moves the selected web behavior up a step.

Move Down button

Moves the selected web behavior down a step.

Events

Specifies the trigger event.

Actions
Specifies the action you want the event to trigger.

BackPrevious Page Next PageNext