Use this tab of the "Graph Properties dialog" to set properties that control the appearance of the graph, such as the style.
For more information, see:
Components
Format
This list is only available for waterfall graphs. Use this list to define the color of the bars and which bars display for the graph. The options are:
Increase, Decrease and Total
First, Increase, Decrease, and Total
Single Color
Dual Color
Custom — Once you customize the waterfall bar value by selecting a different color, Custom displays in the Format list.
See "What Types of Waterfall Graph Formats Are Available?" for additional information.
Style
This box is not enabled for bubble and radar graphs.
Use this box to select the graph style. The options are:
For bar, line-bar, or pareto graphs: Default, Rectangle, Triangle, Cylinder, Diamond, Gradient or Pattern Fill
For a line or time-series line graph: Default, Standard Line, Stepped Line, or Curved Line
For an area or pie graph: Default, Solid Fill, Gradient Fill, or Pattern Fill
For a scatter graph: Default, Standard Scatter, or Scatter-with-Lines
Style and Conditional Formatting
Displays the "Style and Conditional Formatting dialog," where you specify formatting.
3D
Use this box to specify whether the graph is to be three-dimensional.
Plot Area: Background
Displays the Color Selector dialog, where you select the color for the plot area background.
Gridlines
Use these boxes to specify whether to display the default gridlines or gridlines that you specify.
If you select the Specify option, then, for the major grid and for the minor grid, specify the gridlines that you want and their color using the following boxes:
Horizontal Line — Use this box to display a horizontal gridline.
Vertical Line — Use this box to display a vertical gridline.
Color — Displays the Color Selector dialog, where you select the color for the horizontal and vertical gridlines. This color also is applied to the major and minor tick marks, which you specify on the "Graph Properties dialog: Scale tab."
If you select the Specify option only and do not select any check boxes for the major and minor grid, no gridlines (not even the ones shown by default) are displayed.
Note that, for a pareto graph, enabling the horizontal major or minor gridlines shows only the gridlines corresponding to vertical axis 1.
Legend: Background
Displays the Color Selector dialog, where you select the color for the legend background.
Legend: Transparent
Use this box to specify whether the legend is transparent (that is, has no background color).
Legend: Border
Displays the Color Selector dialog, where you select the color for the border around the legend.
Canvas Colors and Borders: Background
Displays the Color Selector dialog, where you select the color for the canvas background.
Canvas Colors and Borders: Gradient
Use this box to specify whether the canvas background color is to gradually fade from the specified color at the top to white at the bottom.
Canvas Colors and Borders: Border
Displays the Color Selector dialog, where you select the color for the border around the canvas.