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

Getting to grips with the ShapeSheet

Every document, page, and shape has a ShapeSheet that contains a number of sections, rows, and cells. Cells contain formulas that produce a resultant value.

The document ShapeSheet is known as the DocumentSheet in the object model, but it can be referenced as TheDoc in a cell formula. Similarly, the page ShapeSheet is known as PageSheet in the object model, but it is referred to as ThePage in cell formulas.

There are a lot of mandatory sections in the ShapeSheet, and some of them do not even have their own enumerator in visSectionIndices. Instead, they come under visSectionIndices.visSectionObject. In fact, there are 38 shown on the View Sections dialog, but with only 24 section constants:

It is more efficient to reference a cell by its SRC (Section, Row, Cell) values than by its name. However, there are times when using the name is unavoidable.

If the ShapeSheet is open in the UI, then you can easily find the name of a cell by clicking in the cell, placing...

Previous Section
End of Section 4
Next Section