Visio

Published on November 10, 2020 by David Parker

Bi-directional Labels on Off-Page Grid References

I have previously written about using off-page references and labelled page grids in Visio, see A Page Grid with Labels and Page Grids and Off Page References, however a reader pointed out that the label on the Off-Page Reference shape is duplicated on both ends. This is not always ideal, however it is all I could do using just ShapeSheet formulas alone. So, in this article, I show how a VBA macro can enhance the reciprocal labels on the twin Off-Page Reference shapes, and they automatically update if either end is moved between grids. This is especially useful in electrical wiring diagrams, but the principal can be adapted for other purposes.

Follow Link to Second Page-C7
Follow to Third Page-D1
Follow Link to First Page-A4
Follow Link to First Page-C3

[Read more…]

Published on October 15, 2020 by David Parker

Visio Data Visualizer Tips

The Microsoft Visio product team have released a great video introduction to the Visio Data Visualizer, but even that does not reveal all of its power. So, here are some tips about using the Microsoft Visio Data Visualizer add-in in Excel. Firstly, the add-in currently offers three different types of diagram, and each have a number of alternative layout arrangements.

Basic Flowchart – 4 layouts
Cross-Functional Flowchart – 5 layouts
Organization Chart – 5 layouts

Although these are the proposed diagram types, there is no reason why other types of data, such as network devices, cannot be used with any of them.

Sample Org Chart with Visio Data Visualizer in Excel

[Read more…]

Published on September 23, 2020 by David Parker

Visio is NOT Vizio!

Update 1 : Microsoft read this post and immediately corrected the spelling so the following now works : https://adoption.microsoft.com/virtual-hub/search/?_sft_vh_product=microsoft-visio 🙂

Update 2 : Mr VisGuy! “spelt” is the same as “spelled” outside USA!

Aarghh! What kind of message is sent out if a company does not know how to spell the name of their own product? There is a make of TV in the States called Vizio, which is not the name of my favourite data-diagramming application, Visio. It may be pronounced the same, but believe me it is totally different. So, it is extremely disappointing that Microsoft have allowed their own product to be spelt incorrectly in the Virtual Hub in the Microsoft Ignite 2020 website.

[Read more…]

Published on September 22, 2020 by David Parker

Visio now and beyond at Microsoft Ignite 2020

I have presented at the last four Microsoft Ignite conferences and was part way through the world-wide tour when this pandemic began. I was looking forward to visiting New Orleans for this years shindig, but, alas, we are now in a new world where in-person events are a fond memory. Fortunately, Microsoft have the tools to create an engaging online experience, and today I was able to see Mukul and Saurabh bring us all up to speed on on what has been delivered since last year, and what to expect in the next (see Visio – now and beyond ).

[Read more…]

Published on September 3, 2020 by David Parker

Advanced Installer now Supports Visio VSTO Add-Ins

Advanced Installer now supports creating VSTO Visio Add-Ins installation projects using the Office Add-Ins wizard! This is great news for those of us who are still having to create VSTO Add-Ins, especially since Visual Studio does not include Setup & Deployment projects (again).

[Read more…]

Published on September 3, 2020 by David Parker

Maximum Size of a Visio Page and Text block

I needed to check the maximum size of Visio pages for a current project of mine, so I devised a simple test with a diamond shape with its vertices pinned automatically to the edge of the Visio page, with text fields inserted in the center. I started with a standard A0 Landscape page, then multiplied the page width and height using the Page Setup dialog…