I was privileged to be invited to the biennial Robins & Morton conference in Orlando recently, where I assisted in presenting TimeTable to the hundreds of attendees there. A single wall-hanger (OPS) TimeTable Visio diagram automatically drawn from #OraclePrimaveraCloud data, is a condensed version of the same data printed as a Gantt chart some six times taller, as shown in the image below (there wasn’t enough ceiling height to print all the Gantt):[Read more…] about TimeTable at RMConnect 2022
MSIgnite Sessions to Watch in Visio
Well, MS Ignite is over for another year. I planned to visit loads of sessions, but the reality was that I spent many hours on the Visio booth. Fortunately, many of them were recorded, including ours, but I don’t have time to watch over 700 videos! So, I looked through them all and picked out 50-odd, and used Get & Transform in Excel again to create suitable queries to link to Visio.
The more I use PowerQuery, the more I like it. I was able to extract the unique values in the Personas, Tags, and Products columns which each contained comma separated lists. I data-linked these values to large circles on different pages, and data-linked the Sessions to Watch to hexagonal shapes. I then wrote a little VBA code to link the circles to the hexagons with data-linked connectors. Data Graphics was applied to all shapes, including the connectors, and a legend added. Each of the Session hexagons have an automatically created hyperlink to the On-Demand Video. I used a standard radial page layout so that I had minimal manual movement shapes.
The end result is a visual dashboard by Persona, Tag and Product to open the videos for the sessions I want to watch.
Data Import and Export Features in Visio 2016 (and 2013)
One of my most viewed articles is about the data import and export features in Visio 2010 (see http://blog.bvisual.net/2011/05/24/data-import-export-features-in-visio-2010/ ), so I thought that I should do something similar for Visio 2016. In fact, there is very little change since Visio 2013 …. The download file contains VBA code that I used to connect the shapes together from the data recordsets.[Read more…] about Data Import and Export Features in Visio 2016 (and 2013)