O'Reilly logo

Mastering Data Visualization with Microsoft Visio Professional 2016 by David J Parker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting shapes from data

The example Personnel DataRecordset has a Reports To column that is used by Organization Chart Wizard to create a hierarchy by connecting the shapes together. The data that connects two shapes together does not need to be in the same DataRecordset, especially if there are many-to-many relationships.

A lot of the VBA code in this chapter make increasing use of arrays. However, the VBA IsArray() and IsEmpty() functions do not really report an empty array. Therefore, the following function, IsEmptyArray(), will return True or False by forcing an error if necessary:

Connecting shapes from data

Also, much of the code herein needs to get the index of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required