Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets

Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets

by Paul McFedries
Released March 2006
Publisher(s): Visual
ISBN: 9780471784890

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 100 key techniques for creating PivotTables and PivotCharts, including:

* Building a basic PivotTable? report

* Pivoting fields to different areas

* Filtering PivotTable data

* Organizing PivotTable data into groups

* Formatting a PivotTable

* Changing the summary calculation

* Creating custom calculations

* Publishing a PivotTable to the Web

* Creating a PivotChart? from a PivotTable

* Building a PivotTable from external data

"I was stuck on an Excel problem for two days. Finally I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."

--Rob L. Meerscheidt (The Woodlands, TX)

* High-resolution screen shots demonstrate each task

* Succinct explanations walk you through step by step

* Two-page lessons break big topics into bite-sized modules

* "Apply It" and "Extra" sidebars highlight useful tips

Table of contents

  1. Copyright
  2. Praise For Visual Books...
  3. Credits
  4. About the Author
  5. Author's Acknowledgments
  6. How to use this book
    1. Who Needs This Book
    2. Book Organization
    3. What You Need to Use This Book
    4. Windows Requirements
    5. The Conventions in This Book
    6. Apply It
    7. Extra
    8. What's on the Web Site
  7. 1. Understanding PivotTables
    1. 1.1. Understanding Data Analysis
      1. 1.1.1. Data
        1. 1.1.1.1. Data Entry
        2. 1.1.1.2. List
        3. 1.1.1.3. Imported Data
      2. 1.1.2. Data Models
        1. 1.1.2.1. Formulas
        2. 1.1.2.2. Functions
      3. 1.1.3. What-If Analysis
        1. 1.1.3.1. Data Tables
        2. 1.1.3.2. Goal Seek
        3. 1.1.3.3. Solver
        4. 1.1.3.4. Scenarios
    2. 1.2. Introducing the PivotTable
      1. 1.2.1. Database Analysis
        1. 1.2.1.1. Lookup and Retrieval
        2. 1.2.1.2. Criteria and List Functions
        3. 1.2.1.3. Multiple Variables
      2. 1.2.2. What PivotTables Do
        1. 1.2.2.1. Grouping
        2. 1.2.2.2. Summarizing
        3. 1.2.2.3. Filtering
      3. 1.2.3. PivotTable Limitations
    3. 1.3. Learn PivotTable Benefits
      1. 1.3.1. PivotTables Save Time
        1. 1.3.1.1. Easy
        2. 1.3.1.2. Fast
        3. 1.3.1.3. Updateable
      2. 1.3.2. PivotTables Are Flexible
        1. 1.3.2.1. Dynamic
        2. 1.3.2.2. Manipulable
        3. 1.3.2.3. Versatile
      3. 1.3.3. PivotTables Suit Your Needs
        1. 1.3.3.1. Customizing
        2. 1.3.3.2. Formatting
    4. 1.4. Survey PivotTable Uses
      1. 1.4.1. Data Structure
        1. 1.4.1.1. Tabular Data
        2. 1.4.1.2. Consistent and Repeated Data
        3. 1.4.1.3. Transactional Data
      2. 1.4.2. Analysis Required
        1. 1.4.2.1. Unique Values
        2. 1.4.2.2. Summary
        3. 1.4.2.3. Relationships
        4. 1.4.2.4. Trends
      3. 1.4.3. Reporting Needs
        1. 1.4.3.1. Flexibility
        2. 1.4.3.2. Frequent Changes
    5. 1.5. Explore PivotTable Features
      1. 1.5.1. PivotTable Glossary
        1. 1.5.1.1. Source Data
        2. 1.5.1.2. External Data
        3. 1.5.1.3. Pivot Cache
        4. 1.5.1.4. Outer Field and Inner Field
        5. 1.5.1.5. Drop Area
        6. 1.5.1.6. Pivot
        7. 1.5.1.7. Labels
        8. 1.5.1.8. Data
        9. 1.5.1.9. Summary Calculation
    6. 1.6. Introducing the PivotChart
      1. 1.6.1. PivotChart Concepts
        1. 1.6.1.1. Chart Categories (X-Axis)
        2. 1.6.1.2. Chart Data Series
        3. 1.6.1.3. Chart Values (Y-Axis)
        4. 1.6.1.4. Filtering
        5. 1.6.1.5. Dynamic PivotCharts
        6. 1.6.1.6. Pros and Cons
  8. 2. Building a PivotTable
    1. 2.1. Prepare Your Worksheet Data
      1. 2.1.1. Organize Your Data
        1. 2.1.1.1. Row-and-Column Format
        2. 2.1.1.2. Unique Column Headings
        3. 2.1.1.3. Incorporate Labels as Columns
      2. 2.1.2. Prepare Your Data
        1. 2.1.2.1. Blank Rows
        2. 2.1.2.2. Consistent Data
        3. 2.1.2.3. Repeated Data
        4. 2.1.2.4. Accurate Data
        5. 2.1.2.5. Automatic Subtotals
        6. 2.1.2.6. Filtered Data
    2. 2.2. Create a List for a PivotTable Report
      1. 2.2.1. Create a List for a PivotTable Report
    3. 2.3. Build a Basic PivotTable from an Excel List
      1. 2.3.1. Build a Basic PivotTable from an Excel List
    4. 2.4. Add Fields Using the PivotTable Wizard
      1. 2.4.1. Add Fields Using the PivotTable Wizard
    5. 2.5. Re-create an Existing PivotTable
      1. 2.5.1. Re-create an Existing PivotTable
  9. 3. Manipulating Your PivotTable
    1. 3.1. Turn the PivotTable Toolbar On and Off
      1. 3.1.1. Turn the PivotTable Toolbar On and Off
        1. 3.1.1.1. TURN OFF THE PIVOTTABLE TOOLBAR
        2. 3.1.1.2. TURN ON THE PIVOTTABLE TOOLBAR
    2. 3.2. Customize the PivotTable Toolbar
      1. 3.2.1. Customize the PivotTable Toolbar
        1. 3.2.1.1. REMOVE A BUTTON FROM THE PIVOTTABLE TOOLBAR
        2. 3.2.1.2. ADD A BUTTON TO THE PIVOTTABLE TOOLBAR
    3. 3.3. Select PivotTable Items
      1. 3.3.1. Select PivotTable Items
        1. 3.3.1.1. SELECT A ROW OR COLUMN FIELD
        2. 3.3.1.2. SELECT THE ENTIRE PIVOTTABLE
        3. 3.3.1.3. SELECT DATA ONLY
        4. 3.3.1.4. SELECT LABELS ONLY
    4. 3.4. Remove a PivotTable Field
      1. 3.4.1. Remove a PivotTable Field
        1. 3.4.1.1. REMOVE A FIELD FROM THE PIVOTTABLE REPORT
        2. 3.4.1.2. REMOVE A FIELD USING THE PIVOTTABLE WIZARD
    5. 3.5. Refresh PivotTable Data
      1. 3.5.1. Refresh PivotTable Data
        1. 3.5.1.1. REFRESH DATA MANUALLY
        2. 3.5.1.2. REFRESH DATA AUTOMATICALLY
    6. 3.6. Display the Details Behind PivotTable Data
      1. 3.6.1. Display the Details Behind PivotTable Data
        1. 3.6.1.1. DELETE THE DETAIL WORKSHEET
    7. 3.7. Create a Chart from PivotTable Data
      1. 3.7.1. Create a Chart from PivotTable Data
        1. 3.7.1.1. CREATE A COPY OF THE PIVOTTABLE DATA
        2. 3.7.1.2. CREATE THE CHART
    8. 3.8. Add Multiple Fields to the Row or Column Area
      1. 3.8.1. Add Multiple Fields to the Row or Column Area
        1. 3.8.1.1. USE THE PIVOTTABLE FIELD LIST
        2. 3.8.1.2. USE THE PIVOTTABLE WIZARD
    9. 3.9. Add Multiple Fields to the Data Area
      1. 3.9.1. Add Multiple Fields to the Data Area
        1. 3.9.1.1. USE THE PIVOTTABLE FIELD LIST
        2. 3.9.1.2. USE THE PIVOTTABLE WIZARD
    10. 3.10. Add Multiple Fields to the Page Area
      1. 3.10.1. Add Multiple Fields to the Page Area
        1. 3.10.1.1. USE THE PIVOTTABLE FIELD LIST
        2. 3.10.1.2. USE THE PIVOTTABLE WIZARD
    11. 3.11. Publish a PivotTable to a Web Page
      1. 3.11.1. Publish a PivotTable to a Web Page
    12. 3.12. Convert a PivotTable to Regular Data
      1. 3.12.1. Convert a PivotTable to Regular Data
    13. 3.13. Print a PivotTable
      1. 3.13.1. Print a PivotTable
    14. 3.14. Delete a PivotTable
      1. 3.14.1. Delete a PivotTable
  10. 4. Changing the PivotTable View
    1. 4.1. Move a Field to a Different Area
      1. 4.1.1. Move a Field to a Different Area
        1. 4.1.1.1. MOVE A FIELD BETWEEN THE ROW AND COLUMN AREAS
    2. 4.2. Display a Different Page
      1. 4.2.1. Display a Different Page
        1. 4.2.1.1. DISPLAY ALL PAGES
    3. 4.3. Change the Order of Fields Within an Area
      1. 4.3.1. Change the Order of Fields Within an Area
        1. 4.3.1.1. CHANGE THE FIELD ORDER IN THE ROW, COLUMN, OR PAGE AREA
        2. 4.3.1.2. CHANGE THE FIELD ORDER IN THE DATA AREA
    4. 4.4. Sort PivotTable Data with AutoSort
      1. 4.4.1. Sort PivotTable Data with AutoSort
    5. 4.5. Move Row and Column Items
      1. 4.5.1. Move Row and Column Items
        1. 4.5.1.1. USE COMMANDS TO MOVE ROW AND COLUMN ITEMS
        2. 4.5.1.2. Click and Drag to Move Row and Column Items
    6. 4.6. Show Only the Top 10 Items
      1. 4.6.1. Show Only the Top 10 Items
    7. 4.7. Hide Items in a Row or Column Field
      1. 4.7.1. Hide Items in a Row or Column Field
    8. 4.8. Show Hidden Items in a Row or Column Field
      1. 4.8.1. Show Hidden Items in a Row or Column Field
    9. 4.9. Show Pages as Worksheets
      1. 4.9.1. Show Pages as Worksheets
    10. 4.10. Group Numeric Values
      1. 4.10.1. Group Numeric Values
    11. 4.11. Group Date and Time Values
      1. 4.11.1. Group Date and Time Values
    12. 4.12. Group Text Values
      1. 4.12.1. Group Text Values
    13. 4.13. Hide Group Details
      1. 4.13.1. Hide Group Details
    14. 4.14. Show Group Details
      1. 4.14.1. Show Group Details
    15. 4.15. Ungroup Values
      1. 4.15.1. Ungroup Values
        1. 4.15.1.1. UNGROUP ALL VALUES
        2. 4.15.1.2. UNGROUP A TEXT GROUPING
    16. 4.16. Change the Page Area Layout
      1. 4.16.1. Change the Page Area Layout
  11. 5. Customizing PivotTable Fields
    1. 5.1. Rename a PivotTable Field
      1. 5.1.1. Rename a PivotTable Field
    2. 5.2. Rename a PivotTable Item
      1. 5.2.1. Rename a PivotTable Item
    3. 5.3. Format a PivotTable Cell
      1. 5.3.1. Format a PivotTable Cell
    4. 5.4. Apply a Numeric Format to PivotTable Data
      1. 5.4.1. Apply a Numeric Format to PivotTable Data
    5. 5.5. Apply a Date Format to PivotTable Data
      1. 5.5.1. Apply a Date Format to PivotTable Data
    6. 5.6. Apply a Conditional Format to PivotTable Data
      1. 5.6.1. Apply a Conditional Format to PivotTable Data
    7. 5.7. Show Items with No Data
      1. 5.7.1. Show Items with No Data
    8. 5.8. Exclude Items from a Page Field
      1. 5.8.1. Exclude Items from a Page Field
  12. 6. Setting PivotTable Options
    1. 6.1. Apply an AutoFormat
      1. 6.1.1. Apply an AutoFormat
    2. 6.2. Preserve PivotTable Formatting
      1. 6.2.1. Preserve PivotTable Formatting
    3. 6.3. Rename the PivotTable
      1. 6.3.1. Rename the PivotTable
    4. 6.4. Turn Off Grand Totals
      1. 6.4.1. Turn Off Grand Totals
    5. 6.5. Merge Item Labels
      1. 6.5.1. Merge Item Labels
    6. 6.6. Specify Characters for Errors and Empty Cells
      1. 6.6.1. Specify Characters for Errors and Empty Cells
    7. 6.7. Protect a PivotTable
      1. 6.7.1. Protect a PivotTable
  13. 7. Performing PivotTable Calculations
    1. 7.1. Change the PivotTable Summary Calculation
      1. 7.1.1. Change the PivotTable Summary Calculation
    2. 7.2. Create a Difference Summary Calculation
      1. 7.2.1. Create a Difference Summary Calculation
    3. 7.3. Create a Percentage Summary Calculation
      1. 7.3.1. Create a Percentage Summary Calculation
    4. 7.4. Create a Running Total Summary Calculation
      1. 7.4.1. Create a Running Total Summary Calculation
    5. 7.5. Create an Index Summary Calculation
      1. 7.5.1. Create an Index Summary Calculation
    6. 7.6. Turn Off Subtotals for a Field
      1. 7.6.1. Turn Off Subtotals for a Field
    7. 7.7. Display Multiple Subtotals for a Field
      1. 7.7.1. Display Multiple Subtotals for a Field
    8. 7.8. Include Hidden Pages in PivotTable Results
      1. 7.8.1. Include Hidden Pages in PivotTable Results
  14. 8. Creating Custom PivotTable Calculations
    1. 8.1. Introducing Custom Calculations
      1. 8.1.1. Formula Basics
        1. 8.1.1.1. Operands
        2. 8.1.1.2. Operators
      2. 8.1.2. Custom Calculation Types
        1. 8.1.2.1. Calculated Field
        2. 8.1.2.2. Calculated Item
    2. 8.2. Understanding Custom Calculation Limitations
      1. 8.2.1. General Limitations
      2. 8.2.2. Calculated Field Limitations
        1. 8.2.2.1. Field References
        2. 8.2.2.2. Field Reference Problems
      3. 8.2.3. Calculated Item Limitations
      4. 8.2.4. Calculated Field Limitations
        1. 8.2.4.1. Field References
        2. 8.2.4.2. Field Reference Problems
    3. 8.3. Insert a Custom Calculated Field
      1. 8.3.1. Insert a Custom Calculated Field
    4. 8.4. Insert a Custom Calculated Item
      1. 8.4.1. Insert a Custom Calculated Item
    5. 8.5. Edit a Custom Calculation
      1. 8.5.1. Edit a Custom Calculation
        1. 8.5.1.1. EDIT A CALCULATED FIELD
        2. 8.5.1.2. EDIT A CALCULATED ITEM
    6. 8.6. Change the Solve Order of Calculated Items
      1. 8.6.1. Change the Solve Order of Calculated Items
    7. 8.7. List Your Custom Calculations
      1. 8.7.1. List Your Custom Calculations
    8. 8.8. Delete a Custom Calculation
      1. 8.8.1. Delete a Custom Calculation
  15. 9. Creating a PivotChart
    1. 9.1. Understanding PivotChart Limitations
      1. 9.1.1. PivotTables Versus PivotCharts
        1. 9.1.1.1. ROW AREA VERSUS CATEGORY AREA
        2. 9.1.1.2. Column Area Versus Series Area
      2. 9.1.2. Formatting Limitations
        1. 9.1.2.1. Chart Types
        2. 9.1.2.2. Chart Formatting
        3. 9.1.2.3. Chart Customizations
    2. 9.2. Create a PivotChart from a PivotTable
      1. 9.2.1. Create a PivotChart from a PivotTable
    3. 9.3. Create a PivotChart from an Excel List
      1. 9.3.1. Create a PivotChart from an Excel List
    4. 9.4. Create a PivotChart Beside a PivotTable
      1. 9.4.1. Create a PivotChart Beside a PivotTable
    5. 9.5. Move a PivotChart to Another Sheet
      1. 9.5.1. Move a PivotChart to Another Sheet
    6. 9.6. Hide or Show PivotChart Field Buttons
      1. 9.6.1. Hide or Show PivotChart Field Buttons
        1. 9.6.1.1. HIDE PIVOTCHART FIELD BUTTONS
        2. 9.6.1.2. SHOW PIVOTCHART FIELD BUTTONS
    7. 9.7. Change the PivotChart Type
      1. 9.7.1. Change the PivotChart Type
    8. 9.8. Change the PivotChart Series Order
      1. 9.8.1. Change the PivotChart Series Order
    9. 9.9. Add PivotChart Titles
      1. 9.9.1. Add PivotChart Titles
    10. 9.10. Move the PivotChart Legend
      1. 9.10.1. Move the PivotChart Legend
    11. 9.11. Display a Data Table with the PivotChart
      1. 9.11.1. Display a Data Table with the PivotChart
    12. 9.12. Print a PivotChart
      1. 9.12.1. Print a PivotChart
    13. 9.13. Delete a PivotChart
      1. 9.13.1. Delete a PivotChart
        1. 9.13.1.1. DELETE A PIVOTCHART SHEET
        2. 9.13.1.2. DELETE AN EMBEDDED PIVOTCHART
  16. 10. Building More Advanced PivotTables
    1. 10.1. Create a PivotTable from Multiple Consolidation Ranges
      1. 10.1.1. Create a PivotTable from Multiple Consolidation Ranges
    2. 10.2. Create a PivotTable from an Existing PivotTable
      1. 10.2.1. Create a PivotTable from an Existing PivotTable
    3. 10.3. Create a PivotTable from External Data
      1. 10.3.1. Create a PivotTable from External Data
    4. 10.4. Set Up a Server-Based Page Field
      1. 10.4.1. Set Up a Server-Based Page Field
    5. 10.5. Set External Data Options
      1. 10.5.1. Set External Data Options
    6. 10.6. Export PivotTable Data from a Web Page to Excel
      1. 10.6.1. Export PivotTable Data from a Web Page to Excel
    7. 10.7. Reduce the Size of PivotTable Workbooks
      1. 10.7.1. Reduce the Size of PivotTable Workbooks
    8. 10.8. Use a PivotTable Value in a Formula
      1. 10.8.1. Use a PivotTable Value in a Formula
  17. 11. Building a PivotTable from an OLAP Cube
    1. 11.1. Understanding OLAP
      1. 11.1.1. Data Warehouse
        1. 11.1.1.1. Fact Table
        2. 11.1.1.2. Measure
        3. 11.1.1.3. Dimension
      2. 11.1.2. OLAP Cube
      3. 11.1.3. OLAP PivotTable Limitations
        1. 11.1.3.1. Calculations
        2. 11.1.3.2. Other Differences
        3. 11.1.3.3. Layout
    2. 11.2. Create an OLAP Cube Data Source
      1. 11.2.1. Create an OLAP Cube Data Source
        1. 11.2.1.1. START THE DATA SOURCE
        2. 11.2.1.2. CONNECT TO AN OLAP SERVER
        3. 11.2.1.3. CONNECT TO A CUBE FILE
        4. 11.2.1.4. COMPLETE THE DATA SOURCE
    3. 11.3. Create a PivotTable from an OLAP Cube
      1. 11.3.1. Create a PivotTable from an OLAP Cube
    4. 11.4. Show and Hide Details for Dimensions and Levels
      1. 11.4.1. Show and Hide Details for Dimensions and Levels
        1. 11.4.1.1. SHOW DETAILS
        2. 11.4.1.2. HIDE DETAILS
    5. 11.5. Hide Levels
      1. 11.5.1. Hide Levels
    6. 11.6. Display Selected Levels and Members
      1. 11.6.1. Display Selected Levels and Members
    7. 11.7. Display Multiple Page Field Items
      1. 11.7.1. Display Multiple Page Field Items
    8. 11.8. Create an Offline OLAP Cube
      1. 11.8.1. Create an Offline OLAP Cube
  18. A. Building Formulas for Pivottables
    1. A.1. Introducing Formulas
      1. A.1.1. Operands
        1. A.1.1.1. Constants
        2. A.1.1.2. Worksheet Functions
        3. A.1.1.3. PivotTable Fields
        4. A.1.1.4. PivotTable Items
          1. A.1.1.4.1. Direct Reference
          2. A.1.1.4.2. Positional Reference
      2. A.1.2. Operators
    2. A.2. Understanding Formula Types
      1. A.2.1. Arithmetic Formulas
      2. A.2.2. Comparison Formulas
      3. A.2.3. Operator Precedence
    3. A.3. Introducing Worksheet Functions
      1. A.3.1. Function Advantages
      2. A.3.2. Function Structure
        1. A.3.2.1. Function Name
        2. A.3.2.2. Arguments
    4. A.4. Understanding Function Types
      1. A.4.1. Mathematical Functions
      2. A.4.2. Statistical Functions
      3. A.4.3. Financial Functions
      4. A.4.4. Logical Functions
    5. A.5. Build a Function
      1. A.5.1. Build a Function
    6. A.6. Build a Formula
      1. A.6.1. Build a Formula
    7. A.7. Work with Custom Numeric and Date Formats
      1. A.7.1. Custom Numeric Formats
      2. A.7.2. Custom Date and Time Formats
      3. A.7.3. Examples
  19. B. Using Microsoft Query with Excel Pivottables
    1. B.1. Understanding Microsoft Query
      1. B.1.1. Data Source
      2. B.1.2. Database Query
        1. B.1.2.1. Select Tables and Fields
        2. B.1.2.2. Filter Records
        3. B.1.2.3. Sort Records
      3. B.1.3. Query Criteria
      4. B.1.4. Microsoft Query
    2. B.2. Define a Data Source
      1. B.2.1. Define a Data Source
    3. B.3. Start Microsoft Query
      1. B.3.1. Start Microsoft Query
    4. B.4. Tour the Microsoft Query Window
    5. B.5. Add a Table to the Query
      1. B.5.1. Add a Table to the Query
    6. B.6. Add Fields to the Query
      1. B.6.1. Add Fields to the Query
    7. B.7. Filter the Records with Query Criteria
      1. B.7.1. Filter the Records with Query Criteria
    8. B.8. Sort the Query Records
      1. B.8.1. Sort the Query Records
    9. B.9. Return the Query Results
      1. B.9.1. Return the Query Results
  20. C. Importing Data for PivotTables
    1. C.1. Understanding External Data
      1. C.1.1. External Data Types
        1. C.1.1.1. Data Source File
        2. C.1.1.2. Access Table
        3. C.1.1.3. Word Table
        4. C.1.1.4. Text File
        5. C.1.1.5. Web Page
        6. C.1.1.6. XML
      2. C.1.2. Access to External Data
        1. C.1.2.1. Location
        2. C.1.2.2. Login
      3. C.1.3. Import Data
        1. C.1.3.1. Import to PivotTable
        2. C.1.3.2. Import to Worksheet
    2. C.2. Import Data from a Data Source
      1. C.2.1. Import Data from a Data Source
    3. C.3. Import Data from an Access Table
      1. C.3.1. Import Data from an Access Table
    4. C.4. Import Data from a Word Table
      1. C.4.1. Import Data from a Word Table
    5. C.5. Import Data from a Text File
      1. C.5.1. Import Data from a Text File
        1. C.5.1.1. START THE TEXT IMPORT WIZARD
        2. C.5.1.2. IMPORT DELIMITED DATA
        3. C.5.1.3. IMPORT FIXED-WIDTH DATA
        4. C.5.1.4. FINISH THE TEXT IMPORT WIZARD
    6. C.6. Import Data from a Web Page
      1. C.6.1. Import Data from a Web Page
    7. C.7. Import Data from an XML File
      1. C.7.1. Import Data from an XML File
    8. C.8. Refresh Imported Data
      1. C.8.1. Refresh Imported Data
        1. C.8.1.1. REFRESH NON-XML DATA
        2. C.8.1.2. REFRESH XML DATA
  21. D. Learning VBA Basics for PivotTables
    1. D.1. Record a Macro
      1. D.1.1. Record a Macro
    2. D.2. Open the Visual Basic Editor
      1. D.2.1. Open the Visual Basic Editor
    3. D.3. Explore the PivotTable Object Model
      1. D.3.1. PivotTable Object
        1. D.3.1.1. PivotTable Properties
        2. D.3.1.2. PivotTable Methods
      2. D.3.2. PivotField Object
        1. D.3.2.1. PivotField Properties
        2. D.3.2.2. PivotField Methods
      3. D.3.3. PivotItem Object
        1. D.3.3.1. PivotItem Properties
        2. D.3.3.2. PivotItem Method
    4. D.4. Add a Macro to a Module
      1. D.4.1. Add a Macro to a Module
    5. D.5. Run a Macro
      1. D.5.1. Run a Macro
        1. D.5.1.1. RUN A MACRO FROM THE VISUAL BASIC EDITOR
        2. D.5.1.2. RUN A MACRO FROM EXCEL
    6. D.6. Set Macro Security
      1. D.6.1. Set Macro Security
        1. D.6.1.1. SET THE MACRO SECURITY LEVEL
        2. D.6.1.2. CREATE A DIGITAL CERTIFICATE FOR YOUR MACROS
        3. D.6.1.3. ASSIGN A DIGITIAL CERTIFICATE
    7. D.7. Assign a Macro to a Toolbar Button
      1. D.7.1. Assign a Macro to a Toolbar Button
    8. D.8. Assign a Macro to a Menu Command
      1. D.8.1. Assign a Macro to a Menu Command
  22. E. Glossary of PivotTable Terms

Product information

  • Title: Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets
  • Author(s): Paul McFedries
  • Release date: March 2006
  • Publisher(s): Visual
  • ISBN: 9780471784890