Alignment
Modifies the alignment of axes or title labels.
Some of the options listed here are not available for all labels. For example, there are different options for 2D and 3D object labels.
Show labels
Specifies whether to show or hide the axis labels.
The AxesTitle On/Off icon on the Formatting bar switches the labeling of all axes on or off.
Rotate text
Defines the text direction of cell contents. Click one of the ABCD buttons to assign the required direction.
ABCD wheel
Clicking anywhere on the wheel defines the variable text orientation. The letters "ABCD" on the button correspond to the new setting.
ABCD button
Assigns vertical text orientation for cell contents.
If you define a vertical x-axis label, the text may be cut off by the line of the x-axis.
Degrees
Allows you to manually enter the orientation angle.
Text flow
Determines the text flow of the data label.
Overlap
Specifies that the text in cells may overlap other cells. This can be especially useful if there is a lack of space. This option is not available with different title directions.
Break
Allows a text break.
The following options are not available for all chart types:
Order
The options on this tab are only available for a 2D chart, under Format - Axis - Y Axis or X Axis. In this area, you can define the alignment of the number labels on the X or Y axis.
Tile
Arranges numbers on the axis side by side.
Stagger odd
Staggers numbers on the axis, even numbers lower than odd numbers.
Stagger even
Stagger numbers on the axes, odd numbers lower than even numbers.
Automatic
Automatically arranges numbers on the axis.
Problems may arise in displaying labels if the size of your chart is too small. You can avoid this by either enlarging the view or decreasing the font size.
Text Direction
Specify the text direction for a paragraph that uses complex text layout (CTL). This feature is only available if complex text layout support is enabled.