Help Topics

Specifying and Formatting Axis Title, Labels, and Scale


To change the axis titles (the names of the dimensions) and labels (the value for each data point on the axis) and to set their display style, you can launch the Format Axis dialog using one of the following ways:

 

Choosing Font Face, Style, Size and Color

Under the General tab, you can specify the styles and fonts for axis titles and labels. Choose the font face, style, size and color from the list and click Apply.

Note

The style you set on axis titles and labels apply to all axes.

 

Specifying Axis Title, Label Orientation, and Axis Scale

To set the Axis title text and X Axis label orientation:

  1. Click the tab for the axis you want to change.
  2. Modify the axis title.
  3. For X Axis, you can select the desired label orientation.
    For custom orientation, select or enter a value between 0 and 360. The rotation is counter-clockwise.
  4. For Y1 and Y2 Axes, you can specify the following:

    Scale

    The step size or increment for tick marks on the axis.

    Minimum

    The minimum value for the axis.
    De-select the Auto check box first and then specify your minimum value.

    Maximum

    The maximum value for the axis.
    De-select the Auto check box first and then specify your maximum value.

    Use log scale

    Whether to use log scale

    Mask

    The format mask to apply to the axis labels.

    Label Orientation

    The orientation for the data labels. For custom orientation, select or enter a value between 0 and 360. The rotation is counter-clockwise.

    End Margins

    Number of pixels for margins for the chart data area. Depending on the data, this could be top and bottom margins, or left and right margins. The default is 0 pixel.


    Note

    To specify your own custom format, you can select the different Format types from the drop down list and see how the format specification works from the format mask automatically displayed underneath the drop down list. Copy a format that's closest to what you want and edit it. The commonly used symbols are:
    # - stands for an optional digit
    0 - stands for a required digit
    $ - adds a "$" sign
    '%' - adds a "%" sign (enclosed it in single quotes)
    K, M - applies the keywords for thousands and millions (e.g., the format of #,###K will display 2500000 as 2,500K)
    / - divides the axis values by the specified number (e.g., #,###/1000 will display 2500000 as 2,500)
    * - multiplies the axis values by the specified number (e.g., #,###*10 will display 500 as 5,000)


  5. Click Apply to apply the changes.

 

Related Topics: