bVisual

Search Results for: Link Data to Shapes

Published on by

Creating Shape to Page Hyperlinks Automatically using Link Data to Shapes

I demonstrated how to import hyperlinks into Visio shapes in a previous post – see http://blog.bvisual.net/2007/11/15/importing-hyperlinks-into-visio-shapes/, however, one of my readers wanted to know if the same mechanism can be used to create an hyperlink to another page in the same Visio document, rather than to an external web page. Well, it can be done … with a little preparation.

The Link Data to Shapes feature will by default only create external links because it pushes values from designated Shape Data fields into Hyperlink rows. You can designate Shape Data columns by ticking the Data Type / Hyperlink checkbox:

image

[Read more…] about Creating Shape to Page Hyperlinks Automatically using Link Data to Shapes

Published on by

Linking Data to Shapes in Visio after using Data Visualizer

Data Visualizer (DV) in Visio Plan 2 (Data | Create from Data | Create ) is great because it provides a way of automatically creating a diagram from data, but it also prevents some of the other data-linking features in Visio from being used. This is because DV wants to take control of the data in the shapes to provide refreshes from the data source or send updates to the data source. This can be very annoying if you use DV to create the initial layout, then you enhance this, so it looks just perfect, and then you just want to update some of the data without affecting the layout. DV may re-layout your carefully crafted diagram, even if there are no updates to the data that should do that. Also, you may want to integrate data from other sources that were not available or accessible to the table or query used for by Data Visualizer. This is when you may want to use Data | External Data | Custom Import which also provides a much greater number of data source types. In this article, you will learn how you can do this manually, or automate it with the help of a little VBA code (or similar).

In this example, I have used table of personnel that I have used before, but added an extra column, Shape Type, that simply has the value Rectangle, which is simply the name of a simple Master shape that I have added to my macro-enabled stencil, ExDataLinker.vssm.

  • tblOrgData for the structure
  • DV Step 1
  • DV Step 2
  • DV Step 3
  • DV Step 4
  • DV Basic Layout
  • DV Re-layed out with Data Graphics
[Read more…] about Linking Data to Shapes in Visio after using Data Visualizer

Published on by

Linking Data to Visio Shapes in Code

One of the most useful capabilities of Visio Professional and Visio Plan 2 is to link external data to shapes and have them refreshed by changes in the data source. So, many of my solutions involve writing code to make these links, and they are covered with some VBA examples in my book, Mastering Data Visualization with Microsoft Visio Professional 2016, but I mostly write C# code in VSTO add-ins, so I thought it would be useful to demonstrate how easy it is to create data links by dropping a shape, and by adding links to an existing shape. The book, by the way, is still relevant for the current Visio Professional and Visio Plan 2 editions!

[Read more…] about Linking Data to Visio Shapes in Code

Published on by

Dropping and Connecting Linked Data Shapes in Visio

I like linking data to shapes in Visio. It saves time in filling in Shape Data and adding text, or any Data Graphic to them. Basically I am lazy, and I also like to create macros for repetitive tasks, so in this blog I provide two macros to save the drudgery of two tasks I do so often:

  1. Dropping and data linking a number of items from an External Data recordset filtered by values in a column or columns
  2. Connecting shapes together following a parent-child relationship between Shape Data values
[Read more…] about Dropping and Connecting Linked Data Shapes in Visio

Published on by

Jumping between Shapes in Visio

Many Visio diagrams get quite large, and sometimes it is useful to provide the ability to jump to another shape quickly in the same document, either on a different page or on the same one. Although there is an add-on provided in desktop Visio that is used by the Off-Page Reference shape provided in the Basic Flowcharts Shapes stencil (see my other posts), this article is about using the hyperlinks available in both the desktop and browser editions of Visio. Fortunately, Visio desktop has the ability to create hyperlinks to a specific shape by selecting the page and entering the name of the target shape. This creation ability is not available in Visio for the web, but using the desktop created ones is!

  • Insert Field to display shape ID and Name
  • Hyperlink Sub-Address
  • Following a hyperlink
[Read more…] about Jumping between Shapes in Visio

Published on by

Fixing dimensions of 2D shapes

I am often asked what makes Visio unique and makes it stand out from the crowd, especially in today’s online world. Well, I think there are many reasons, but one of them is the ability to create scaled drawings with parametric components of specific dimensions. This was crucial for my adoption of Visio back in 1996 (see Chase Manhattan Bank – bVisual ), and since then I have created hundreds of dimensionally accurate catalogue components for use in scaled drawings for multiple manufacturers. Over the years, I have developed some patterns in ShapeSheet formulas that I re-use consistently. In this article I show the pattern that I use to provide a user with specific width and height dimensions that can be selected in any of three ways:

  1. Manual resize of the shape with the shape handles to only the specified sizes
  2. Selecting a dimension from the Shape Data panel
  3. Selecting a dimension from the right-mouse Actions context menu

All of these options are linked together so that editing the list of specific sizes are easy to maintain.

  • Resize manually
  • Select a Shape Data value
  • Select a context menu Action
[Read more…] about Fixing dimensions of 2D shapes