• 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
    • 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
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • VRA makes the case for Prudential
    • 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
      • 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➡
      • 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
    • Visio blog on Orbus website
    • 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

External Data

Published on April 11, 2019 by David Parker

Sorry about Brexit

In these days of political uncertainty in the UK, and our position in Europe or the world, there is only one thing that I can say: Sorry about Brexit … in every main language of the EU countries!

Sorry about Brexit
[Read more…] about Sorry about Brexit

Filed Under: External Data, Multi-Language, Visio Tagged With: Data Import, Excel

Published on March 7, 2019 by David Parker

Changing Visio Shape Size and Angle with Linked Data

I was recently laying out a computer room floor plan to scale in Visio, from survey data of the cabinets\racks within it, and it occurred to me that I could work a bit smarter than I first thought. Originally, I was going to just add lots of rectangles, size them, rotate them, and label each them with their name. Then I thought, why not use the Width, Depth and Name columns from the survey data to do most of the work for me? It was so simple to do, and only took a few minutes, so I thought I would share my methodology because it demonstrates how easy it is to work smarter with Visio….

These are the simple steps shown above, written out for your education….

[Read more…] about Changing Visio Shape Size and Angle with Linked Data

Filed Under: Excel, External Data, mFormula, ShapeSheet Formulas, Visio Tagged With: Shape Data, Shape Design, ShapeSheet, ShapeSheet Functions

Published on January 10, 2019 by David Parker

Replacing Images in Visio Shapes by Changing Data

I wrote an article last year about Swapping Images in a #Visio Shape manually, but I want to be able to do this whenever a Shape Data value changes. This is because I use I invariably use shapes linked to data. I also want to be able to have multiple images within a single grouped shape, and all of them changing when their referenced Shape Data values change. I believe that this will be more adaptable for a lot of scenarios than trying to repurpose Data Graphic Icon Sets ( see  Make Your Own Visio Data Graphic Icons Sets … automatically). I also discovered that the Shape.ChangePicture(…) function can just as easily work with urls as it can with network file paths, so even more possibilities are opened up! For example, the Visio Online JavaScript API has the ability to overlay an image (see ShapeView.addOverlay(…)).
So, I have created some macros to provide quick and easy selection, positioning and updating of images within a group shape.

personphotosbydata


I decided to present this article with VBA code rather than my preferred C# so that a stencil could be downloaded to provide instant usability, rather than having to install an add-in. It can be download from Image Utils.vssm, and should then be placed in to My Shapes folder, so that it becomes available to open in Visio. When it is opened, then the macros will need to be enabled.
There are just five public macros:

[Read more…] about Replacing Images in Visio Shapes by Changing Data

Filed Under: Excel, External Data, Geographic, Images, Org Charts, Shape Data, VBA, Visio Tagged With: Link Data to Shapes, Macros, ShapeSheet, VBA

Published on March 3, 2017 by David Parker

Managing People, Processes and Performance in PowerPoint? There is a better way!

I will be presenting a webcast on Thursday, March 23 | 12.00 to 13.00 (UTC) demonstrating how data-linked diagrams can provide a much more efficient and dynamic method for operational intelligence than PowerPoint.

Follow this  link to register : http://bit.ly/2m2sPOv
 

Filed Under: Data Graphics, External Data, Org Charts, Process Flows, SharePoint, Visio 2016, Webcasts Tagged With: Excel, Office365, Visio, Webinar

Published on August 12, 2015 by David Parker

Visualising SharePoint and SQL Data with Visio Professional

I will be venturing to the dark side of the moon on Saturday 12th September 2015 at SQL Saturday in Cambridge, UK ( see http://www.sqlsaturday.com/411/EventHome.aspx ).

[Read more…] about Visualising SharePoint and SQL Data with Visio Professional

Filed Under: External Data, Shape Data, SQL Server, Validation, Visio 2013, Visio Services Tagged With: SharePoint 2013, SQL

Published on May 27, 2015 by David Parker

Distributing Data Points Automatically on Maps in Visio

In my last article, I described how to calibrate a map in Visio ( see http://blog.bvisual.net/2015/05/26/calibrating-a-map-in-visio/ ), and in this article I use a calibrated map to distribute data points from a linked data source automatically.

For this example, I drew a simple shape at the size that I want, but you could add this smartness to any shape. All you need is an external data recordset that contains the Latitude and Longitude values that need to be linked to each data point.

image
[Read more…] about Distributing Data Points Automatically on Maps in Visio

Filed Under: Bing Maps, External Data, Geographic, Shape Data, ShapeSheet Formulas, Visio 2013 Tagged With: Link Data to Shapes, Shape Data, ShapeSheet Functions

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to Next Page »

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Two Quote or Not Two Quote …
  • Visio in Organizations
  • Viewing Visio Document Changes in Git
  • Visio ShapeSheet Functions D-F
  • Visio ShapeSheet Functions A-C

Categories

Tags

Accessibility Add-Ins Connectors Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript Layers Legend Link Data to Shapes MSIgnite Office365 Org Chart PowerApps PowerBI PowerQuery Processes Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint SharePoint 2013 SQL Teams Themes Validation VBA Video Visio Visio 2007 Visio 2013 Visio for the Web Visio Online Visio Pro for Office365 Visio Services Visio Viewer Web 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

  • LinkedIn
  • Twitter

Search this website

Recent posts

  • Two Quote or Not Two Quote …
  • Visio in Organizations
  • Viewing Visio Document Changes in Git
  • Visio ShapeSheet Functions D-F
  • Visio ShapeSheet Functions A-C

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