March 2007
Intermediate to advanced
704 pages
21h 31m
English
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.
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. ...
Read now
Unlock full access