Improving the legend of multi-data Data Graphic items in Visio

Data Graphics in Visio Professional (and Premium) are a great way of surfacing the information in each shape, but it can be easy to forget what the Color By Value, Icon Sets or Data-bars represent:

image

 

Fortunately, Visio provides an Insert Legend task, which will lay each of the Graphic Items out into a list, either horizontally or vertically, in the top right corner of the page:

image

Whilst the text can be easily edited to be something more meaningful, it is annoying that the Multi-bar graph Data-bar always shows 5 columns, even if you have used less in your Data Graphics. In my case, I was only using the first two in order to compare Min_Cost with Max_Cost. The editing of this legend item is a bit more obscure, and requires opening the ShapeSheet of it.

image

In there, I found a User.BarCount cell, which is set to 5. I changed that to 2, and immediately the legend shape reduced in width, but the bars and text for the remaining 3 unrequired bars still showed.

Then I edited the Value in the Shape Data rows with the labels Field 3, Field 4 and Field 5 by entering two double-quotes, “”, and then these bars and their text disappeared. This legend item now only shows 2 bars, and is the correct width, and I could get on making the rest of the legend look good. I also entered more suitable values in Prop.msvCalloutField.Value and Prop.msvCalloutField2.Value (Field 2) cells whilst I was at it.

image

This technique probably applies to the Stacked bar 1 and Stacked bar 2 Graphic Items too:

image

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

davecra.wordpress.com/

Microsoft Office Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...

%d bloggers like this: