bVisual

You are here: Home / bVisual Blog by David Parker / Browse blog articles

Browse blog articles

Select a category to view or simply scroll down below…

I have been aware and admired of your knowledge, skills and work for many years […]. So I find your Blog very useful, especially the how-to articles. I own all your books (using Amazon Kindle and Packt) and they have been a useful resource.

From a happy reader….
 <= Click icon to share in Teams

Update to LayerManager add-in for non-English users

A French user of LayerManager recently reported that the Refresh Counts button was not working for him, and a few other users were recently finding that the trial period was reporting expired immediately after download. Both of these issues have hopefully been addressed in the…

Pushing Data Visualizer in Visio beyond its limits

My last post was about some of the lessons learnt when trying to push Data Visualizer to its limits, but this one has some ways of overcoming these limitations. The main lesson learnt is that DV binds the shapes within the DV container shape, CFF…

Pushing Data Visualizer in Visio to the limits!

Regular readers of my blog will know that I like to use the Data Visualizer (DV) in Visio Plan 2, but I recently tried to help a user who really decided to push it to the limits. In this scenario, there were multiple connections, but…

Teams Tuesday Podcast Recording about Visio

I am delighted to share the link to my recent demonstration and conversation with fellow MVP Peter Ward about Visio in Teams. We discussed more than just Visio … and I look a bit like Max Headroom! (more…)

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…

Editing Visio Layer Colours with LayerManager

Desktop Visio has a tremendous ability to assign shapes to none, one or more layers, and the efficient use of them can make a drawing so powerful by toggling layers visibility or locking certain layers whilst working on other layers. The same drawing can be…

Setting Theme defaults in Visio

I was recently asked how to change the default font size and line weight in Visio, and then saw then many others are asking the same sort of question. I found one reasonable answer suggesting that you should create a new document from your required…

Visio Shape Report Converter Excel add-in available

I am delighted to announce that I have just had my first Excel add-in accepted in the Office Add-ins Store! It is called Shape Report Converter because all it does is convert a Shape Report converted from Visio for Desktop to a modern Excel table…

Binding Visio and Excel with Data Visualizer

I re-vamped some of my content about the Visio Data Visualizer add-in for Excel in my last post, so I thought I should expand a bit more on the Data Visualizer feature in Visio for Desktop (Visio Plan 2) and Excel for Desktop. I have…

Editing Visio Data Visualizer in Excel

I have previously described how to use the Visio Data Visualizer add-in in Excel, but I didn’t make it clear how you can edit the diagram created if you have a Visio license. So, I have recorded three short videos to briefly explain this. (more…)

A Visio List Shape is also a Container

Structured diagrams have been around in Microsoft Visio since 2010 and I have always known that list shapes are a specialized container shape, however it still came as a surprise to me recently that a list shape can simultaneously act as a container shape! There…

Taking Visio Actions Rows to the limit

I recently (re-)discovered that there is a limit to the number of Actions section rows that will be evaluated for display on the right mouse menu of a Visio shape. I have not hit a limit (yet) for the number of rows that can be…

TimeTable at RMConnect 2022

I was privileged to be invited to the biennial Robins & Morton conference in Orlando recently, where I assisted in presenting TimeTable to the hundreds of attendees there. A single wall-hanger (OPS) TimeTable Visio diagram automatically drawn from #OraclePrimaveraCloud data, is a condensed version of…

Custom Shapes in Visio in M365 and Web

Microsoft recently announced the ability to access the shapes in the document stencil whilst using Visio for Web … if you have a Visio Plan 2 license. So, I thought I would make it clear what that means for custom shape developers. There are now…

A Multi-Time Zone Clock for Visio

I wrote a post about making a clock face in Visio fifteen years ago, but a reader recently asked about displaying multiple time zones. Well, I have previously written about time zones in Visio, so I accepted the challenge to improve upon my earlier work.…

Update any Visio ShapeSheet cell with External Data

When Microsoft introduced a new way of linking external data to Visio shapes in 2007, I initially bemoaned the inability to update anything but Shape Data row values, unlike the old database add-on that I had been using for 10 years. The new method, though,…

Making Custom Shapes for Visio for M365

I recently revised my chess and checkerboard Visio documents to work in Visio for the Web (Visio Plan 1), but now that Microsoft are providing a version of Visio free to M365 business users, I need to make some further adjustment to get them to…

Referencing Container Data in Visio

Microsoft Visio has a useful Structured Diagramming concept that consists of Containers, Callouts and Connectors. The first of these features make it possible for shapes to know what they are contained within, as a better option to grouping shapes together. Grouping can hide or break…

Understanding Morse Clicks with Visio

A few years ago, I wrote an article about messaging and encryption inspired by a visit to the National Museum of Computing in the UK. I developed a Morse Click shape to demonstrate how Visio can be used to represent and learn Morse Code. However,…

Visio Presentations for the Microsoft Ignite The Tour 2020

Just when we thought the pandemic was coming to an end, another variant appears to scupper our plans. So, resuming in-person events is delayed, and the world isn’t safe until the world is immunised. Therefore, I decided to make the presentations that I was going…

Correcting the Text Control Handle on Visio Network Shapes

There are literally thousands of master shapes in the stencils supplied with Microsoft Visio, so I guess that mistakes can creep in. One error that I have noticed is the inability of the default text control handle of many of the network shapes to actually…

Have multiple alternate languages in the same Visio diagram

I wrote a Visio add-in a few years ago that provides the ability to switch a multi-page Visio diagram between alternative languages. This particular client had just under a hundred pages of process flowcharts, with hyperlinks between the pages. They had to produce this Visio…

Spotting Custom UI Errors in Visio Add-ins

I have written many COM and VSTO add-ins for Visio, but got confused when a client recently reported that the following Custom UI Runtime Error was appearing. I wasn’t getting the same error on any of my test laptops, so I chatted with my good…

Automatically displaying Visio shape text in other shapes

There are times, in Visio, when you just need to ensure that the text in a primary shape is synchronised with the text in different secondary shapes … even if they are on different pages of a Visio document. My previous article, Forcing Display Update…

Forcing Display Update of Inherited Data Values

I was going to title this “When is a truth not a truth?” because I have found that Visio can sometimes refuse to apparently update the displayed value in a cell, even though it has been changed. However, this was, in this instance, down to…

Using Custom Fill Patterns from a List

A reader asked how to fill a shape with a custom fill pattern from a fixed list in of a shape. They had no trouble with the first 25 standard fill patterns, but couldn’t figure out how to apply a custom pattern. So, I shall…

Visio in Microsoft 365? What’s that?

Now that a version of Visio is being rolled out as part of the commercial subscription of Microsoft 365, what is the difference between it and the Visio Web App that is delivered by Visio Plan 1 and Visio Plan 2 subscriptions? Moreover, can a…

Fixing the sub-shape layer assignments of Visio shapes

I was preparing a new update of my Layer Manager tool, and was constantly coming across a lack of quality control in the sub-shape layer assignment in a number of the master shapes in Microsoft provided stencils. I have mentioned this to Microsoft as a…

Developer Mode for advanced Layer Manager actions

I have had more than one person ask me how to see the full Layer Manager panel, so I must have not made it clear enough in the help file. Visio has a Developer Mode that is simple to switch on, and provides some extra…

Keeping Visio Data Graphic Items Level

My good friend Scott Helmers, Visio author and trainer, of Harvard Computing Group , recently asked for some help in keeping data graphic items level when their target shape is rotated. Fortunately, I was able to assist, so I thought I would explain how this…

What is the value of my MVP Award for 2021-22?

It may be something that has been repeated annually for 17 years, but I still feel so proud when the Microsoft MVP Award kit arrives at my door. We have seen changes to the scheme over the years, and my son tells me there are…

Visio ShapeSheet Functions T – Z

The seventh, and final, 25 of the Visio ShapeSheet functions that start with the letters T – Z are visually described in the Visio document below that is available for download. Please see the general introduction to this series at ShapeSheet Functions A-Z for more…

Update of Free Rules Tools for Visio Validation

Microsoft introduced Validation Rules in Visio 2010 Premium, and I was excited enough to write a book about it. Microsoft merged the Premium into the Professional edition in 2013, so I updated my book. I wrote an interface into the Visio Validation API as a…

Automatic Line and Segment Lengths in Visio

Many years ago, I wrote some VBA code to calculate the length of a multi-segment line in Visio, see Automating Area and Perimeter Length Shape Data , but Microsoft have since provided a handy ShapeSheet function, PATHLENGTH(…), to do the same without any VBA. The…

