I like linking data to shapes in Visio. It saves time in filling in Shape Data and adding text, or any Data Graphic to them. Basically I am lazy, and I also like to create macros for repetitive tasks, so in this blog I provide two macros to save the drudgery of two tasks I do so often:
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 https://blog.bvisual.net/2015/05/26/calibrating-a-map-in-visio/ and then using the Data Point shape (or similar) from https://blog.bvisual.net/2015/05/27/distributing-data-points-automatically-on-maps-in-visio/
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.
Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI
Microsoft Office 365 Development, and more...
Automate, Accelerate, Accurate
Life with Visio and other Microsoft Toys!
Windows Server Essentials Tips & Tricks
Just another WordPress.com weblog
be smart, be clear, be visual ...
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.
Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio
Tips & Tricks around Mapping and Cloud Computing
be smart, be clear, be visual ...
