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:



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:


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.


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.


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



Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


O365 and SharePoint

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

Microsoft Power BI, Analysis Services, MDX, DAX, M, Power Pivot and Power Query

Azure Solutions for Office 365, and more...

Rob Fahrni



Life with Visio and other Microsoft Toys!

Nilsandrey's Weblog

Just another 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

Smart graphics for visual people

%d bloggers like this: