Pivot Chart Tools - Analyze Tab


PivotChart

microsoft excel docs

Chart Name - (Added in 2010). The name given to this pivot chart. It is used when ordering objects on the worksheet or writing VBA code.
Options - (Added in 2010). Displays the "PivotTable Options" dialog box, Layout & Format tab.


Active Field

microsoft excel docs

The whole group also appears on the Pivot Table Analyze Tab
Active Field - This displays the name of the field that is currently selected. This can be used to rename the active field.
Field Settings - (Added in 2010). Displays the "Field Settings" dialog box.
Drill Down - (Added in 2013). Shows this items children. You can also double click an item to show its children.
Drill Up - (Added in 2013). Show the level above this item.
Expand Field - Expand all items of the active field. (Expand Entire Field in 2010)
Collapse Field - Collapse all items of the active field. (Collapse Entire Field in 2010)


Filter

microsoft excel docs

The whole group also appears on the Pivot Table Analyze Tab
Insert Slicer - (Added in 2010). Displays the "Insert Slicers" dialog box allowing you to quickly filter data.
Insert Timeline - (Added in 2013). Allows you to quickly filter your dates and choose specific time periods.
Filter Connections - (Added in 2010). Manage which filters the pivot chart is connected to.


Data

microsoft excel docs

Refresh - Button with Drop-Down. The button will refresh the latest data from the source connected to the active cell. The drop-down contains the commands: Refresh, Refresh All, Refresh Status, Cancel Refresh, Connection Properties.
Change Data Source - Button with Drop-Down. The button changes the source data for this pivot table. The drop-down contains the commands: Change Data Source, Connection Properties.


Actions

microsoft excel docs

Clear - (Moved in 2013). Drop-Down - Removes fields, formatting and filters. The drop-down contains the commands: Clear All and Clear Filters.
Move Chart - Move this chart to another sheet or tab in the active workbook.


Calculations

microsoft excel docs

The whole group also appears on the Pivot Table Analyze Tab
Fields, Items & Sets - (Added in 2010). Drop-Down. Create and modify calculated fields and items. The drop-down contains the commands: Calculated Field, Calculated Item, Solve Order, List Formulas, Create Set Based on Axis Items, Create Set Based on Legend Items, Manage Sets.
OLAP Tools - (Added in 2013). Drop-Down. Work with a pivot table connected to an OLAP data source. The drop-down contains the commands: Property Fields, Offline OLAP, Convert to Formulas, What If Analysis, MDX Calculated Measure, MDX Calculated Member, Manage Calculations.
Relationships - (Added in 2013). Create or edit relationships between tables to show related data from different tables on the same report.


Show/Hide

microsoft excel docs

Field List - Toggles the display of the Pivot Table Field List Task Pane.
Field Buttons - (Added in 2010). Button with Drop-Down. The button toggles the display of field buttons on your pivot chart. The drop-down contains the commands: Show Report Filter Field Buttons, Show Legend Field Buttons, Show Axis Field Buttons, Show Value Field Buttons, Hide All.
Pivot Chart Filter - (Removed in 2010). Toggles the display of the Pivot Chart Filter Task Pane.


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext