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