Selecting Nodes in Visio PivotDiagrams

Microsoft Visio 2007 introduced PivotDiagrams to Visio Professional, and continues unchanged in Visio 2010 (see http://office.microsoft.com/en-us/visio-help/create-a-pivotdiagram-HA010357089.aspx ). These diagrams are a great way to analyse and visualize data by allowing you to breakdown data in a similar manner to PivotTables and PivotCharts in Excel. Any one who has both Microsoft Project and Visio installed will have seen that all of the extra diagram reports are in fact Visio PivotDiagrams. However, I have always found that selecting the nodes you want is difficult. In this article I will explain the problem and provide a solution … a new free add-in called PdSelect.

Update : Added new features 20 Jul 2012

In the following example PivotDiagram, I used the built-in OrgData Excel workbook as the data source. This example workbook is normally used to demonstrate the OrgChart Wizard (see http://office.microsoft.com/en-us/visio-help/demo-automate-your-org-charts-with-visio-HA001092948.aspx and https://blog.bvisual.net/2009/02/24/creating-an-org-chart-without-the-org-chart-wizard/), but I have used it to provide an alternative breakdown by Department / Reports_To / Name.

image

Read the rest of this entry »

davecra.wordpress.com/

Microsoft Office Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...