## Format Bar dialog

This dialog appears when you double-click a bar of a chart or right-click it and then select Format Bar from the shortcut menu. It helps you to format the bars of a 2-D or a 3-D bar 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 bar/bench charts

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

Size

Specifies the size of the bars in the chart.

- Bars Width
  Specifies the bar width as a percentage of the unit width.
- Bars Gap
  Specifies the distance between two bars as a percentage of the bar width.

Layout

Specifies the layout of the chart.

- Clustered - 2-D
  Displays and compares data values across categories.
- Stacked - 2-D
  Displays and compares the contribution of each data value to a total across categories.
- 100% Stacked - 2-D
  Displays and compares the percentage that each data value contributes to a total across categories.

Depth

Specifies the depth properties for bars of the chart.

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

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

Vary Colors by value

Specifies whether or not colors will be varied with values.

#### For 3-D bar charts

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

Size

Specifies the size of bars in the chart.

- Bars Width
  Specifies the bar width as a percentage of the unit width.

Layout

Specifies the layout of the chart.

- Clustered Bar 3-D
  Specifies to apply clustered bar with a 3-D visual effect to the chart.
- Stacked Bar 3-D
  Specifies to apply stacked bar with a 3-D visual effect to the chart.
- 100% Stacked Bar 3-D
  Specifies to apply 100% stacked bar with a 3-D visual effect to the chart.
- Array 3-D
  Specifies to apply array bar with a 3-D visual effect to the chart.

Vary Colors by value

Specifies whether or not colors will be varied with values.

### Fill tab

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

Color

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

Transparency

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

Pattern List

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

Sample

Displays a preview sample of your selection.

### Border tab

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

Border Type

Specifies the type of border for the bars.

- 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 bars.

Transparency

Specifies the transparency for color of the border.

Line Style

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

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
  Specifies the fill pattern of the border line to be outline path.
- Fill Path
  Specifies 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 the properties for the data labels displayed on bars of the chart. See the tab.

Static Data Label

Specifies properties of the static data labels on the bars.

- Show Static Data Label
  Specifies whether or not to show the static data labels.
- Position
  Specifies the position of the data labels on the bars.
  - 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 bars.
  - top left
    If selected, the data labels will be displayed on the top left of the nodes on the bars.
  - top right
    If selected, the data labels will be displayed on the top right of the nodes on the bars.
  - bottom left
    If selected, the data labels will be displayed on the bottom left of the nodes on the bars.
  - bottom center
    If selected, the data labels will be displayed in the bottom center of the nodes on the bars.
  - bottom right
    If selected, the data labels will be displayed on the bottom right of the nodes on the bars.
- 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.