• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • Visio Shape Report Converter
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Using Visio in Education for GIS
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Visualize Complex Processes with Microsoft Visio
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network
You are here: Home / Visio / Visio 2010 / Clusters and Workstations Linked to Excel using Visio Professional

Published on January 12, 2013 by David Parker

Clusters and Workstations Linked to Excel using Visio Professional

I was recently asked how to easily link an Excel worksheet that contains names of personnel sitting at workstations in clusters to a Visio floor layout. My own approach would probably have been to create an Access or SQL Server database, but I recognise that not everyone is confident about doing that, so I present a way that it can be done simply with just Excel.

The extra complication requested was the ability to easily control the visibility of specific data, so I have added an example of that into the mix.

Firstly, I mocked up a table in Excel. I decided to have separate Cluster and Workstation columns, and so I combined the two together in a column headed Location with a simple formula. I like doing this because I can then create a Pivot Table or Chart easily to give a count of workstations per cluster. I used the 1970 FA Cup winning Chelsea team for the Name and Department columns.

image

I then used Link Data to Shapes to select this Workstations worksheet, and dragged a row onto a simple rectangle shape. This automatically creates Shape Data rows labelled the same as the Excel worksheet column headers.

image

I modified the default Data Graphics in order to get the text values nicely aligned left, center, and right. Notice that I used the Text callout that can display the Label as well as the Value, for the left and right, but have chosen not to display the label, but did reverse the label position for the Location value. In fact, I had to put a space in the Label, thus overwriting [Default], to prevent the value from displaying on the left. I used Heading 2 for the Name value. I changed the Border Type to None for all three values.

image

So far, I have got the values that I want displayed. Now I added three Shape Data rows manually to the page. All three are defined as Boolean, when means TRUE or FALSE. If you do see the Name on the Define Shape Data dialog, then you tick Run in developer mode from File / Options / Advanced.

image

I then went back to edit my Data Graphic items so that I can control the display of each of these values. The Field dialog can be opened from the More Fields… option in the Data Field drop-down list.

image

In each case, I manually edited the formula to only display relevant value if the page Shape Data row was set to FALSE. (i.e. do not hide the value):

=IF(ThePage!Prop.HideLocationLabels,””, {Location})

Therefore, the user can select which labels to hide easily:

image

Finally, duplicated my rectangle to provide one for each row in my Workstation table, and dragged and dropped each row onto an individual rectangle. I then grouped the workstation rectangles for each cluster into a Container, and labelled it accordingly.

image

I now have data linked rows for each workstation in each cluster. These can be placed over the top of any actual desk layout, that might even be an embedded CAD file. Now whenever the Excel worksheet is updated, the Visio diagram just needs to be refreshed.

Related

Filed Under: Visio 2010

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio
  • Grid Snapping Revisited

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript LayerManager Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Setup and Deployment Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Validation VBA Video Visio Visio 2007 Visio for the Web Visio Online Visio Services Visio Viewer Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • Amazon
  • E-mail
  • Facebook
  • LinkedIn
  • Twitter
  • YouTube

Search this website

Recent posts

  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio
  • Grid Snapping Revisited

Copyright © 2025 · Executive Pro on Genesis Framework · WordPress · Log in