Set chart options (Charts)
To set Chart options, do one of the following:
 Click Chart options and select an option.- Select View menu> Chart options.
|
You can use Chart options to perform any of the following tasks:
Set chart display settings
- Choose a chart type
- Show the slicer area in one line
- Show or hide data labels
- Enable scale break charts
See Chart display settings dialog.
Rearrange the dimensions of a report
- Rearrange dimensions among the rows, columns, and slicer dimension area, without using drag and drop.
- Define dimension nesting.
See Rearrange report dialog.
Calculate values
- Apply a calculation to data values.
- You can apply any of Totals, Percentages, Average, Median, Minimum, Maximum, Variance, and Standard deviation.
See Calculate values dialog.
Scale values
- Apply a scaling factor to data values. (For example, scaling by 10 to the power of 3 multiples values by 1000.)
See Scale values dialog.
Suppress values
- Hide values which are empty, are zero, or fall within a defined range.
See Suppress values dialog.