A Visio Logic Gate with Logic

I was recently asked how I would approach improving the Logic Gate 2 in the Circuits and Logic template, on the Analog and Digital Logic stencil. Well, this had resonance with me because I had often wondered why these shapes were not smarter than they are, so I looked more deeply into the shape construction to see how the Logic Gate 2 shape works, and how it could be improved so that the values of the inputs could be set and the logic applied to provide the correct output value. Eventually, similar improvements can be applied to all of the master shapes so that the connected logic diagram responds to input value changes.

The Existing Shape

The Logic Gate 2 shape has Shape Data rows to provide some configuration. Firstly, you can change the number of inputs from 2 to 5, and the number of outputs from 1 to 3:


Read the rest of this entry »

Using Visio Stacked Bar Charts

A Visio user asked recently about data binding a table like the following as a stacked chart. The question was a little imprecise about how, so I shall present a few alternatives.

Region Q1 Q2 Q3 Q4
Rg1 45 12 35 45
Rg2 12 24 45 36
Rg3 78 36 45 71

Firstly, I entered the table in Sheet1 of a new Excel workbook and saved it.

Read the rest of this entry »

Creating Shape to Page Hyperlinks Automatically using Link Data to Shapes

I demonstrated how to import hyperlinks into Visio shapes in a previous post – see https://blog.bvisual.net/2007/11/15/importing-hyperlinks-into-visio-shapes/, however, one of my readers wanted to know if the same mechanism can be used to create an hyperlink to another page in the same Visio document, rather than to an external web page. Well, it can be done … with a little preparation.

The Link Data to Shapes feature will by default only create external links because it pushes values from designated Shape Data fields into Hyperlink rows. You can designate Shape Data columns by ticking the Data Type / Hyperlink checkbox:


Read the rest of this entry »

Multiple Selection Methods for Visio Diagrams

Much as I love using Visio, I have always felt that there are a few selection methods missing, and I often have to some extra buttons into solutions to make up for this. There are many types of diagrams that have shapes connected to each other, usually with a connector shape, and the user needs to be able to traverse these connections quickly and easily, so I have created a Visio 2010 add-in, multiSelect, that adds a lot of different selection methods that are accessible via an extra ribbon tab when ever a shape is selected.


Read the rest of this entry »

Selecting Nodes in Visio PivotDiagrams

Microsoft Visio 2007 introduced PivotDiagrams to Visio Professional, and continues unchanged in Visio 2010 (see http://office.microsoft.com/en-us/visio-help/create-a-pivotdiagram-HA010357089.aspx ). These diagrams are a great way to analyse and visualize data by allowing you to breakdown data in a similar manner to PivotTables and PivotCharts in Excel. Any one who has both Microsoft Project and Visio installed will have seen that all of the extra diagram reports are in fact Visio PivotDiagrams. However, I have always found that selecting the nodes you want is difficult. In this article I will explain the problem and provide a solution … a new free add-in called PdSelect.

Update : Added new features 20 Jul 2012

In the following example PivotDiagram, I used the built-in OrgData Excel workbook as the data source. This example workbook is normally used to demonstrate the OrgChart Wizard (see http://office.microsoft.com/en-us/visio-help/demo-automate-your-org-charts-with-visio-HA001092948.aspx and https://blog.bvisual.net/2009/02/24/creating-an-org-chart-without-the-org-chart-wizard/), but I have used it to provide an alternative breakdown by Department / Reports_To / Name.


Read the rest of this entry »

Automating Page.DropLegend in Visio 2010

Visio 2007 introduced Data Graphics but, in my opinion, didn’t provide any automatic legends for the icons and colour by value options. That is why I wrote DataLegends (see http://www.bvisual.net/Products/DataLegends.aspx ) as an add-in for Visio 2007 several years ago. This oversight was remedied in Visio 2010 when Microsoft introduced their own legends (which were not totally dissimilar to my own), and also added a method (Page.DropLegend) for programmers to automate this task.


Read the rest of this entry »

MVP Sessions wheel

I wasn’t sure whether to call it a wheel or a clock-face, but since there are 24 MVP Visio 2010 sessions (see http://visio.microsoft.com/mvpsessions )  I decided on a wheel … so in this blog I present my alternative interface into these sessions, created in Visio of course!

I created an Excel workbook in which I listed all of the sessions, their descriptions, and links to the video and any supporting files. I then created the wheel diagram, and used Link Data to Shapes to automatically add Shape Data rows and hyperlinks to each shape, and Data Graphics to automatically colour each shape.

Finally, I saved the Visio page as web pages (VML, XAML and SVG format output), and as pdf.


Open the VML web output : http://www.bvisual.net/resources/mvpsessionsIE.htm

Open the SVG web output : http://www.bvisual.net/resources/mvpsessions.htm

Open the XAML web output : http://www.bvisual.net/resources/mvpsessionsX.htm

Open the Visio file : http://sdrv.ms/NYHH8V

Open the Excel file : http://sdrv.ms/OI3EKU

Open the pdf : http://sdrv.ms/OI2i2I

UPDATE : see https://blog.bvisual.net/2013/07/08/mvp-sessions-for-getting-started-with-visio-2010/

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


Microsoft Office 365 Development, and more...


Automate, Accelerate, Accurate


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

Smart graphics for visual people

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...