Reader small image

You're reading from  Mastering Data Visualization with Microsoft Visio Professional 2016

Product typeBook
Published inMay 2016
PublisherPackt
ISBN-139781785882661
Edition1st Edition
Right arrow
Authors (2):
David Parker
David Parker
author image
David Parker

David J Parker's background has been in data visualization ever since he struggled to produce lists of hospital equipment from Computer Aided Design models of buildings as a budding architect in the '80s. He moved into building and infrastructure asset management in the late '80s using a Unix system and gradually migrated to Windows-based systems throughout the '90s. He became a European Business partner of Visio Corporation in 1996 and presented the database-linked Visio solutions that he was providing merchant banks in London and New York with at several international conferences. David started bVisual Ltd. in 1998, which provides Visio-based solutions to various industries, and became a Silver-level Microsoft partner. He has been a Microsoft MVP (Visio) for the last 12 years and has helped Microsoft Corp, UK and Western Europe, by providing Visio solutions, training, website content, and presentations. David has had several books on Visio published and has been presenting Visio/SharePoint integration courses for many years for Microsoft Western Europe, from Oslo in the North down to Lisbon in the South. He has presented at SQL and SharePoint Saturday conferences and writes a regular blog for people interested in Microsoft Visio.
Read more about David Parker

View More author details
Right arrow

Breaking down by category


Of course, it would be pretty pointless to just show a single shape on the page, and the Pivot Diagram add-on provides the ability to break down by a selected category from either the Add Category box on the Pivot Diagram window, or from the right-click menu option, Add Category, on a Pivot Node shape, as shown in the next screenshot:

By default, a Pivot Breakdown shape labeled Department (in the screenshot) is added between the initial Pivot Node shape and the new Pivot Node shapes. These Breakdown Shapes can be hidden with the option on the Show\Hide group, but they also have a right-click menu option that can be useful.

The first option in this menu, Collapse, will remove the Breakdown Shape, the child Pivot Connector shapes, and the child Pivot Node shapes.

Sorting Pivot Nodes

The second option, Sort…, on the right-click menu of the Breakdown Shapes, opens the Breakdown Options dialog. This can be used to sort the child nodes by a Shape Data row that is available...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Mastering Data Visualization with Microsoft Visio Professional 2016
Published in: May 2016Publisher: PacktISBN-13: 9781785882661

Authors (2)

author image
David Parker

David J Parker's background has been in data visualization ever since he struggled to produce lists of hospital equipment from Computer Aided Design models of buildings as a budding architect in the '80s. He moved into building and infrastructure asset management in the late '80s using a Unix system and gradually migrated to Windows-based systems throughout the '90s. He became a European Business partner of Visio Corporation in 1996 and presented the database-linked Visio solutions that he was providing merchant banks in London and New York with at several international conferences. David started bVisual Ltd. in 1998, which provides Visio-based solutions to various industries, and became a Silver-level Microsoft partner. He has been a Microsoft MVP (Visio) for the last 12 years and has helped Microsoft Corp, UK and Western Europe, by providing Visio solutions, training, website content, and presentations. David has had several books on Visio published and has been presenting Visio/SharePoint integration courses for many years for Microsoft Western Europe, from Oslo in the North down to Lisbon in the South. He has presented at SQL and SharePoint Saturday conferences and writes a regular blog for people interested in Microsoft Visio.
Read more about David Parker