Filter Visio External Data to Drop Shapes

I have recently been demonstrating how to automatically drop data point shapes into the correct latitude \ longitude position over a map image in Visio, and in this instalment I show how to automatically filter the dropped data points by a rectangular area. This will only work after calibrating the map image as in my previous article and then using the Data Point shape (or similar) from

The principles of reading the Shape Data value from a selected shape to automatically drop rows from the active External Data window using the selected master shape could be applied to many scenarios.


Read the rest of this entry »

Distributing Data Points Automatically on Maps in Visio

In my last article, I described how to calibrate a map in Visio ( see ), 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.


Read the rest of this entry »

Calibrating a Map in Visio

Many years ago, I wrote a blog article about calibrating a map in Visio ( see ), but I used VBA and a shape from my friend Chris Roth / VisGuy. Well, I have now worked out how to calibrate a map without code!

This could be especially useful now that MapPoint has been deprecated Smile


Read the rest of this entry »

Review of Learning Bing Maps API

It is a pleasure to see this title appear because I have been developing with MapPoint and Bing Maps (nee Virtual Earth) for many years, but as an author too, I am aware how sensitive reviews are, so I am keen that any criticism should be constructive. My first impression is that it is slim at about 100 pages, but it does cover some very useful areas. The downloadable code is very useful but seems to be the draft version in parts, even being titled as such, and I did add my own Bing Maps developer credentials rather than use the ones left in the text.

First, here is the book link, and the chapter titles. I used Visual Studio 2013 to test the code and ran it in Internet Explorer, Chrome and Firefox on Windows 8.1.

Learning Bing Maps API Chapter 1: Introduction to Bing Maps AJAX Control Version 7
Chapter 2: Diving into Bing Maps AJAX Control Version 7
Chapter 3: Introduction to Bing Maps REST Services
Chapter 4: Diving into Bing Maps REST Services
Chapter 5: Spatial Data Services
Chapter 6: Diving into Spatial Data Services
Chapter 7: Enriching Bing Maps with Overlaying User Data

Read the rest of this entry »


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