bVisual

Visio

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

Published on by

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 with different labels, being created between the same flowchart shapes, and the plea was how to make it work! Well, I experimented with this, and found that DV does not really work well in this way, and then proposed an alternative approach, which I will explain in this article.

First, I will show how it fails by setting up an Excel table that does contains multiple connections, but fails to update the labels consistently.

Excel Table with Multiple Links
[Read more…] about Pushing Data Visualizer in Visio to the limits!

Published on by

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!

[Read more…] about Teams Tuesday Podcast Recording about Visio

Published on by

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 covered with some VBA examples in my book, Mastering Data Visualization with Microsoft Visio Professional 2016, but I mostly write C# code in VSTO add-ins, so I thought it would be useful to demonstrate how easy it is to create data links by dropping a shape, and by adding links to an existing shape. The book, by the way, is still relevant for the current Visio Professional and Visio Plan 2 editions!

[Read more…] about Linking Data to Visio Shapes in Code