Visio ShapeSheet Functions S

The sixth 19 of the Visio ShapeSheet functions that start with the letter S are visually described in the Visio document below that is available for download. Please see the general introduction to this series at ShapeSheet Functions A-Z for more information. (more…)

Duplicating Visio Data Graphics

I was recently asked about switching between different Visio Data Graphics within a page, so I thought I should record a few short videos to explain how Visio Data Graphics work, how they can be edited and duplicated, and how to automate switching between them.…

Testing Regional Settings in Visio

There are times that I have been caught out by assuming that everyone speaks “proper” English, like what I do (sic), and forgetting that there are other languages with their own formatting conventions. I think most of the world is bemused at the USA date…

Visio ShapeSheet Functions O-R

The fifth 33 of the Visio ShapeSheet functions that start with the letters O through to R are visually described in the Visio document below that is available for download. Please see the general introduction to this series at ShapeSheet Functions A-Z for more information.…

Visio ShapeSheet Functions L-N

The fourth 34 of the Visio ShapeSheet functions that start with the letters L through to N are visually described in the Visio document below that is available for download. Please see the general introduction to this series at ShapeSheet Functions A-Z for more information.…

Visio 2010 MVP Session videos reprise

Back in 2012, my fellow Visio MVPs, Scott Helmers and Chris Roth, and I recorded a series of 24 videos about Visio 2010. They were first hosted on Microsoft’s web site, then they put them up on YouTube, they they got deleted :-(. Well, we…

Visio ShapeSheet Functions G-K

The third 26 of the Visio ShapeSheet functions that start with the letters G through to K are visually described in the Visio document below that is available for download. Please see the general introduction to this series at ShapeSheet Functions A-Z for more information.…

Two Quote or Not Two Quote …

… that is the question! I have known for some time that it is safer to copy and paste code from the web into Notepad or similar, before copying and pasting that into my own code. It is not only new line characters that can…

Visio in Organizations

My good friend and fellow Visio MVP, Šenaj Lelić, and I recently recorded a long webcast where we flew through some of the great capabilities of Visio through a Teams meeting. Microsoft Visio: Find out more about how you can work visually from anywhere, at…

Viewing Visio Document Changes in Git

Developing a Visio solution usually involves both .Net code and Visio ShapeSheet formulas. Good practice dictates that the source code is saved into a code repository, such as Git, where changes can be committed and commented. Visual Studio 2019 now includes native Git support, and…

Visio ShapeSheet Functions D-F

The second 32 of the Visio ShapeSheet functions that start with the letters D through to F are visually described in the Visio document below that is available for download. Please see the general introduction to this series at ShapeSheet Functions A-Z for more information.…

Visio ShapeSheet Functions A-C

The first 36 of the Visio ShapeSheet functions that start with the letters A through to C are visually described in the Visio document below that is available for download. Please see the general introduction to this series at ShapeSheet Functions A-Z for more information.…

Using the CALLTHIS function in Visio

Visio was the first non-Microsoft application to include VBA within it back in the mid-nineties. All of the desktop Microsoft Office applications currently include VBA, although Microsoft have been rumoured to want to replace it for many years, and now there is an alternative scripting…

Referencing Visio Shapes

Every Visio shape must have a unique name in the collection that it belongs to, and to ensure this, Visio automatically one using the master name or just “Sheet”, if not an instance of a master, followed by a period (“.”) and the ID. However,…

Play Backgammon with Visio

Still in lockdown on holiday, so I thought I would create a version of backgammon that can be played with Visio for the web. This was inspired by my original Visio tutor, the late David Edson, who created a Visio backgammon document which included macros.…

Play Chess with Visio in Teams

[Update : a new version of this file allows Visio for M365 users to edit/play with see Making Custom Shapes for Visio for M365] Following on from my last article about playing checkers with Visio in Teams, I decided that I should also revisit my…

Play Checkers with Visio in Teams

[Update : a new version of this file allows Visio for M365 users to edit/play with see Making Custom Shapes for Visio for M365] We are all spending more time in Teams or SharePoint nowadays, but not everyone knows that Visio documents can now be…

Creating PowerPoint Presentations automatically from Visio

Visio Plan 2 has a great, but flawed, feature called Slide Snippets, that can create PowerPoint presentations automatically from any number of titled rectangles, on any number of pages in a Visio document. However, it usually creates distorted images, and it does not automatically contain…

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

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…

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…

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…

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). (more…)

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

