bVisual

Shape Data

Published on by

Visio World Time Zones

My last post about a world map inspired me to find a time zone map that could be used in Visio. I found an SVG map at

http://upload.wikimedia.org/wikipedia/commons/6/68/Standard_time_zones_of_the_world_%282012%29.svg that I could convert, and link a list of time zones from

http://en.wikipedia.org/wiki/List_of_time_zones_by_UTC_offset that I put into Excel.

image

I have used Visio’s Color By Value Data Graphics, so you can easily edit the colour scheme.

You can download this map from http://sdrv.ms/1bCUSXx

Published on by

Visio Map of the World

I have often wanted a Visio map of the world, with countries that can be linked to data. There are a number of Visio country shapes that are available for download on the internet, but they are fairly old, and certainly don’t have an up to date world. For example, South Sudan is currently the newest country in the world (2011), though a lot of resources on the web don’t show it. So, I was relieved to find a good SVG world map at http://commons.wikimedia.org/wiki/File:BlankMap-FlatWorld6.svg?uselang=en-gb . Even better was that each of the shapes are named with the ISO2 code. This meant that I could use Link Data to Shapes to automatically create Shape Data from an Excel worksheet that I put together from various sources.

image

Note that I had to add Kosovo manually, since it was not on the original map, as it’s status as a country is in dispute. The ISO codes have apparently been temporarily assigned.

[Read more…] about Visio Map of the World

Published on by

A Page Grid with Labels

Over a year ago, I wrote a blog about Page Grids and Off Page References ( see http://blog.bvisual.net/2011/09/02/page-grids-and-off-page-references/ ), and I promised to accommodate page margins. In addition, a user commented that a matching printable grid would be useful …. so here is an update. In this blog I provide an updated Off-page reference master, along with new GridLines and GridLabel masters.

image

[Read more…] about A Page Grid with Labels

Published on by

Assigning Shape Layers from a List in Visio

A Visio user recently asked if it is possible to assign shapes to layers from a list. In his case, he has an Excel table which he has exported shapes and their text using Visio’s Shape Reports feature, to which he has added a column named Layer, and he wants to assign the shapes to these layers. In this article, I demonstrate how this can be done.

I decided to use my MVP Session Wheel diagram ( see http://blog.bvisual.net/2012/06/29/mvp-sessions-wheel/ ) for this example because it already has some layers assigned.

I created a new Shape Report called Presenter Shapes, where I filtered all shapes on the current page to those where the Presenter Shape Data row exists, and the Presenter actually has a value:

image

[Read more…] about Assigning Shape Layers from a List in Visio

Published on by

Which field is that cow in?

I reader of one of my earlier posts, Copy Data from one Shape to Another ( see http://davidjpp.wordpress.com/2009/02/02/copying-data-from-one-shape-to-another/ ) asked how a cow can inherit the field number of from the field that it in. I think that this is just an example of how you can automatically update any Shape Data value from an underlying container, but I will use a cow in a field example anyway. This example uses VBA code, but should be good to use in any version of Visio since Visio 2000.

[Read more…] about Which field is that cow in?