bVisual

Visio

Published on by

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:

  1. Manual resize of the shape with the shape handles to only the specified sizes
  2. Selecting a dimension from the Shape Data panel
  3. 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…] about Fixing dimensions of 2D shapes

Published on by

Merging Linked Data from Similar Tables

I was recently asked how to link data from different tables but with similar column names to Visio shapes. In this case, each table has the same unique identifier, but some of the column names are the same. The problem is that the data linking matches the column name with the label of a Shape Data row label, so the shared columns were updated with the values from the last linked data recordset. In this article I present a simple way that this restriction can be overcome.

[Read more…] about Merging Linked Data from Similar Tables

Published on by

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!

  • Face Ids from 0001 to 0360
  • Face Ids from 0361 to 0720
  • Face Ids from 0721 to 1400
  • Face Ids from 1441 to 1800
  • Face Ids from 1801 to 2160
  • FaceI ds from 2161 to 2520
  • Face Ids from 2521 to 2880
  • Face Ids from 2881 to 3240
  • Face Ids from 3241 to 3600
[Read more…] about Using Button Face Ids in Visio

Published on by

Grid Snapping Revisited

I have previously tackled the subject of snapping to grids in Visio desktop (see https://bvisual.net/2018/06/19/really-snapping-to-grids-in-visio/ ) but a recent project required me to improve the example because it did not respond to all cursor arrow keys. The problem was that the previous solution could not understand which arrow key had been clicked, therefore it did not know if to reposition to the previous or next grid. The new ShapeSheet code solution can now respond to the correct arrow key … and all without any add-in. In addition, I also show how a Control point can be made to snap to a grid spacing, and how AutoConnect can be set to add the next shape at the right offset in both the horizontal and vertical directions.

Lastly, Microsoft released the web edition of Visio since the last article, and I demonstrate the difference behaviour of grid snapping between that and the desktop edition.

  • Set the Horizontal and Vertical Grid Spacing
  • Turn OFF Snap to Ruler subdivisions and Grid ON
  • Edit Space between Shapes for AutoConnect
[Read more…] about Grid Snapping Revisited

Published on by

Optimize Visio Flowcharts: Swimlane Reordering Tips

Microsoft Visio desktop Plan 2 and Professional editions provides the ability to create and synchronize cross-functional flowcharts between the diagram and an Excel table. This is great, and widely used for many types of processes. The Excel table normally has a Function / Swimlane column that contains text that becomes labels on the swimlane containers, and a Phase / Timeline column that contains text that becomes the label of the phase or separator containers. The import provides the option to order the diagram by Function and/or Phase, but it is impossible to get them ordered by both! This article provides a solution using a free macro-enabled Visio stencil.

  • Excel table with Function and Phase columns
  • Visio Data \ Create from Data
  • Step 2 More Options to order by Phase
[Read more…] about Optimize Visio Flowcharts: Swimlane Reordering Tips

Published on by

The importance of #layers in Visio for Power BI

Judging by the number of downloads of my free Visio and Power BI GuIde, there is an increasing recognition of this great feature. I recently started to prepare an example for someone, but found that their sample Visio document has just over the 1,000 shape limit, so what can you do about that? The answer is to modify the master shapes so only the top level of the group has a # symbol at the start. This ensures that only the shapes on these layers are counted. In this particular example the count of shapes was reduced from 1,084 to 278 … well within the limit!

So, how is this done? Well, this can be done manually by editing each master shape. In this following example the shape count is reduced from 6 to 1 using this method, and there are 45 instances of this master shape on the page. so that makes 45*5=225 less shapes just by editing this one master.

  • Master structure before any changes to the layers
  • Master structure with # layer for the top level group
[Read more…] about The importance of #layers in Visio for Power BI