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%

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

Search

Your notes and bookmarks