Format Area

The Format Area dialog box is used to format the areas of an area chart. It appears when you right-click an area chart and select Format Graph from the shortcut menu.

Format Area dialog

Depth

Specifies the depth properties for areas of the chart.

Use Depth
Specifies whether to make the areas visually three-dimensional.
- Depth
  Specifies the depth of the areas, in inches.
- Direction
  Specifies the angle of the axis along the depth of the areas, in degrees.

Static Data Label

Specifies the properties of the static data labels on the areas.

Show Static Data Label
Specifies whether to show the static data labels on the areas. Only when it is true can the following static data label related properties work.
Style
Specifies the display type for data values in the static data labels.
- Value
  Shows the value for each area node.
- Percent
  Shows the percentage of each area node to the total.
- Value and Percent
  Shows the value and the percentage for each area node.
Position
Specifies the position of the static data labels on the areas.
- Autofit
  If selected, the static data labels will be displayed automatically.
- Top Center
  If selected, the static data labels will be displayed in the top center of the nodes on the areas.
- Top Left
  If selected, the static data labels will be displayed on the top left of the nodes on the areas.
- Top Right
  If selected, the static data labels will be displayed on the top right of the nodes on the areas.
- Bottom Left
  If selected, the static data labels will be displayed on the bottom left of the nodes on the areas.
- Bottom Center
  If selected, the static data labels will be displayed in the bottom center of the nodes on the areas.
- Bottom Right
  If selected, the static data labels will be displayed on the bottom right of the nodes on the areas.
Auto Arrange
Not supported on area charts.
Auto Scale in Number
Specifies whether to automatically scale the static data labels that are of the Number data type when the label values fall into the two ranges:
- When 1000 <= value < 10^15, the following quantity unit symbols of the International System of Units are used to scale the values: K (10^3), M (10^6), G (10^9), and T (10^12).
- When 0 < value < 0.001 or value >= 10^15, scientific notation is used to scale the values.
By default it is set to auto which means that the setting follows that of the chart.

Graph Border

Specifies the properties for the border of the areas.

Show Border
Specifies whether to show the border of the areas. When it is selected, the other border properties will be enabled.
- Line Style
  Specifies the line style to apply to the border.
- Color
  Specifies the color of the border.
- Thickness
  Specifies the thickness of the border.
- Transparency
  Specifies the transparency for color of the border.

Hint

Specifies the properties of the data marker hint.

Show Category and Series
Specifies whether to include the category and series values in the data marker hint.
Auto Scale in Number
Specifies whether to automatically scale the values displayed in the data marker hint that are of the Number data type when the values fall into the two ranges:
- When 1000 <= value < 10^15, the following quantity unit symbols of the International System of Units are used to scale the values: K (10^3), M (10^6), G (10^9), and T (10^12).
- When 0 < value < 0.001 or value >= 10^15, scientific notation is used to scale the values.
By default it is set to auto which means that the setting follows that of the chart.

Applies the changes and closes the dialog box.

Cancel

Does not retain any changes and closes the dialog box.

Help button

Displays the help document about this feature.

Close button

Ignores the setting and closes this dialog box.

Previous Topic Next Topic