I have previously written blog articles about using, and extending, the Microsoft supplied Data Graphic Icons Sets, but I never explicitly listed their variations in a useful visual table. So, here is one:[Read more…] about A Table of Visio Data Graphic Icon Sets
My earlier post about the world in Visio shapes, see http://blog.bvisual.net/2013/08/16/visio-map-of-the-world/ , has been one of my most popular, and a reader recently asked about changing the colour of countries by data not in my original worksheet, and another asked about adding labelled dots.
Well, at first, I thought it would be quite simple to add more Data Graphics with the Color By Value that I already had, but then I realised that I needed to adjust some of the shapes that I had created from SVG in my previous article.
The problem is that some of the country shapes which were converted from SVG have geometry at the top group level. This means that any Data Graphic items, other than Color By Value, are actually sub-shapes of the group and will be hidden by the country shape itself. That is probably why the Data Graphics task, on the selected Afghanistan shape below, sent the AF label over to the right of it, whereas all the group shapes with all their geometry in sub-shapes, such as the AE (United Arab Emirates) shape, placed the label in its centre.[Read more…] about Visio Map of the World Update
Following on from my previous post, http://blog.bvisual.net/2012/11/02/us-election-special-vector-visio-2013-icons/, I have saved the stencil that was generated in Visio 2013 back to Visio 2003 – 2010 format … and, guess what? All of the new Bezier Curves got automatically translated to Nurbs, which means they work! (Except for themes … but they can be coloured)
They can be downloaded from : tp://sdrv.ms/TlzoEB
Perhaps someone would like to make Data Graphic icons from them ? : http://blog.bvisual.net/2012/04/19/make-your-own-visio-data-graphic-icons-sets-automatically/
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.
Firstly, I entered the table in Sheet1 of a new Excel workbook and saved it.
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, but I have used it to provide an alternative breakdown by Department / Reports_To / Name.[Read more…] about Selecting Nodes in Visio PivotDiagrams
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.