bVisual

Shape Design

Published on by

Using Emojis in Visio

In the new normal of social distancing, we can easily miss the nuances of facial expressions with the the various electronic communication platforms that we utilise. In our personal communications via mobile apps, we have all started to use Emojis to express sentiment and actions, although we can sometimes convey the wrong meanings unintentionally as some Emojis get re-purposed by certain sections of society. Microsoft Windows 10 added native support for Emojis a year ago, and they can be inserted into many Microsoft applications using the onscreen keyboard 👀:

Windows 10 Onscreen Keyboard
[Read more…] about Using Emojis in Visio

Published on by

Using CODE() and UNICODE() functions in Visio

Microsoft Visio does have CHAR() and UNICHAR() ShapeSheet functions, just like Excel, but it does not have the inverse CODE() and UNICODE() functions, unlike Excel. However, there is a way to create a formula in the Visio ShapeSheet to provide these functions.

The following worksheet demonstrates how the CHAR(), CODE(), UNICHAR(), and UNICODE() functions work in Excel.

ColumnFormula
Indexn
Char=IFERROR( CHAR(INT([@Index])),””)
Code=IFERROR( CODE([@Char]),””)
Unichar=UNICHAR(INT([@Index]))
Unicode=UNICODE([@Unichar])
[Read more…] about Using CODE() and UNICODE() functions in Visio

Published on by

Preventing Deletion of Container Members in Visio

The concept of Structured Diagrams was introduced in Visio 2010 and is featured in many of the templates supplied with Microsoft Visio, and in some third-party solutions, like mine. Connectors, callouts, containers and lists are the key parts of a structured diagrams, and there are times when preventing the deletion of members of a container or list is desirable.

  • An example cross-functional flowchart
  • Accidental deletion of a process shape
[Read more…] about Preventing Deletion of Container Members in Visio

Published on by

Displaying Visio Number Shapes data clearly

Visio has had a Number Shapes add-on for many years, even since before Microsoft bought the application in 2000. The add-on autmatically creates three Shape Data rows to hold the number, any prefix text, and a value to indicate whether the shape number text should be shown. It is useful, but it can also be very annoying if you also want to label your shapes, such as with process flow shapes, or you want the shape number to be displayed outside of the main shape. Fortunately, there is a solution….

  • No Numbers
  • Visio Extras / Number Shapes
  • Number Shapes / General
  • Number Shapes / Advanced
[Read more…] about Displaying Visio Number Shapes data clearly

Published on by

Overcoming ‘We can’t open your file in Visio because it exceeds the shape count limit’ in Power BI

If you are one of the increasing number of Power BI users that have discovered that the Visio Visual gives you the great ability to include Visio diagrams in your dashboard, then you may have come across the following error, ‘We can’t open your file in Visio because it exceeds the shape count limit’ in Power BI’, when you try to embed a Visio document. This can be frustrating, but here is a deeper explanation of what is happening … and how you can usually overcome it.

[Read more…] about Overcoming ‘We can’t open your file in Visio because it exceeds the shape count limit’ in Power BI

Published on by

Testing Visio shape text for WCAG 2.0 pass

The Web Content Access Guidelines (WCAG) 2.0 provides the current recommendations for making web content accessible to users with vision impairment, but how do you test if your Visio shapes pass? There are several web sites out there that provide this capability, but all of them require the HEX values, rather than the RGB or HSL that Visio provides natively. Therefore, I have created a Visio callout shape that can be associated with a target shape to report on the values of each of its main color elements and provides hyperlinks to automatically check the contrast ratio on WebAIM.

Color Values Shape


The colour formats that can be selected from either the Shape Data window or the right mouse menu are:

[Read more…] about Testing Visio shape text for WCAG 2.0 pass