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 particular request was for a Timeline diagram, where the Milestone shapes are to be on specific layers. So, I just used one of the samples provided with Visio.
[Read more…] about Assigning Visio Shapes to Layers from Excel TableLayers
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.
Controlling Visio layers with linked data
Readers of my blog will know that I use the layers in Visio pages to change the display for different scenarios. My macro to toggle layers on/off has been very popular, and I have written an add-in to manage layers that is widely used. However, I was recently asked if the layer settings can be controlled from linked data. Linking data in Visio has been available in all desktop editions, except Standard, since 2007, and I have written many articles and two books extolling this feature, but I haven’t so far controlled layer settings with it, so this article describes how this can be done … as shown in the following screen recording!
Fixing the Layers problem with Callouts in Visio
I recently re-discovered an issue with callouts in Visio for a couple of projects that I am working on, and so I had to find a fix. The problem is that the callouts become dis-associated from their target shapes if either the layer visibility of the callout or the target shape is toggled off, and then back on again. This will result in a diagram with shapes without any connected callouts, so moving any of the target shapes will not move their associated callouts with them! I initially came up with a workaround that involved some jiggery-pokery with sub-shapes and layers, but it seems that the problem could have easily been averted if Microsoft had incorporated one specific User-defined Cell from the very start…
First, I should be clear which callouts I am talking about because the word has been used and abused over the years … This article refers to the callouts that are inserted from the Insert / Diagram Parts ribbon group. These are part of the Structured Diagrams concept that was introduced with Visio 2010.
Layer Manager add-in for Visio released
I use layers in Visio a lot. Maybe it is because I originally used CAD, and created facilities and cable management layouts linked to data. I know that some of my fellow Visio MVPS don’t use layers very much at all, mainly because they create process diagrams, I guess, but careful use of layers in a diagram can provide multiple views of the same base information. However, Visio has a more complex layering system than any CAD program that I used, so I have always created my own layer management tools. I have decided to package my utility together as an add-in that others may want to use too.
I have made some short videos explain the issue with layers in Visio, and how I solved it.
What’s the issue with layers in Visio?
Making it simple to toggle layer settings
Saving and recalling multiple layer settings easily
The add-in can be downloaded from my company website : LayerManager
I have put some licensing into the add-in, but 30 days are allowed for free.
Here is some of the genesis of this add-in : Toggling layers on and off
Microsoft inviting beta testers for Visio on iPad Preview
Well the secret is out … Microsoft are looking for beta testers for the initial release of Visio on iPad. Note, that this is view only, but it should offer a more faithful graphical representation than any third-party product. Plus, it has layer control!
Microsoft asks Insiders to comment in particular on the following iPad-specific features:
