Book Image

Mastering Data Visualization with Microsoft Visio Professional 2016

By : John Marshall, David Parker
Book Image

Mastering Data Visualization with Microsoft Visio Professional 2016

By: John Marshall, David Parker

Overview of this book

Microsoft Visio Professional is a data visualization application that is used by many different market sectors and many different departments to represent information visually, from network infrastructure to organization charts, from process diagrams to office layouts. Starting off with a brief introduction to Visio Professional 2016 and then moving on to data storage, linking data to shapes, and working with SQL Server to create a solid foundation. Then we’ll cover topics such as refreshing data, working with geographical data, working with various graphics, and diagrams, and more. Finally, you’ll find out how to deploy custom stencils, templates, and code.
Table of Contents (17 chapters)
Mastering Data Visualization with Microsoft Visio Professional 2016
Credits
About the Author
www.PacktPub.com
Preface
Index

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...