One of the most useful capabilities of Visio Professional and Visio Plan 2 is to link external data to shapes and have them refreshed by changes in the data source. So, many of my solutions involve writing code to make these links, and they are covered with some VBA examples in my book, Mastering Data Visualization with Microsoft Visio Professional 2016, but I mostly write C# code in VSTO add-ins, so I thought it would be useful to demonstrate how easy it is to create data links by dropping a shape, and by adding links to an existing shape. The book, by the way, is still relevant for the current Visio Professional and Visio Plan 2 editions![Read more…] about Linking Data to Visio Shapes in Code
Link Data to Shapes
So, I have created some macros to provide quick and easy selection, positioning and updating of images within a group shape.
[Read more…] about Replacing Images in Visio Shapes by Changing Data
I decided to present this article with VBA code rather than my preferred C# so that a stencil could be downloaded to provide instant usability, rather than having to install an add-in. It can be download from Image Utils.vssm, and should then be placed in to My Shapes folder, so that it becomes available to open in Visio. When it is opened, then the macros will need to be enabled.
There are just five public macros:
One of the most frequently used components of Visio is the Organization Chart Wizard (OrgChWiz), but it is also one of the most frustrating because of its apparent inflexibility. I was recently asked how to use different table column names with the wizard because the originating ODBC source could not be touched. Well, I have previously used Access to modify and enhance tables in this situation, but the OrgChWiz is quite old, and does not like using the newer Access queries as a data source unfortunately. If the basic table column names do not match the default column names in the organization chart shapes, then there may be superfluous Shape Data rows created on each shape and the ability to change the shape style is compromised, and the Shape Data rows get quite confused!
[Read more…] about Aliasing Data Columns for Visio Organization Chart Wizard
The Organization Chart template opens with the Belts – Organization Chart Shapes stencil open by default, although the Master shapes used can be replaced with those on one of the other nine using the Org Chart / Shapes gallery:
I will be leaving soon for Atlanta to the MS Ignite Conference, but first I checked the latest schedule and found some additions and some slight title changes, so I have updated the documents provided in my last two posts:
MS Ignite Conference 2016 Sessions in Visio
Visio Sessions at MS Ignite Conference 2016
Also, I have produced a short, silent video of the process to import your own Ignite Trip Report.docx from the MS Ignite website to Visio.
See you in Atlanta!
I will be a co-presenter at the Microsoft Ignite Conference on 28th Sept. 2016 ( see Dive deep into advanced Data Visualization with Visio ) along with my fellow MVPs Scott Helmers and Ed Richard, and led by Sandeep Srivastava, from Microsoft. I am really looking forward to it because it will be a great opportunity to learn more about all of the exciting developments happening at Microsoft nowadays. Of course, I will also be showing off what we can do in Visio too, and to that end I have created a session location finder in Visio.
The MS Ignite Conference is an enormous 5 day event, with over 1300 sessions spread over three buildings and 5 floors. The conference website provides the opportunity to build your personal schedule, and to download a Word trip report. Unfortunately, this report does not include the rooms and the zone or building that they are in. Therefore, I used some of my facilities management experience and Visio to provide a multipage Visio document with building section and plans provide the location context for each session in my, or attendees, schedule.
The Visio document contains macros to import the Word report downloaded from the MS Ignite website, and for running a timer between a start and end time.
[Read more…] about Visio Sessions at MS Ignite Conference 2016
I have provided the Visio document for download*, so that it can be used by any attendees how have Visio Professional 2016 or Visio Pro for Office 365:
MS Ignite Trip Reporter.vsdm
I will explain how it all works in a future posting, but the document contains full instructions of how to use it, and it includes my current schedule of sessions so that it can be played with even by non-attendees.
*This document was updated with the up to date Session locations on 20 Sept. 2016
Today I demonstrated how Visio could be used for Facilities Management. I covered CAD integration, space chargeback, personnel and asset locations, and finished off with fire escape routes and equip.
[Read more…] about Visio for FM Session Recordings
You can register for see the recording, and get the pdf of the slide deck, at https://vts.inxpo.com/Launch/QReg.htm?ShowKey=27721 .
I have made some of the materials available from my OneDrive – Sample CAD file, Excel data and Visio Drawing : https://1drv.ms/f/s!AqkzN8kb1lAzlspZ6XOX4d-sI4royw
A screenshot of the Visio drawing