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.

Related Content you might be interested in

Current Title:

Small book image
Mastering Data Visualization with Microsoft Visio Professional 2016
John Marshall | David Parker
May, 2016 | 334 pages
No titles found
Table of Contents (17 chapters)
Mastering Data Visualization with Microsoft Visio Professional 2016
Mastering Data Visualization with Microsoft Visio Professional 2016
Credits
Credits
About the Author
About the Author
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Data within Visio Essentials
Data within Visio Essentials
Why use Visio for data diagramming?
The evolution of data in Visio before the Microsoft acquisition
The evolution of data in Microsoft Visio
Other significant current add-ons that use data
Sadly missed add-ons that used data
Summary
2
Understanding How Data Is Stored within Visio
Understanding How Data Is Stored within Visio
A very quick introduction to data in Visio
Understanding the Visio object model
Getting to grips with the ShapeSheet
The Visio file format
Knowing how shapes relate in structured diagrams
Summary
3
Linking Data to Shapes
Linking Data to Shapes
A very quick introduction to importing and linking data
Creating data links to the shapes
Summary
4
Using the Built-In Data Graphics
Using the Built-In Data Graphics
Displaying data with graphics
Understanding the Graphic Item types
Adding a legend
Analyzing the composition of a Data Graphic
Summary
5
Using the Pivot Diagram Add-On
Using the Pivot Diagram Add-On
Choosing a data source
Configuring the default Data Graphics
Breaking down by category
Applying shapes to enhance legibility
Configuring the PivotDiagram options
Laying the nodes out
Overlaying linked data
Summary
6
Creating Custom Master Shapes
Creating Custom Master Shapes
Modifying the ribbon
Preparing shapes for data linking
Making graphics respond to data value changes
Sharing custom Templates, Stencils, and Masters
Summary
7
Creating Custom Data Graphics
Creating Custom Data Graphics
Understanding the structure of graphic item Masters
Modifying graphic items
Summary
8
Validating and Extracting Information
Validating and Extracting Information
Introducing validation rules
Getting information from data diagrams
Summary
9
Automating Structured Diagrams
Automating Structured Diagrams
Structuring diagrams overview
Selecting a Master shape to drop
Dropping and linking shapes to data
Connecting shapes from data
Adding data-linked shapes to containers
Adding data-linked shapes to lists
Adding Callouts to shapes
Summary
10
Sharing Data Diagrams
Sharing Data Diagrams
Thinking about sharing
Viewing Visio documents without Visio
Sharing a Visio document
Exporting a Visio document
Summary
11
Choosing a Deployment Methodology
Choosing a Deployment Methodology
Sharing custom stencils
Sharing custom templates
Sharing custom code
Summary
Index
Index

Analyzing the composition of a Data Graphic

A Data Graphic is actually stored as a special type of Master in a stencil. The Master contains a reference to each of the graphic items within it along with their configurations. The graphic items are also special masters, except for Color By Value, which is stored as a formula in user-defined cells.

The Data Graphic and Graphic Item masters do not appear in the Document Stencil list, but they are visible in the Drawing Explorer window, as can be seen in the following screenshot:

The following ListDataGraphicMasters() VBA macros simply produces a list of the data graphics in the active Document Stencil:

Listing the graphic item masters is a bit more involved because the necessary information is stored in specific user-defined cells of the group shape. So, the ListGraphicItemMasters() VBA macro, which is displayed in the following screenshot, checks the contents of the User.msvCalloutType cell, if it exists:

A Data Graphic Master is a collection of...

Previous Section
End of Section 5
Next Section