Axes Chart Properties

Control

Description

Axis

Indicates the current axis:

  • X-axis - Sets the Axes tab to display x-axis parameters.

  • Y-axis - Sets the Axes tab to display y-axis parameters.

  • Secondary Y-axis - Set the Axes tab to display secondary y-axis parameters. See also Series Tab, Assign to Secondary Y-axis.

Show Axis

Displays the current axis.

Scale

Auto-calculate

Enables the current axis to be calculated automatically based on data values.

Start at Minimum Value

Indicates whether to start numeric labels with the minimum value.

Minimum

Sets the minimum value on the current axis.

Maximum

Sets the maximum value on the current axis.

Step

Sets the number of increments to scale on the current axis.

Scale

Enables you to indicate the multiple by which to scale the current axis: None, Tens, Hundreds, Thousands, Ten Thousands, Hundred Thousands, Millions, or Billions.

Gridlines

Show Gridlines

Displays gridlines on the current axis.

Style

Represents gridlines using one style: Solid Line, Dash, Dot, and Dash Dot.

Weight

Sets the width of gridlines in pixels (from 1-8).

Color

Displays the Select Color dialog box where you can select a gridline color.

Number Format

Decimal Places:

Enables you to sets the number of decimal places used to represent data values (0-10).

Format:

Enables you to sets the numeric format for data values: Numeric, Currency, Percent.

Currency Symbol:

Inserts currency formatting symbols.

Labels

Stagger

Alternates labels on two lines to accommodate larger labels.

Angle

Enables you to indicates the angle at which labels extend from the current axis: 0-360 degrees.

Font

Displays the Font Properties dialog box to select fonts and their formatting.