Analyzing content

The Chart section also provides analysis tools similar to the Pivot section, where the Chart is interactive and can be manipulated during analysis. The Chart section provides the ability to Focus, Hide, and Drill into the non-fact data elements to explore datasets.

Note

Scatter and Bubble charts do not allow the use of any of the features of this section except the Hidden Item feature.

Drill

The non-fact items in the chart can be drilled into similar to drilling into a Pivot. Use one of the following two steps to drill into a Chart:

Right-click method	Chart menu method
Highlight the label of the element(s) in the chart (x-axis or z-axis)	Highlight the element(s) in a row or column label
Right-click and highlight Drill Anywhere	Open the Pivot menu and highlight Drill Anywhere
Select the element to drill into	Select the element to drill into

Drillup

The following steps are used to reverse the Drill behavior and Drillup on chart elements:

Right-click method	Chart...