ShapeSheet Formulas

Published on December 15, 2025 by David Parker

A visual exploration of Penrose Tiling in Visio

Maybe it is because I used to be a building architect, but I have always been fascinated by the relationship between numbers and visualisations. Perhaps the most famous one is the Golden Ratio which has been used as the basis of many building designs and art pieces. It is often recognised to create a harmony that is universally understood, and is repeatedly found in nature, yet it all boils down to a simple ratio of about 1.618 … and is related to the Fibonacci Numbers. Roger Penrose (re-)discovered shapes based on the Golden Ratio can be arranged aperiodically on an infinite canvas without a repeating pattern. These Penrose Tiling shapes were developed into two groups (P2 and P3) each with two shapes.

There are rules about the arrangement to ensure that they do not fall into a repeatable series. These rules can be followed by ensuring that the ends of the arcs within each shape meet each other. The shapes can be used to try to create an aperiodic pattern of an infinite size, and then a timer can randomly change the colours. It’s a little festive fun!

Kites and Darts with Arcs
Kites and Darts without Arcs
Thick and Thin Rhombi with Arcs
Thick and Thin Rhombi without Arcs
Patterned Rhombi

[Read more…]

Published on November 10, 2025 by David Parker

How SVG in Visio can cause a Shape.BoundingBox(…) error

I have used Visio’s Shape.BoundingBox(…) for many, many years and I cannot ever recall it failing, but I have now managed to create some shapes that cause it to error. This caused many hours of confusion, so I nearly abandoned using the method, until I discussed it with my fellow Visio MVP, John Goldsmith (see VisualSignals), and together we examined the cause. It came down to a badly formed sub-shape within the shape that had zero dimension … and in fact had an incomplete ShapeSheet. If you look at the screenshot below, then you may notice that there is no Shape Transform section! That is a mandatory section, and should always exist … so how did this happen?

[Read more…]

Published on June 26, 2025 by David Parker

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…]

Published on April 29, 2025 by David Parker

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:

Manual resize of the shape with the shape handles to only the specified sizes
Selecting a dimension from the Shape Data panel
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…]

Published on March 5, 2025 by David Parker

Smart Radio Buttons and Check Boxes in Visio

A recent project requires an interactive tutorial within Microsoft Visio desktop where a lot of the questions need a single answer using radio buttons, or multiple-choice answers using check boxes. I thought that this would be a great use of the list containers capability because the questions and answers could be part of the container shape whilst the individual questions are presented as items in the list and automatically inheriting their particular question text from the containing list shape. So, this article provides these smart master shapes, and explains how they are built.

In Tutor mode, the Questions, Answers, Explanation and More Info can be edited
In normal mode, the Questions are presented unmarked and without explanation
Incorrect answers are marked with a red cross. An explanation and optional more info hyperlink is available
Correct answers are marked with a green tick. An explanation and optional more info hyperlink is available.

[Read more…]

Published on March 1, 2025 by David Parker

Using Button Face Ids in Visio

Microsoft Visio desktop has the ability to display icons from a built-in list of Office icons on Actions and Action Tags (nee Smart Tags). These can be set in the ShapeSheet by using the desired number from several thousand in the ButtonFace cell. Although there is the ability to add better icons using code, the quick ShapeSheet formulas are useful way of indicating the purpose of a command. This article simply lists the first 3,600 of these fas a quick and easy reference for me, and othe ShapeSheet disigners out there!