• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • Visio Shape Report Converter
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Using Visio in Education for GIS
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Visualize Complex Processes with Microsoft Visio
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network
You are here: Home / Visio / Using Icon Sets shapes to display Shape Data values

Published on August 21, 2014 by David Parker

Using Icon Sets shapes to display Shape Data values

A reader of my blog recently asked whether it is possible to use the icons in out-of-the-box Visio as the main shape, and get it to refresh with data. I pointed out that all of the icon sets are available in a handy stencil under Visio Extras, so all that remains is to make the icon display change according to data values.

SNAGHTML2b09d2

If we look closer at the master shapes on this stencil, then we find that they all have a Fixed List data type Shape Data row labelled “Display Icon”, with the exception of the Filled circles master shape which has a Shape Data row labelled “Data Icon” – surely this was a mistake by Microsoft. The Fixed List is allows you to choose between 0 to 5, ”, with the exception of the Lights master shape which has a Shape Data row which has only for 0 to 4. The 0 value in each case, effectively makes the shape invisible, therefore, all but one has 5 different appearances.

image

Now, when we link data to shapes, Shape Data rows are automatically added to the shape, labelled the same as the field name, and with a name derived from it, starting with a “_VisDM_” prefix, and with spaces and special characters suitably replaced.

Well, that is what is supposed to happen, but when I tried to link data to one of these shapes, I discovered that The “Link to Selected Shapes” right mouse menu option was disabled.

image

So, I investigated, and found that it was because of a special User-Defined Cell called User.msvCalloutType exists in the ShapeSheet of the shape. In fact, there are a few of them that were added to control its behaviour as a data graphic item.

image

Simply changing the name of User.msvCalloutType to, say, User.msvCalloutTypeX is enough to enable the “Link to Selected Shapes” menu option.

image

Note that the User-defined Cells values have all turned blue. This is because the whole section is now local, rather than inherited.

Next, when I link a row of data from the External Data window, Visio adds the new Shape Data rows, and they also turn blue because the whole section is now local.

image

Now, I need to decide which of the possible State values (Off, Running, Paused, Suspended, Disabled) are best represented by the values of the Display Icon Shape Data row, which are displayed from 0 (invisible) to 5 (three grey lights) below:

image

So, let’s say I think that these graphics are best to represent Empty, Off, Paused, Running, Suspended, Disabled then I do the following:

Edit the Prop._VisDM_State.Type cell to 1 which is (Fixed List)

Edit the Prop._VisDM_State.Format cell to “;Off;Paused;Running;Suspended;Disabled”

Insert a new User-defined cell named DisplayIconTrigger

Edit the User.DisplayIconTrigger.Value cell to =DEPENDSON(Prop._VisDM_State)+SETF(GetRef(Prop.IconNumber),”=INDEX(“&LOOKUP(Prop._VisDM_State,Prop._VisDM_State.Format)&”,Prop.IconNumber.Format)”)

This means that the value of the Display Icon Shape Data row will be set to the same index as the value of the State Shape Data row.

Edit the Prop.IconNumber.Invisible cell to TRUE because it is no longer necessary to see it.

image

The shape is now ready to placed into a stencil as a master, or, if you want to update the original master in the same document then:

Ensure that this is the only instance of the chosen master (in this case Traffic signal 1), then Cut it (Ctrl+X).

Open the master Traffic signal 1 in the Document stencil for edit

Delete the old shape

Paste the new shape from the clipboard (Ctrl+C).

image

Edit the Master Properties by ticking Match master by name on drop – this ensures that my new version of the master will be used in this document, even if the Traffic signal 1 shape is dragged and dropped from the Icon Sets stencil.

image

I now have a Traffic signal 1 master that can be linked to data so that the State Shape Data value will change the display accordingly.

image

It took a long longer to write up than do!

Related

Filed Under: Data Graphics, Shape Data, ShapeSheet Formulas, Visio, Visio 2013 Tagged With: Shape Data

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Trackbacks

  1. Exposing the Visio Data Bars | bVisual says:
    December 1, 2014 at 8:09 am

    […] data can be displayed as Text, Data Bar, Icon Set or Color By Value. In an earlier article ( see http://blog.bvisual.net/2014/08/21/using-icon-sets-shapes-to-display-shape-data-values/ ), I showed how to enable the shapes in the Icon Sets stencil to be linked to data. Well, I have a […]

    Reply
  2. A Table of Visio Data Graphic Icon Sets | bVisual - for people interested in Microsoft Visio says:
    March 18, 2015 at 11:02 am

    […] http://blog.bvisual.net/2014/08/21/using-icon-sets-shapes-to-display-shape-data-values/ […]

    Reply
  3. Using Visio Professional 2016 Text Callouts, Icon Sets and Data Bars to display data directly | bVisual - for people interested in Microsoft Visio says:
    December 24, 2015 at 3:49 pm

    […] http://blog.bvisual.net/2014/12/01/exposing-the-visio-data-bars/ and http://blog.bvisual.net/2014/08/21/using-icon-sets-shapes-to-display-shape-data-values/ for the Visio 2013 […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio
  • Grid Snapping Revisited

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript LayerManager Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Setup and Deployment Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Validation VBA Video Visio Visio 2007 Visio for the Web Visio Online Visio Services Visio Viewer Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • Amazon
  • E-mail
  • Facebook
  • LinkedIn
  • Twitter
  • YouTube

Search this website

Recent posts

  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio
  • Grid Snapping Revisited

Copyright © 2025 · Executive Pro on Genesis Framework · WordPress · Log in