Sign In Start Free Trial

Mastering Data Visualization with Microsoft Visio Professional 2016

By : John Marshall

4.2 (6)

Mastering Data Visualization with Microsoft Visio Professional 2016

4.2 (6)

By: John Marshall

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.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Data within Visio Essentials

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

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

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

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

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

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

7. Creating Custom Data Graphics

Understanding the structure of graphic item Masters

Modifying graphic items

Summary

8. Validating and Extracting Information

8. Validating and Extracting Information

Introducing validation rules

Getting information from data diagrams

Summary

9. Automating Structured Diagrams

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

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

11. Choosing a Deployment Methodology

Sharing custom stencils

Sharing custom templates

Sharing custom code

Summary

Index

Index

Customer Reviews

4.2 (6)

5 star

66.7%

4 star

16.7%

3 star

0

2 star

0

1 star

16.7%

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:

Getting to grips with the ShapeSheet

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

Search

Your notes and bookmarks