8.4. Visio 2007 PivotDiagram

It is not widely known that Visio can produce a Pivot diagram of multidimensional data. Rather, it is normally Excel that we use for such a task, where the resulting PivotTables provide an amazing ability to slice and dice the data with automatic cross-tab subtotaling. The subject of Excel PivotTables is handled in depth in Chapter 2 of this book.

For the purpose of demonstration, we'll proceed with a simple PivotDiagram to show how we're able to arrange the hierarchical display of data using Visio's unique shapes drag-and-drop design interface. Figure 8-16 shows how we start this process.

  1. Click the Getting Started choice in the Template Categories list pane.

  2. Choose the PivotDiagram template.

In Figure 8-16 we're ...

Get Microsoft ® Office 2007 Business Intelligence 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.