John Goldsmith's visLog

Using page Shape Data in Visio master shapes

I had a question recently on how to include page Shape Data in master shapes.  This sounds like a useful subject for a blog post…

Multi color by value using Visio data graphics (3 of 3)

This is the third and final part of a post on how to create a Visio shape that displays multiple colours based on linked data within an Excel workbook...

Multi color by value using Visio data graphics (2 of 3)

This is the second part of a three-part post on how to create a Visio shape that displays multiple colours based on linked data within an Excel workbook...

Multi color by value using Visio data graphics (1 of 3)

A recent question on the VisioGuy forum asked how you would go about creating a Visio shape that displays multiple colours based on linked data within an Excel workbook.  I thought I’d have a look at how you might tackle this problem…

Building Visio shapes with code

The last post on ‘Modifying the Visio Grid shape’ demonstrates how to change the resizing behaviour of a complex shape from a ShapeSheet perspective.  I used the word ‘modifying’ but, in fact, it’s actually a new shape and one built using code and it’s this aspect that I thought I’d focus on in this post. 

I’d love to encourage anyone who’s not written any code before to keep reading as I think this makes a good challenge for new coders.  If you’re in that boat then you might also want to have a quick read through Just for starters and Looping through to get you going, but the code below has lots of comments and is hopefully self explanatory.

Modifying the Visio grid shape

A recent TechNet forum question asked if it was possible to change to behaviour of the Grid shape, found under ‘Charting Shapes’ stencil.  The existing shape’s size is based on the total number of columns and rows whether they are visible or not.  I thought I’d take a look at one way of changing this…

No mouseover with visEquivTitle

A current project extending Visio’s Save As Web functionality threw up an interesting problem today.  If you’re using the User.visEquivTitle solution to provide an alternative tooltip then you need to make sure that the cell’s value is a string with a length greater than zero…

Creating a color picker in Visio

This post is inspired by a recent one by Saveen Reddy on creating a bitmap color wheel image.  Saveen’s post demonstrates some C# code to generate a png image pixel by pixel.  I thought this might make a handy shape in Visio when you want manipulate colors without opening the modal format dialogs within Visio itself.

Shapes with global values

There was a recent question in the TechNet forum asking how you could have multiple instances of a shape that have both local (specific to each instance) and global (shared) fields.  I thought I’d take a quick look at how you might achieve that.

Using Excel to build Visio ShapeSheet formulae

When building custom shapes in Visio, you can often find yourself having to construct complex formulae that follow a repeatable pattern.  There are a number of ways of attacking this problem that range from writing each formula one at a time through to generating the formula strings in code…