bVisual

bVisual Blog by David Parker

Published on by

Counting glued and connected shapes in Visio

I got a surprise in one of my projects when I counted the shapes glued together using the Shape.GluedShapes(…) method … the sum of the filtered glued shapes just didn’t add up to the unfiltered count. So, I thought I should check the Shape.ConnectedShapes(…) method too … and there is a scenario where that has a similar result.

In the following diagram, I have different coloured squares with connection points of different types at the centre of each edge (as denoted by the connection type numbers), and one under a control point in the bottom left corner. I have glued the ends of coloured connector lines, statically (Red and Black) and dynamically (Green), and glued the Purple Square directly to the Orange Square. The Blue Square shape is glued to a connection point on the green dynamic connector.

7 Shapes glued & connected in a variety of ways

I then ran some code to get the count of glued and connected shapes … and noticed some apparent discrepancies…

[Read more…] about Counting glued and connected shapes in Visio

Published on by

My new book on Visualizing Processes with Microsoft Visio has launched

Back in the early 1990s, there was an application called ABC Flowcharter that was the market leader for diagramming business flowcharts, but some of the brains behind Aldus PageMaker saw an opportunity to create something smarter, and left to write the Visio product, with the stated aim to overtake ABC Flowcharter within 2 years. They did it in just 18 months and Visio expanded to cover more types of diagramming, especially organization charts and network diagramming. Visio became the default vector-based, data-diagramming application for the desktop, and so Microsoft acquired the company in 2000, who started to integrate it with Microsoft Office applications. Many imitators on the desktop tried to emulate Visio, but most fell by the wayside. There were constant requests for Visio to work on Apple Macs, but Microsoft resisted making a Mac specific version, and instead started to make Visio work in a web-browser, so it can work anywhere on any modern device. There are literally millions of lines of code on Visio, so it was never going to be straightforward or easy, but now we do have a light edition of Visio provided to all M365 business subscribers, and two extra subscription levels for more features and capabilities. We still have desktop Visio Standard and Professional, but the edition that straddles both the desktop and web is Visio Plan 2. It has some desktop only features delivered via web-services, and an enhanced browser-based editing experience. Visio Plan 2 is the edition for heavy or advanced users, but any of the desktop editions can be viewed as a design studio for content that can be used by the browser users because of Visio’s unique ShapeSheet feature that contains Excel-like formulas to control the properties of the shapes. Almost all of these formulas work in the web browser, but desktop Visio is required to write the formulas initially. This means that powerful customizations are possible without any web-scripting, and achievable by anyone who can write formulas in Excel!

So, this new book focuses on the original driver for Visio, process flowcharts, and explains how the different Visio editions can be used to create, edit, collaborate, comment, present, automate, export them, and finally how to customize them. Find out more at Visualize Complex Processes with Microsoft Visio!

[Read more…] about My new book on Visualizing Processes with Microsoft Visio has launched

Published on by

Layer Set menu options and calls from code added to LayerManager

LayerManager for Microsoft Visio layer sets can now be called from external code and are also available from a sub-menu of the Layer Buttons drop-down ribbon button. The Layer Manager window does not need to be open to use the sub-menu because it detects the Layer Set buttons on the page.

[Read more…] about Layer Set menu options and calls from code added to LayerManager

Published on by

Interactive Demographics of the European Union in Visio

I was recently contacted by a reader, Stanley M. Max (Towson University lecturer), who had started creating a Visio map of the 27 countries in the European Union in 2020, along with the demographics culled from Wikipedia. He wanted to know if the map and stats could be combined to make a more appealing presentation. Well, that prompted me to not only combine the data and country shapes, but to explore ways in which a presentation of the map can be made more interesting in Visio. So, I added data and hyperlinks to the shapes, and set up a page property for the selected country which automatically highlights the country shape, statistics, and header, to which I added flags. So, the user can either set the page country using the Shape Data window for the page, or context menu of each country, or simply by double-clicking.

  • The original Visio page
  • The original Excel table
  • The enhanced Visio page
  • A country selected for the page
  • Adding Slide Snippets
  • Exported to PowerPoint
  • Export to Word previews
  • Exported to Word
[Read more…] about Interactive Demographics of the European Union in Visio

Published on by

Understanding Visio Data Graphic’s Color by Value

The desktop Visio editions, Visio Professional and Visio Plan 2, have a great way of automatically displaying data as Data Bars, Icon Sets, Text Callouts and Color by Value. The first three types of Data Graphics require sub-shapes to be inserted into each shape that they are applied to, but the last one, Color by Value (CBV), merely requires some User-defined Cells and formulas. However, unlike the first three, there can be only one Shape Data value displayed as colours in each Data Graphic (DG). So, how can we easily update the colour assigned to each value using code, rather than manually using the manual dialogs provided?

  • One Data Graphic with 4 CBVs
  • The first in the list is applied
  • Numeric data can have two types of CBV
  • Locating the Data Graphic master
[Read more…] about Understanding Visio Data Graphic’s Color by Value

Published on by

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 latest version 23.3.1, which is available for free to current users.

  • Before clicking Refresh Counts
  • After clicking Refresh Counts
[Read more…] about Update to LayerManager add-in for non-English users