Visio Org Charts with Multiple Languages

I had an enquiry recently about displaying Organisation Charts with text in different languages. This set me thinking, and, if you have Visio Professional, then you can use Link Data to Shapes to add this capability to existing diagrams, but Visio Standard users can just the Org Chart Wizard.

I will use the OrgData.xls file that is provided in the <Program Files>\Microsoft Office\Office 15\Visio Content\<LCID>\ folder to demonstrate this. I have English US (1033) and Norwegian Bokmal (1044) available to me, as shown below:

Read the rest of this entry »

Making unused data-linked SharePoint columns in Visio invisible automatically

I described how and why I sometimes link a SharePoint document library to Visio documents in a previous article ( see I mentioned that I always switch off the visibility of some columns because they are rarely needed in my Visio shapes as shape data rows. In this article, I present a VBA macro that can switch them off for you, therefore ensuring consistency.

The Link Data to Shapes feature in Visio does not allow for filtering of columns or rows when SharePoint lists are used as a data source. One answer is to create a view of the list in SharePoint to restrict the rows and some columns, but other columns still get pulled through to the External Data recordsets in Visio by default:


Read the rest of this entry »

A Table of Visio Data Graphic Icon Sets

I have previously written blog articles about using, and extending, the Microsoft supplied Data Graphic Icons Sets, but I never explicitly listed their variations in a useful visual table. So, here is one:

Read the rest of this entry »

The history of Visio

I have been a dedicated user and developer of Visio since 1996 when I got a week-long developer training course presented by Dave Edson (see ) and Mark Davison in Paris. Previous to that, I had been working with CAD and databases (or spread sheets), but I had noticed either version 1 or 2 of Visio on a computer mag cover disk, and earmarked it for future investigation.

We have recently been made aware that Ted Johnson, one of the original founders, has a website with the history of Visio up to the acquisition by Microsoft in 1999 ( see ). It is fascinating reading, and there are lots of faces that I met there, plus some that you should still be aware of ( eg Chris Roth, aka VisGuy ).

image image
image image
1992 2015

Visio is a unique product, and the story of Visio shows that it is a well-loved one, with an enthusiastic team behind it, and an watchful community eager to see it further develop!

Posted in Visio. Tags: . Leave a Comment »

Updating the file path of data linked Excel tables in Visio

Link Data to Shapes in Visio (not the Standard edition though) is great for visualizing information, and I often use a multi-worksheet Excel workbook that I create locally, and then wish to re-link to a copy of the workbook elsewhere, or even in Office365. This is a simple task if there are only one or two Excel tables involved, but can become tedious when there are many. So, this blog is presents an semi-automated method of achieving this.

Read the rest of this entry »

Displaying SharePoint Document Library Column Values on Visio Services Diagrams

It is often useful to be able to link text or graphics to the values in the SharePoint document library that a Visio diagram is stored in. A SharePoint Document library is just a list with columns and Visio 2013 documents can be linked to the data in SharePoint lists … and it will be automatically refreshable. This means that Approval Status changes, for example, can be displayed as text or icons. This article goes through the methodology of linking data from the SharePoint document library to the Visio document.

Read the rest of this entry »

Visio for Mac ? Well, not really ….

My fellow Visio MVP, John Marshall (see, pointed out recently that Lucid Software claim to have a Visio for Mac application that offers import and export of real Visio files. Well, although I would love to have a web-edition of Visio from Microsoft, I was interested to discover if the claims are true … so I signed up for a trial. I present my findings below, based on just one Visio document that I have used in this blog before ( see ). My conclusion is if you use Visio for high quality vector graphics or for any type of business intelligence then wait for Microsoft to do it right! Please do not even consider round tripping Visio files to Lucidcharts and back, because you will be extremely disappointed.

Read the rest of this entry »


Get every new post delivered to your Inbox.

Join 250 other followers