Connecting Visio and Excel Web Access controls in SharePoint 2013

I have recently been working on an FM project where I have spaces and personnel shapes in Visio floor plans data linked to Excel tables. I constructed a number of related tables in an Excel workbook and wanted to demonstrate the relationships. I decided that this is best explained with a combination of a diagram and sample data , so this article describes how to connect Visio and Excel web parts together in SharePoint 2013 web pages, without code.


First, I constructed an Excel Services workbook and a Visio Services document.

Excel Workbook Tables

The Excel workbook has a number of tables on similarly named worksheets.


Visio Diagram Shapes

I modified the Object Hierachy master shape, from the COM and OLE stencil, to include a Shape Data row called Table, and displayed the value of this as text.




SharePoint Web Part page

I then added the Visio Services diagram and Excel Services workbook into adjacent web part zones in a SharePoint 2013 web page.


The Visio Web Access control

I edited the Visio Web Access control to expose the Table shape data items to web part connections, and configured the connection between the two web parts to use this as the field name.


The Excel Web Access control

In fact, you can define the connection in either the Visio or Excel Web Access control, as the Connections menu option becomes available on each web part when there are suitable web parts in a page.


Note that the other option for the connection is to simply get the Workbook URL from Visio shape data item.


Setting up this web part page was actually quite simple, and really helps me explain the relationships and data. I can select an item in the Visio diagram, and the related worksheet is displayed in Excel.

It is unfortunate that it is not possible for me to publish the web page for public consumption …


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


O365 and SharePoint

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

Microsoft Power BI, Analysis Services, MDX, DAX, M, Power Pivot and Power Query

Azure Solutions for Office 365, and more...

Rob Fahrni



Life with Visio and other Microsoft Toys!

Nilsandrey's Weblog

Just another weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Smart graphics for visual people

%d bloggers like this: