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!

More secrets of the Visio Legend shape

I was going to do a full post on the special Legend shape in Visio that can automatically count instances of masters on a page, then I found that my good friend Chris Roth, aka VisGuy, had done one some years ago ( see visguy.com/…/legend-shapes). However, I have some extra information that will assist in getting the functionality to work consistently.

Basically, you can make any Master work with the Legend shape by adding the User.visLegendShape = 2 setting into a Master shape, but there are caveats.

  1. If the name of a Master is changed, then any existing shapes on the page must be re-placed
  2. The BaseID of each Master must be unique
  3. If the BaseID is changed (using NewBaseID), then any existing shapes on the page must be re-placed

To demonstrate this, I used the Good and Bad icon shapes from the Legend Shapes stencil.

This slideshow requires JavaScript.

Read the rest of this entry »

Visio @ASPC Update

My stint at the Artic SharePoint Challenge is nearly over …. I will be leaving the mountains near Oslo for the UK in a couple of hours, but the teams will continue with their SharePoint and CRM coding for another day. Such dedication! Still, I can always go out side to cool down, and contemplate:

wp_20170202_14_39_10_pro

In the meantime, I have enjoyed spreading the knowledge of data-linked Visio diagrams in SharePoint Online to a bunch of geeks who know so much more than me about SharePoint!

I hope they now know more about the capabilities of Visio….

Anyhow, here are some Theta360 shots from the hackathon:

ASPC Presentation #theta360uk

Artic SharePoint Challenge Judges #theta360uk

Artic SharePoint Challengers #theta360uk

Contemplating the Artic SharePoint Challenge… #theta360uk

I set a challenge to create a data linked Visio diagram in SharePoint for people popping red or blue pills ….

2017-02-03_15-39-12

Each of the pills are an instance of a single Master, and are linked to two recordsets using Excel Services that provide the personnel data (and hyperlinks) and the pill colour they chose. The position and rotation of each pill is from a random ratio in the Excel worksheet. All of these details, position and rotation are automatically refreshed in the Visio diagram if the Excel workbooks are updated.

Next week, I will talk more about the content 🙂

 

 

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

davecra.wordpress.com/

Microsoft Office 365 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 ...