• 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

Excel

Published on March 28, 2025 by David Parker

Merging Linked Data from Similar Tables

I was recently asked how to link data from different tables but with similar column names to Visio shapes. In this case, each table has the same unique identifier, but some of the column names are the same. The problem is that the data linking matches the column name with the label of a Shape Data row label, so the shared columns were updated with the values from the last linked data recordset. In this article I present a simple way that this restriction can be overcome.

[Read more…] about Merging Linked Data from Similar Tables

Filed Under: Excel, External Data, Shape Data, Visio Tagged With: Excel, External Data, Link Data to Shapes, Shape Data, Visio

Published on December 5, 2024 by David Parker

Optimize Visio Flowcharts: Swimlane Reordering Tips

Microsoft Visio desktop Plan 2 and Professional editions provides the ability to create and synchronize cross-functional flowcharts between the diagram and an Excel table. This is great, and widely used for many types of processes. The Excel table normally has a Function / Swimlane column that contains text that becomes labels on the swimlane containers, and a Phase / Timeline column that contains text that becomes the label of the phase or separator containers. The import provides the option to order the diagram by Function and/or Phase, but it is impossible to get them ordered by both! This article provides a solution using a free macro-enabled Visio stencil.

  • Excel table with Function and Phase columns
  • Visio Data \ Create from Data
  • Step 2 More Options to order by Phase
[Read more…] about Optimize Visio Flowcharts: Swimlane Reordering Tips

Filed Under: Data Visualizer, Excel, Process Flows, VBA, Visio for Desktop Tagged With: Data Visualizer, Excel, Processes, VBA, Visio for the desktop

Published on August 30, 2022 by David Parker

Visio Shape Report Converter Excel add-in available

I am delighted to announce that I have just had my first Excel add-in accepted in the Office Add-ins Store! It is called Shape Report Converter because all it does is convert a Shape Report converted from Visio for Desktop to a modern Excel table with one click!

It isn’t a complicated add-in, and it doesn’t do anything that you can’t do manually, but it does save time, and ensures consistency … and it is free!

[Read more…] about Visio Shape Report Converter Excel add-in available

Filed Under: Excel, Products, Shape Data, Shape Report Converter, Shape Reports, Visio Tagged With: Excel, Shape Reports, Visio

Published on August 23, 2022 by David Parker

Binding Visio and Excel with Data Visualizer

I re-vamped some of my content about the Visio Data Visualizer add-in for Excel in my last post, so I thought I should expand a bit more on the Data Visualizer feature in Visio for Desktop (Visio Plan 2) and Excel for Desktop. I have described it in detail in previous posts, but I never published the process diagram I created for the Data Visualizer Wizard in Visio. So, I thought I would use it to demonstrate a few cool features of Visio for Desktop.

[Read more…] about Binding Visio and Excel with Data Visualizer

Filed Under: Data Visualizer, Excel, PowerPoint, SS Plus, Visio, Visio for Desktop, Visio for M365 Tagged With: Data Visualizer, Excel, PowerPoint, Visio, word

Published on August 22, 2022 by David Parker

Editing Visio Data Visualizer in Excel

I have previously described how to use the Visio Data Visualizer add-in in Excel, but I didn’t make it clear how you can edit the diagram created if you have a Visio license. So, I have recorded three short videos to briefly explain this.

[Read more…] about Editing Visio Data Visualizer in Excel

Filed Under: Data Visualizer, Excel, Visio, Visio for Desktop, Visio for M365, Visio for Web Tagged With: Data Visualizer, Excel, M365, Visio

Published on November 5, 2021 by David Parker

Spotting Custom UI Errors in Visio Add-ins

I have written many COM and VSTO add-ins for Visio, but got confused when a client recently reported that the following Custom UI Runtime Error was appearing. I wasn’t getting the same error on any of my test laptops, so I chatted with my good friend, and fellow Visio MVP, John Goldsmith ( John Goldsmith’s visLog (typepad.co.uk) ). He gave me an excellent tip….

[Read more…] about Spotting Custom UI Errors in Visio Add-ins

Filed Under: Uncategorized Tagged With: Custom UI, Excel, Ribbon, Visio

  • Page 1
  • Page 2
  • Page 3
  • Interim pages omitted …
  • Page 5
  • Go to Next Page »

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Co-authoring and Commenting with Visio Documents
  • 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

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

  • Co-authoring and Commenting with Visio Documents
  • 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

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