bVisual

Visio 2013

Published on by

Making unused data-linked SharePoint columns in Visio invisible automatically

I described how and why I sometimes link a SharePoint document library to Visio documents in a previous article ( see http://blog.bvisual.net/2015/02/10/displaying-sharepoint-document-library-column-values-on-visio-services-diagrams/). I mentioned that I always switch off the visibility of some columns because they are rarely needed in my Visio shapes as shape data rows. In this article, I present a VBA macro that can switch them off for you, therefore ensuring consistency.

The Link Data to Shapes feature in Visio does not allow for filtering of columns or rows when SharePoint lists are used as a data source. One answer is to create a view of the list in SharePoint to restrict the rows and some columns, but other columns still get pulled through to the External Data recordsets in Visio by default:

image

[Read more…] about Making unused data-linked SharePoint columns in Visio invisible automatically

Published on by

Updating the file path of data linked Excel tables 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.

image
[Read more…] about Updating the file path of data linked Excel tables in Visio

Published on by

Displaying SharePoint Document Library Column Values on Visio Services Diagrams

It is often useful to be able to link text or graphics to the values in the SharePoint document library that a Visio diagram is stored in. A SharePoint Document library is just a list with columns and Visio 2013 documents can be linked to the data in SharePoint lists … and it will be automatically refreshable. This means that Approval Status changes, for example, can be displayed as text or icons. This article goes through the methodology of linking data from the SharePoint document library to the Visio document.

[Read more…] about Displaying SharePoint Document Library Column Values on Visio Services Diagrams

Published on by

Visio for Mac ? Well, not really ….

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.

[Read more…] about Visio for Mac ? Well, not really ….

Published on by

Using SharePoint Choice Columns with Visio Services

Back in March 2014, I wrote about mapping SharePoint Column Types to Visio Shape Data Types ( see http://blog.bvisual.net/2014/03/03/mapping-sharepoint-list-columns-to-visio-shape-data-types/ ), and I skipped over the remaining SharePoint column types that could not be directly mapped. I described Rich Text previously ( see http://blog.bvisual.net/2014/11/14/using-sharepoint-rich-text-multiple-line-columns-with-visio-services/ ), and in this article I describe some of the possibilities of using the SharePoint Choice column type.

There are three different options for Choice columns in SharePoint 2013, but only the third, Checkboxes, allows for multiple selections.

image
[Read more…] about Using SharePoint Choice Columns with Visio Services

Published on by

Announcing visViewer 4th edition … and why I did it

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.

image
[Read more…] about Announcing visViewer 4th edition … and why I did it