Format Value(Y2) Axis dialog

This dialog appears when you double-click the value (Y2) axis of a combo chart, or right-click a combo chart and then select Format Axes > Format Value(Y2) Axis from the shortcut menu. It helps you to format the value (Y2) axis of a combo chart, and consists of the following tabs:

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 this help document.

Axis tab

Specifies the general properties for the axis. See the tab.

Option

Specifies the options for the axis.

Line

Specifies the line style for the axis.

Gap

Specifies the gap properties for the labels on the axis.

Tick Mark tab

The tab consists of two sub tabs: major tick mark tab, and minor tick mark tab.

Major Tick Mark tab

Specifies properties of the major tick marks on the axis. See the tab.

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 tab

Specifies properties of the minor tick marks on the axis. See the tab.

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.

Font tab

Specifies the font format for text in the major tick mark labels on the axis. See the tab.

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 the specified font and any text effects.

Orientation tab

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

Automatic

Specifies whether to adjust the rotation angle of the 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 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 tab

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

Category

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

Format

Displays 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. For more details about the formats, see A detailed chart property reference.

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 field 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.

Related topics: