Creating a PivotDiagram
This is one of my top-ten favorite features in the 2007 Office release. A PivotDiagram is just what it sounds like—a diagram that displays data just like an Excel PivotTable or PivotChart. A PivotDiagram is a hierarchal diagram (similar to the structure of an organization chart) that remains connected to data, so that you can look at the data visually in as many different configurations as your data allows.
Generating a PivotDiagram
Note
This section uses the same sample data that was used for PivotTables in Chapter 16. Find the file Pivot Data.xlsx in the sample files you can install from the Welcome tab of this book’s CD. ...
Get Advanced Microsoft® Office Documents 2007 Edition Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
