Data Visualizer for #Visio Pro for Office 365 – Part 2

I walked though the steps to create a Cross-Functional flowchart automatically from an Excel table in my last article ( Data Visualizer for #Visio Pro for Office 365 – Part 1 ), but I often prefer to use a relational data source, such as Access or SQL Server, to store and organise my data. Therefore, I describe how Excel‘s Get Data (nee PowerQuery) can be used to merge together the data in a relational data source as a single table suitable for Data Visualizer in Visio Pro for Office 365.

This slideshow requires JavaScript.

Read the rest of this entry »

Layer Manager add-in for Visio released

I use layers in Visio a lot. Maybe it is because I originally used CAD, and created facilities and cable management layouts linked to data. I know that some of my fellow Visio MVPS don’t use layers very much at all, mainly because they create process diagrams, I guess, but careful use of layers in a diagram can provide multiple views of the same base information. However, Visio has a more complex layering system than any CAD program that I used, so I have always created my own layer management tools. I have decided to package my utility together as an add-in that others may want to use too.

This slideshow requires JavaScript.

 

I have made some short videos explain the issue with layers in Visio, and how I solved it.

What’s the issue with layers in Visio?

Making it simple to toggle layer settings

Saving and recalling multiple layer settings easily

The add-in can be downloaded from my company website : LayerManager

I have put some licensing into the add-in, but 30 days are allowed for free.

Here is some of the genesis of this add-in : Toggling layers on and off

 

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.

This slideshow requires JavaScript.

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

 

Understanding Visio’s Color Formulas

I was recently exploring the ShapeSheet formulas available in Visio that affect colors, and I decided that I needed to make a shape that I can change the fill color, tint, shade and tone of dynamically. This allows me to copy the formulas from a Shape Data row value for pasting into a ShapeSheet cell.

ColorFormulas.gif

Read the rest of this entry »

Visio JavaScript API preview announced

Microsoft have just announced the availability of the new Visio JavaScript Api ( see Visio JavaScript APIs Preview). I presented this last week at the Artic SharePoint Challenge in Oslo where a number of developers took the opportunity to create data-linked Visio diagrams in Visio, and interact with them in SharePoint.

Here is an abbreviated version of my presentation, explaining the process of creating these dashboards from linking Visio shapes to data, to embedding in web pages …

https://docs.com/d/embed/D25191561-9906-7796-8140-000380829748%7eMb6c3d50e-c8b1-0436-94d4-2595cf51223f

2017-02-10_07-46-56.png

The future is looking much clearer now!

Visio @Artic SharePoint Challenge

I am pleased to announce that I will be presenting Visio and Visio Online at the Artic SharePoint Challenge near Oslo on 2nd/3rd Feb ( see arcticsharepointchallenge.com ). The theme is The Matrix, but I have not yet decided whether to take the red or the blue pill.

This slideshow requires JavaScript.

Visio Online is a ideal for embedding visual data diagrams in SharePoint. I hope to see some of you in Norway!

Opening an MS Access form from a Visio shape

This article describes how to open a Microsoft Access form at a specific record from a Visio shape. I was an Access developer before I was a Visio developer, and both of the applications have VBA to provide tactical solutions for everyday tasks. Fortunately, it is fairly simple to copy the VBA code from one application to another…

This slideshow requires JavaScript.

Read the rest of this entry »

davecra.wordpress.com/

Microsoft Office Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com 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

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...