## Format Area dialog

This dialog appears when you double-click an area of a chart or right-click it and then select Format Area from the shortcut menu. It helps you to format areas in a chart, and consists of the following four tabs:

- General tab
- Fill tab
- Border tab
- Data Label tab

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.

### General tab

#### For 2-D area charts

Specifies the general format of the 2-D area chart. See the tab.

Layout

Specifies the layout for 2-D areas of the chart.

- None 2-D
  If selected, 2-D area will be applied to display the trend of the values over time or categories.
- Stacked 2-D
  If selected, stacked 2-D area will be applied to display the trend of the contribution of each data value over categories.
- 100% Stacked 2-D
  If selected, 100% stacked 2-D area will be applied to display the trend of the percentage each data value contributes over categories.

Depth

Specifies the depth properties for areas of the chart.

- Use Depth
  Specifies whether to make the areas in the chart three-dimensional. You can also use a formula to control the property.
  - Depth
    Specifies the depth of the areas.
  - Direction
    Specifies the direction for depth of the lines.

  Note: If the chart is a combo chart composed by areas and bars/lines, when you set the depth properties for the areas, they will be applied to the bars/lines as well, and vice versa.

High-Low Lines

Specifies whether to show the high-low lines in areas of a chart.

#### For 3-D area charts

Specifies the general format of the 3-D area chart. See the tab.

Layout

Specifies the layout for 3-D areas of the chart.

- None 3-D
  If selected, area with a 3-D visual effect will be applied.
- Stacked 3-D
  If selected, stacked area with a 3-D visual effect will be applied.
- 100% Stacked 3-D
  If selected, 100% stacked area with a 3-D visual effect will be applied.

### Fill tab

Specifies the color, fill effect and transparency for areas of the chart. See the tab.

Color

Specifies the color schema for areas in the same data series.

Transparency

Specifies the transparency of the color schema that is applied to areas in the same data series.

Pattern List

Opens the Pattern List dialog to modify color pattern of areas in the same data series.

Sample

Displays a preview sample of your selection.

### Border tab

Specifies properties for border of the areas. See the tab.

Border Type

Specifies the type of border for the areas.

- none
  The object has no visible border lines (default value).
- raised
  The object has 3D borders that appear as if they are raised off the page.
- recess
  The object has 3D borders that appear as if they are pressed into the page.
- shadow
  The object has two shadowed borders, beneath and to the right of the object.

Color

Specifies the color for border of the areas.

Transparency

Specifies the transparency for color of the border.

Line Style

Specifies the line style to apply to border of the areas.

Thickness

Specifies the weight of the border.

End Caps

Specifies the ending style of the border line.

- butt
  Ends unclosed subpaths and dash segments with no added decoration.
- round
  Ends unclosed subpaths and dash segments with a round decoration that has a radius equal to half of the width of the pen.
- square
  Ends unclosed subpaths and dash segments with a square projection that extends beyond the end of the segment to a distance equal to half of the line width.

Line Joint

Specifies the line joint style for the border line.

- miter
  Joins path segments by extending their outside edges until they meet.
- round
  Joins path segments by rounding off the corner at a radius of half the line width.
- bevel
  Joins path segments by connecting the outer corners of their wide outlines with a straight segment.

Sample

Displays a preview sample of your selection.

Path

Specifies the fill pattern of the border line.

- Outline Path
  Specify the fill pattern of the border line to be outline path.
- Fill Path
  Specify the fill pattern of the border line to be whole path.

Dash

Specifies the dash size of the border line.

- Auto Adjusted Dash
  If selected, the dash size will be adjusted automatically.
- Fixed Dash Size
  If selected, the dash size will just be fixed.

### Data Label tab

Specifies properties for data labels on areas in the chart. See the tab.

Static Data Label

Specifies properties of the static data labels on the areas.

- Show Static Data Label
  Specifies whether or not to show the static data labels.
- Position
  Specifies the position of the data labels on the areas.
  - auto fit
    If selected, the data labels will be displayed automatically.
  - top center
    If selected, the data labels will be displayed in the top center of the nodes on the areas.
  - top left
    If selected, the data labels will be displayed on the top left of the nodes on the areas.
  - top right
    If selected, the data labels will be displayed on the top right of the nodes on the areas.
  - bottom left
    If selected, the data labels will be displayed on the bottom left of the nodes on the areas.
  - bottom center
    If selected, the data labels will be displayed in the bottom center of the nodes on the areas.
  - bottom right
    If selected, the data labels will be displayed on the bottom right of the nodes on the areas.
- Suppress Label when 0
  Specifies whether to display the data label on the chart when its slice value is 0. If the property is set to true, the data label whose slice value is 0 will not be displayed. This option is available to these 2-D chart types: bar, bench, line, area, pie, radar, and surface.

Font

Specifies the font format of text in the data labels.

- Font list
  Lists all the available font faces that can be selected to apply to the text.
- Font Size
  Specifies the font size of the text.
- Font Color
  Specifies the font color of the text.
- Transparency
  Specifies the transparency of the text.
- Rotation
  Specifies the rotation angle of the text around its center, in degrees. The default value is 0.
- Shearing
  Specifies the gradient of the text.

Effects

Specifies the special effects of text in the data labels.

- Style
  Specifies the font style of the text. It can be one of the following: plain, bold, italic, and bold italic.
- Strikethrough
  Specifies the style of the horizontal line with which the text is struck through. It can be one of the following: none, thin line, bold line, and double lines.
- Underline
  Specifies the style of the horizontal line under the text. It can be one of the following: none, single, single lower, bold line, bold lower, double lines, bold double, patterned line, and bold patterned.
- Superscript
  Raises the text above the baseline and changes the text to a smaller font size, if a smaller size is available.
- Embossed
  Makes the text appear to be raised off the page in relief.
- Outlined
  Displays the inner and outer borders of each character.
- Subscript
  Lowers the text below the baseline and changes the text to a smaller font size, if a smaller size is available.
- Engraved
  Makes the text appear to be imprinted or pressed into the page.
- Shadowed
  Adds a shadow beneath and to the right of the text.