dialog.Some options are available directly via the toolbar buttons; all are available via the Chart Properties dialog.
|
Styles |
||
|
Gallery |
|
Choose from the Gallery of styles. The Style you choose determines availability of other Chart options. |
|
Gap width |
|
For bar and Gantt chart styles - the % of the axis used as "white space" to separate groups of bars |
|
Bar style |
|
For Bar, Gantt and Cube charts. |
|
Show point labels |
|
Displays the data value at each point |
|
Effects |
||
|
3D |
|
Displays the chart in 2D (shows greater detail) or 3D |
|
Cluster |
|
|
|
Stacked |
|
placement of date points, areas or bars |
|
Axes style |
|
3D, Math or Flat |
|
Title |
|
Displayed centered at the top of the chart |
|
Colors |
||
|
Palette |
|
The set of colors used for the chart |
|
Background |
|
The general background, outside the axes. |
|
Chart box |
|
The color for the area inside the axes |
Axes options (for X-Axis or Y-Axis)▼
|
Show labels |
Displays labels at each axis tick mark |
|
Angle font |
Angles axis labels (convenient if spacing is tight) |
|
Show gridlines |
Draws grid lines from each major tick mark |
|
Display minor unit |
Draws unlabeled minor tick marks between major ticks |
|
Minor unit |
Units between minor tick marks |
|
Tick mark type |
In, Out, or cross (both) - used for major and minor ticks |
|
Scale |
|
|
Interval |
Automatic or Custom (minimum, maximum) |
|
Scale unit |
Number of units between major ticks |
|
Format |
Formatting for the axis labels |
|
Decimal places |
Decimal places used in the axis labels |
|
Zero Line |
Draws a single grid line from the zero point on the axis |
|
Title |
Displays a title for the axis |
Learn more: View the spreadsheet as a chart
