About Chart View Properties
Chart properties include basic details such as the type of chart, chart orientation, and background. The properties that you can set for a chart depend on the type of chart.
Chart Property | Applicable Chart Types | Description |
---|---|---|
Type | All |
Type of chart See Types of Chart Views. |
Background | Area, Bar, Column, Combination, Doughnut, Line, Pie, Tile |
Background color used in chart This color applies to the entire chart area, from border to border. You can choose not to use a background color, in which case a white background is used for the chart. If you specify a background color, an optional gradient also can be specified. |
Label Position | Area, Bar, Column, Combination, Line |
Location of the data labels in relation to the elements The options available depend on the type of chart. For example, bar charts have the following label options: No Label, Center, Inside Edge, or Outside Edge. |
Bar Label Position | Combination | Location of the data labels in the bar chart |
Grid Lines | Area, Bar, Column, Combination, Line | Grid lines used to divide the chart area |
Orientation | Area, Bar, Column | Orientation of the chart - Vertical or Horizontal |
Missing Values as Zero | Area, Combination, Line, Tile |
Displays a zero (instead of a blank) when the data for a particular element is missing When you select this option, all missing values are displayed as zero. This includes missing data values and values that are missing because of an applied filter. |
Dual-Y Axis | Area, Bar, Column, Combination, Line |
Appears on the opposite side of the chart from the primary Y-axis The scale of the secondary Y-axis reflects the values for the associated data series. While the secondary Y-axis can be used with any line and bar chart type, it is more commonly used with the combination chart type, which helps to distinguish the data series that are plotted on the secondary Y-axis. For example, select Bar for the primary Y- axis and Line for the secondary Y-axis. When the data values in a chart vary widely from data series to data series, or when you have mixed types of data (for example, currency and percentages), you can plot one or more data series on a secondary (vertical) Y axis. You can also plot the secondary Y-axis as a split dual chart, where the secondary Y-axis appears with its data series below the original chart. In this case you can use any bar or line chart type. |
Line Weight | Combination, Line |
Width of the line in the chart The default is 5 pixels. |
Bar Label Position | Combination | Position of the label for the data set displayed as a bar chart |
Display as Percentage | Doughnut, Pie | Values for each data set displayed in terms of percentages (instead of as a numerical value) |
3D chart | Pie, Tile | 3-dimensional chart format |