Chart properties

Setting the properties for a chart can enhance its usability. For example, adding labels and legends can improve the visual analysis of data.

To set chart properties, select the Settings icon above the Chart Canvas.
Table 1: Chart properties

Property

Description

Normal Stacking or 100% Stacking

Applies to charts where each data point is divided into segments, such as stacked column charts and area charts.

Normal Stacking allows you to compare the absolute values of data points and their segments.

With 100% Stacking, percentage values are displayed on the measures axis, allowing you to compare the proportional value of each segment across different data points.

Horizontal or Vertical

Switches the orientation of the chart between horizontal and vertical.

Show Title

Adds a title to the chart. You can edit the title at any time.

Show Legend

Adds a legend that shows a different color for each measure in a chart. To add dimensions to the legend in different colors, select Legend Color in the Chart Builder.

Choose Legend Item Colors…

Sets the colors that appear in the chart.

Show Data Labels

Displays measure values for each dimension in a chart.

Use Measures As a Dimension

Plots two or more measures as a dimension in a chart to show how data is spread over multiple measures on a single axis.

You must add at least two measures to a chart before selecting this option. The measures appear as a new dimension in the Chart Builder.

Set Axis Scale

Defines the limits for values displayed on the Y-Axis, either as a range or automatically to the highest measure value.

This option applies only to charts with measures on the Y-Axis.

Show Gridlines

Displays gridlines on the chart.