bVisual

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

LinkedIn now has Visio Skills Assessment

Did you know that you can boast about your Visio skills on LinkedIn now? I just took the assessment, and fortunately, I passed … otherwise I wouldn’t be telling the world abut it 🙂

The entry point is cunningly hidden towards the bottom of your profile!

Published on by

My sessions at MS Ignite the Tour 2020 London

I was pleased to present two sessions at London ExCel last week about Visio. Attendance was good, maybe too good because some could not get close enough to hear. There was a lot of background noise, and my presentations were too long for the 15 minutes slot, but content was eagerly received.

My Visio Power BI presentation …

I told everyone to download the slide decks, but I cannot find the link on the TechCommunity pages yet, so I have created my own links ….

[Read more…] about My sessions at MS Ignite the Tour 2020 London

Published on by

Clarity Videos Re-boot

I am upgrading this website at the moment, and I came across on old post of mine about a new video series that Microsoft launched in 2009 … yes, 10 years ago! So, I thought I wouldre-boot the series for all our enjoyment … and because almost all of the features are still present, with a new look, and some new features!

Clarity ep. 1: Create an Office Layout diagram using Visio

[Read more…] about Clarity Videos Re-boot

Published on by

Power up your Visio diagrams

It’s a new year, and Microsoft Visio Online Plan 2 continues to be updated monthly. There is plenty to get excited about, for example, broken links in Data Visualizer can now be repaired automatically. Also, I am pleased to report that I have written a white paper on using Visio in Power BI effectively! This downloadable guide explains how to combine Visio drawing pages and Power BI data to create great interactive data visualizations, and can be requested from Power up your Visio diagrams.
preview-lightbox-cta-02
I will also be doing a webcast about this subject, so be sure to sign up for notification!