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.
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 |