I am working on a project where I thought the US State flags might be useful, so I quickly created a new master shape from the images in Wikipedia. The shape simply provides a selection of one of the states from the Shape Data window (plus one extra for the reverse of Oregon’s flag!).
The flag shape has a couple of Shape Data rows:
ShapeSheet Formulas
New book available for pre-order : Mastering Data Visualization with Microsoft Visio Professional 2016
I have a new book on Visio coming out in June called Mastering Data Visualization with Microsoft Visio Professional 2016. It covers the ins and outs of data with Visio!
Please visit http://bit.ly/1SeVfwW for more information.
Packt Publishing are currently running a deal on my last book, Microsoft Visio 2013 Business Process Diagramming and Validation , until 12th April 2016:
Follow this link : 1LHNDwI
Displaying the Fill and Line Section Values of a shape
A few years ago, I wrote an article about displaying the RGB value of shapes ( see http://blog.bvisual.net/2010/04/22/displaying-the-rgb-values-of-shapes ). I had forgotten about it, but a reader recently asked if it was possible to force the Foregnd field to display the RGB value for the standard color palette values. For example, red is number 2 in the palette, and has a value of RGB(255,0,0). In revisiting the article, I realised that there is a smarter way to display the values, without the need of any macros.
I simply created a master shape that exposes each of the cells in the Fill and Line sections as Shape Data rows. This allows me to enter values in the Shape Data window and see the effect on the shape immediately. So, it was easy to drop one shape, insert text fields, and then use the Array Shapes tool to layout the shapes. Finally, I just entered the the standard color map numbers 0 to 24 in the FillForegnd Shape Data row.
[Read more…] about Displaying the Fill and Line Section Values of a shapeImproving the legend of multi-data Data Graphic items in Visio
Data Graphics in Visio Professional (and Premium) are a great way of surfacing the information in each shape, but it can be easy to forget what the Color By Value, Icon Sets or Data-bars represent:
[Read more…] about Improving the legend of multi-data Data Graphic items in VisioDistributing Data Points Automatically on Maps in Visio
In my last article, I described how to calibrate a map in Visio ( see http://blog.bvisual.net/2015/05/26/calibrating-a-map-in-visio/ ), and in this article I use a calibrated map to distribute data points from a linked data source automatically.
For this example, I drew a simple shape at the size that I want, but you could add this smartness to any shape. All you need is an external data recordset that contains the Latitude and Longitude values that need to be linked to each data point.
[Read more…] about Distributing Data Points Automatically on Maps in VisioUsing SharePoint Choice Columns with Visio Services
Back in March 2014, I wrote about mapping SharePoint Column Types to Visio Shape Data Types ( see http://blog.bvisual.net/2014/03/03/mapping-sharepoint-list-columns-to-visio-shape-data-types/ ), and I skipped over the remaining SharePoint column types that could not be directly mapped. I described Rich Text previously ( see http://blog.bvisual.net/2014/11/14/using-sharepoint-rich-text-multiple-line-columns-with-visio-services/ ), and in this article I describe some of the possibilities of using the SharePoint Choice column type.
There are three different options for Choice columns in SharePoint 2013, but only the third, Checkboxes, allows for multiple selections.
[Read more…] about Using SharePoint Choice Columns with Visio Services