Aliasing Data Columns for #Visio Organization Chart Wizard

One of the most frequently used components of Visio is the Organization Chart Wizard (OrgChWiz), but it is also one of the most frustrating because of its apparent inflexibility. I was recently asked how to use different table column names with the wizard because the originating ODBC source could not be touched. Well, I have previously used Access to modify and enhance tables in this situation, but the OrgChWiz is quite old, and does not like using the newer Access queries as a data source unfortunately. If the basic table column names do not match the default column names in the organization chart shapes, then there may be superfluous Shape Data rows created on each shape and the ability to change the shape style is compromised, and the Shape Data rows get quite confused!

This slideshow requires JavaScript.

Read the rest of this entry »

Free #Visio training videos

This blog of mine is all about Visio, and is aimed at intermediate, power users and developers. For the less advanced Visio users, or too back fill some skills, then please check out the free Microsoft Visio training available from here : Visio video training

Happy holidays!

PS Packt’s $5 sale is now on! Grab my title Mastering Data Visualization with Microsoft Visio Professional 2016 for just $5 at Packt $5 deal

 

Cyber Monday giveaway free #Visio Chess

Earlier today, I gave away checkers for Visio (see Cyber Monday free #Visio Checkers! ) , and now this article completes my Cyber Monday freebies with a downloadable chess set for Visio!

This slideshow requires JavaScript.

Read the rest of this entry »

Cyber Monday free #Visio Checkers!

As it is Cyber Monday, I thought I would give away a compelling checkers board for Visio! In the UK, we call it Draughts, but the rules are the same… in my last post, I showed how to create a chess/checkers/draughts board, and in this one I add some checkers that can glue to the dark squares only!

This slideshow requires JavaScript.

Read the rest of this entry »

What is the minimum number of rectangles in a #Visio chessboard?

This may sound like a simple question with a definite answer, but I think it is worthy of further explanation. I wanted to make a chessboard shape with as few lines as possible, because it makes the shape more efficient and easy to work with. Some might consider grouping 64 squares together, but that would be a very heavy shape. A chessboard needs to appear to have 64 squares, but the following shape only has 9 rectangles … How is this possible?

ChessboardRectangles

Read the rest of this entry »

Scroll to Capture #Visio ShapeSheets with #SnagIt

Anyone who develops with Visio faces the problem of viewing the formulas and values in an often difficult to navigate ShapeSheet window. I have been a SnagIt and Camtasia user for many years thanks to the generous free license I get from TechSmith as a Microsoft MVP. I have used both products extensively for my books, articles and videos, though I am not an expert in either product. Now, SnagIt has a panoramic scrolling capture feature that is great with ShapeSheets.

The unique smartness of Visio shapes comes from the ability to program the ShapeSheet behind every single shape. This is like an Excel worksheet divided into sections, and the display can switched between formulas and values. The Visio’s ShapeSheet window does have the ability to toggle the visibility of each section, but that is often not enough to get a complete picture of the formulas involved. The following example is the partial view of the ShapeSheet window for a simple shape.

ViewSections

Read the rest of this entry »

Installing 64-bit Visio 2016 Professional

There are times when it is necessary to install the 64 bit versions of Visio (and Office), as described at Choose between the 64-bit or 32-bit version of Office. This article does not really expand on the reasons for using 64 bit Visio, but it basically comes down to file size, especially with very large inserted CAD files. I set up a virtual machine to do some testing, and, as it has been a long time since I had to do this, I accidently installed the 32-bit version first, and so I had to start afresh. Therefore, I thought it might be useful to record the steps I took with the download of Visio Professional 2016 from my.VisualStudio.com/downloads. I have pointed to the link that should be followed.

This slideshow requires JavaScript.

Read the rest of this entry »

JackBinnall

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

davecra.wordpress.com/

Azure Solutions for Office 365, and more...

johnvisiomvp

Life with Visio and other Microsoft Toys!

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

Smart graphics for visual people