Using an Updateable Default Font in Visio

I am working on a Visio project where the client wants to be able to configure the font used in each document. These documents have many custom masters, but the user can add there own annotations too. Therefore, I needed to find a way to…

Manual Fix for Slide Snippets in Visio Plan 2

Microsoft Visio Plan 2 has a cool feature, Slide Snippets, that can create a PowerPoint slide show from special rectangle shapes placed around the pages of a Visio document. Unfortunately, there is currently an issue with distortion of the images in PowerPoint, so I will…

Getting the Microsoft Office Theme Value

I am working on a Visio VSTO project where I need to synchronise a UI element with the current session Microsoft Office Theme. At first, I thought that there would be some way of getting a value from the Visio object model, but I was…

Learn how to create custom Visio web app templates

I have now finished three articles about the differences between the Visio desktop and web apps, and how you can already create custom templates for Visio Plan 1. Comparing Visio for the Web and Desktop Customising Visio shapes for the web app Key differences between…

Assigning Visio Shapes to Layers from Excel Table

I work a lot with layers in Visio, and written an add-in, LayerManager, to assist, but I was asked an interesting question recently: How can shapes by assigned to layers automatically from a list in Excel? So, I thought I would present my solution. This…

Viewing the Visio Custom Line & Fill Patterns

I was trying to review the appearance of the custom line and fill patterns in Visio, but was annoyed that they are only displaying a name without a preview image. I could not find them easily on the web either, so I thought I would…

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

Microsoft Visio Partner hub

My company became a Visio business partner in 1998, so that was a couple of years before Microsoft acquired Visio for what was their largest purchase at the time. Microsoft wound down the annual Visio worldwide conferences that used to happen, and Visio partners became…

Using some Visio Shape Data in Visio for the Web

Like a lot of UK TV viewers last week, I watched Quiz, a drama about Major Charles Ingram who apparently cheated his way to the jackpot in Who Wants to be a Millionaire. Some of the questions that he was asked were quoted in that…

Visual Risks of a Global Pandemic

Back in the early noughties, I was part of a start-up company to to visualise the risks of any dependency system. We used Visio, of course, to map operational components and assets into a hierarchy of dependencies that simply displayed the roll-up of perceived risk.…

Viewing Visio Files in Public Websites

Some of my colleagues have asked me how I have managed to include Visio files into this public website, so I thought I would share my secret. Microsoft has kindly provided a File Viewer Web Part for use in SharePoint that appears to be useful…

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…

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…

Webinar on Visio, SharePoint and Teams using SPFx

I will be presenting a webinar on embedding Visio diagram in SharePoint Online and Teams next month, please register here ! (Or if you missed it live, then watch the recording !) The slides are available at https://www.slideshare.net/bvisual/creating-a-visio-web-part-with-sharepoint-spfx

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…

Embedding Visio documents for public viewing

I have been asked by a colleague to publish my hack for enabling Visio files to be viewed by everyone with the Visio for the Web component in reading mode on this website, or indeed any other public web site. So, here goes …. The…

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…

Countries of the World in Power BI with Flags

I like Power BI, and the latest update features the ability to set a custom web url onto another column. So, I couldn’t resist trying it in the example below. Notice that the Country or Area values are hyperlinks to the url of the country…

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…

Using Visio Org Chart Wizard to work with Exchange Online

I have used the Microsoft Visio Organization Chart Wizard many, many times over the years, but I usually use it from text files, and I had been aware that I was not getting good results from the Microsoft Exchange Server directory option, now that I…

Visio news from MS Ignite 2019

Microsoft Ignite 2019 at the huge Orange County Conference Conference Center in Orlando is over for another year. 30,000 attendees over 6 days, and I have seen my first sunlight today since I arrived in Florida last Saturday! So, it is time to review just…

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?

Sorry about Brexit

In these days of political uncertainty in the UK, and our position in Europe or the world, there is only one thing that I can say: Sorry about Brexit … in every main language of the EU countries .. using data-linked shapes in Visio.

Changing Visio Shape Size and Angle with Linked Data

I was recently laying out a computer room floor plan to scale in Visio, from survey data of the cabinets\racks within it, and it occurred to me that I could work a bit smarter than I first thought. Originally, I was going to just add…