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

Making graphics respond to data value changes

The following screenshot shows a triangular shape, named DepartmentMarker, added to the group shape of the Person master in the Document Stencil:

Notice that the top group shape is currently named Sheet.5. This is the default name, and it will remain as the NameID property even if the shape is renamed. In fact, 99% of Masters have the top group Shape with an ID of 5. NameID is the ID of the shape preceded by sheet making it Sheet.5.

To make the color of the DepartmentMarker Shape change whenever the value of the Department Shape Data row changes, the following formulas were entered:

FillForegnd=GUARD(TONE(RGB(Sheet.5!Prop.Red,Sheet.5!Prop.Green,Sheet.5!Prop.Blue),50))

FillPattern=GUARD(1)

The RGB(r,g,b) function takes three numbers between 0 and 255 for the red, green, and blue values. These are obtained from the respective Shape Data rows (Prop.Red, Prop.Green, and Prop.Blue) in the parent group Shape, Sheet.5. However, in order to mute the color...

Previous Section
End of Section 4
Next Section