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.