Back in 2012, my fellow Visio MVPs, Scott Helmers and Chris Roth, and I recorded a series of 24 videos about Visio 2010. They were first hosted on Microsoft’s web site, then they put them up on YouTube, they they got deleted :-(. Well, we have managed to retrieve them, and put them back up on YouTube in a new list :-). Most of them are still very relevant and useful!
I like linking data to shapes in Visio. It saves time in filling in Shape Data and adding text, or any Data Graphic to them. Basically I am lazy, and I also like to create macros for repetitive tasks, so in this blog I provide two macros to save the drudgery of two tasks I do so often:
- Dropping and data linking a number of items from an External Data recordset filtered by values in a column or columns
- Connecting shapes together following a parent-child relationship between Shape Data values
Many years ago, I wrote a blog article about calibrating a map in Visio ( see http://blog.bvisual.net/2008/09/30/moving-between-visio-and-kml/ ), but I used VBA and a shape from my friend Chris Roth / VisGuy. Well, I have now worked out how to calibrate a map without code!
This could be especially useful now that MapPoint has been deprecated[Read more…] about Calibrating a Map in Visio
Link Data to Shapes in Visio (not the Standard edition though) is great for visualizing information, and I often use a multi-worksheet Excel workbook that I create locally, and then wish to re-link to a copy of the workbook elsewhere, or even in Office365. This is a simple task if there are only one or two Excel tables involved, but can become tedious when there are many. So, this blog is presents an semi-automated method of achieving this.
Firstly I have an Excel workbook that I have many worksheets with tables of data on them. I named each worksheet, and used the Format As Table command on each.[Read more…] about Updating the file path of data linked Excel tables in Visio
My fellow Visio MVP, John Marshall (see https://johnvisiomvp.wordpress.com), pointed out recently that Lucid Software claim to have a Visio for Mac application that offers import and export of real Visio files. Well, although I would love to have a web-edition of Visio from Microsoft, I was interested to discover if the claims are true … so I signed up for a trial. I present my findings below, based on just one Visio document that I have used in this blog before ( see http://blog.bvisual.net/2013/07/08/mvp-sessions-for-getting-started-with-visio-2010/ ). My conclusion is if you use Visio for high quality vector graphics or for any type of business intelligence then wait for Microsoft to do it right! Please do not even consider round tripping Visio files to Lucidcharts and back, because you will be extremely disappointed.
Sometimes I get really frustrated with Microsoft. They have a really great data-diagramming product with Visio, which they bought for the largest amount that they had ever paid for an acquisition at the time in 1999, but they have not succeeded in marketing the virtues of visual data to most of the Office community. I have always thought that one of the reasons for that is a misguided belief that you should not be able to make good use of Visio diagrams without purchasing Visio. My evidence for this is the lack of data, and sometimes hyperlinks, that are with each shape in the various outputs such as XPS, PDF, and Save As Web. For me, this is a missed opportunity because each of these formats could include data and multiple hyperlink support for each shape. Indeed, it should have been relatively simple for Microsoft to integrate Visio better with Word, Excel and PowerPoint … and I mean graphics and data, not just dumb pictures.[Read more…] about Announcing visViewer 4th edition … and why I did it