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.
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 http://blog.bvisual.net/2013/07/08/mvp-sessions-for-getting-started-with-visio-2010/
A Visio user recently asked how to add a salary amount for an Org Chart person automatically, based on their selected Level. I thought it was a bit long to answer in the forum, so I have written my answer below. It demonstrates how you can have your own custom template that works with the Organization Chart add-on in Visio.
My approach to creating a custom template that still uses the Organization Chart Add-On is to create a new drawing from the built-in template, and then to add extra properties to it.
First, select Show Document Stencil to view all of the local copies of the built-in master shapes. If they are not there, then simply drag and drop them from the built-in stencil on to the first page, and then delete the shapes on the page. This will not delete the local copies of the masters.
[Read more…] about Creating a Custom Org Chart Template with Extra Properties
I have been creating roadmaps in Visio lately, and the client is only concerned with the months and years, so I thought it would be sensible to use a Date Format Picture to display only the month and year in the Shape Data window. What I did not expect is that the mere existence of this Date Format Picture would alter the actual date stored in the cell. In this blog, I layout my concerns about the Calendar popup that is provided for Date type Shape Data rows.
In the following example, I have created a shape, coloured pale orange below, and added 25 Date type Shape Data rows. I have not applied any format to Property1, but then I have applied each of the 17 suggested Date Format Patterns provided on a drop-down list in the Define Shape Data dialog. Finally, I added a further 7 patterns manually. I then selected Today as the value for every single Shape Data row:
In my previous two articles, I described how to have 6 icons in a Data Graphic Icon Set, and provided some VBA code to make your own icons sets from existing Visio shapes or images. One thing that I overlooked was the Insert Legend command in Visio 2010, because it does not add the sixth icon automatically, so this blog describes how to add it. As a side effect, the code also enables the legend labels of icon and CBV (Color By Value) items to be edited.
When you use the Insert Legend command, it examines the Data Graphics used on the active page, to create legends for each Icon Set or Color By Value settings that it finds. Closer examination of the legend shapes, shows that an instance of the Icon Set master shape is added for each of the icons found.
In my last post, I showed how you can actually have up to six icons in a Visio Data Graphics Icon Set ( see http://davidjpp.wordpress.com/2012/04/11/how-to-have-six-icons-in-a-visio-data-graphic-icon-set/ ), and I finished by saying that I would now show how to create new icon sets from existing shapes … automatically. In fact, I will show you how to do it with existing SmartShapes or with images.
I was asked to make KPI icons from six weather images:
