bVisual

Visio

Published on by

Changing Visio Shape Size and Angle with Linked Data

I was recently laying out a computer room floor plan to scale in Visio, from survey data of the cabinets\racks within it, and it occurred to me that I could work a bit smarter than I first thought. Originally, I was going to just add lots of rectangles, size them, rotate them, and label each them with their name. Then I thought, why not use the Width, Depth and Name columns from the survey data to do most of the work for me? It was so simple to do, and only took a few minutes, so I thought I would share my methodology because it demonstrates how easy it is to work smarter with Visio….

These are the simple steps shown above, written out for your education….

[Read more…] about Changing Visio Shape Size and Angle with Linked Data

Published on by

Using Advanced Installer with Viso VSTO Add-Ins

I have written many add-ins for Visio over the years, some for private clients for use in-house, some as products for public release by my clients or by me, and some just to help me with my day-to-day Visio development tasks. The ease of installation is always an issue, and I have been using a digital certificate to guarantee its authenticity in almost all of these scenarios. I have also included licensing code from a third-party for some of my own products, but have been aware that the third-party product I have been using is not ideal because it needs its own registered component on the client machine. So, when a client asked that I use Advanced Installer to create the installation setups so that their licensing system could be used, then I was (and still am) all for it because it could become a better method for myself. However, there are some issues that I am overcoming through this transition ….not least that an apparently correctly assigned digital certificate was actually not valid.

InvalidDigitalCertificate
[Read more…] about Using Advanced Installer with Viso VSTO Add-Ins

Published on by

Prototyping Visio ShapeSheet Formulas in Excel

I am working on an application where the horizontal axis of the Visio page represents dates from left to right. In fact, the each of the fixed horizontal grids are 1 day, and I need to have shapes that understand the begin date at the left edge of the shape, and the end date at the right edge of the shape. There is, therefore, a number of elapsed days representing by the width of the shape. However, the underlying grid can either represent all days, or it can be changed to only represent weekdays by omitting the weekends. I struggled to find the best formula to calculate the elapsed days or weekdays between two dates in Visio ShapeSheet formulas, so I turned to Excel to provide an inspiration. The Visio ShapeSheet is modelled on the Excel worksheet, and formulas can be entered into the cells in much the same way. However, the available functions differ since Excel is mainly used for arithmetic and statistics, but Visio is used for graphics and data. In this article, I demonstrate how I used C# and Excel to construct and test formulas for use in a Visio shape.

[Read more…] about Prototyping Visio ShapeSheet Formulas in Excel

Published on by

Replacing Images in Visio Shapes by Changing Data

I wrote an article last year about Swapping Images in a #Visio Shape manually, but I want to be able to do this whenever a Shape Data value changes. This is because I use I invariably use shapes linked to data. I also want to be able to have multiple images within a single grouped shape, and all of them changing when their referenced Shape Data values change. I believe that this will be more adaptable for a lot of scenarios than trying to repurpose Data Graphic Icon Sets ( see  Make Your Own Visio Data Graphic Icons Sets … automatically). I also discovered that the Shape.ChangePicture(…) function can just as easily work with urls as it can with network file paths, so even more possibilities are opened up! For example, the Visio Online JavaScript API has the ability to overlay an image (see ShapeView.addOverlay(…)).
So, I have created some macros to provide quick and easy selection, positioning and updating of images within a group shape.

personphotosbydata


I decided to present this article with VBA code rather than my preferred C# so that a stencil could be downloaded to provide instant usability, rather than having to install an add-in. It can be download from Image Utils.vssm, and should then be placed in to My Shapes folder, so that it becomes available to open in Visio. When it is opened, then the macros will need to be enabled.
There are just five public macros:

[Read more…] about Replacing Images in Visio Shapes by Changing Data

Published on by

Power up your Visio diagrams

It’s a new year, and Microsoft Visio Online Plan 2 continues to be updated monthly. There is plenty to get excited about, for example, broken links in Data Visualizer can now be repaired automatically. Also, I am pleased to report that I have written a white paper on using Visio in Power BI effectively! This downloadable guide explains how to combine Visio drawing pages and Power BI data to create great interactive data visualizations, and can be requested from Power up your Visio diagrams.
preview-lightbox-cta-02
I will also be doing a webcast about this subject, so be sure to sign up for notification!

Published on by

My Surface Book 2 video connections

IMG_2888 (Edited)

I was tidying up my office recently, and came across an old magazine cover that I was on back in 1992. In those days, I was a consultant for a company called Isicad, and I am working on a £30,000+ Unix workstation. I have a small monitor for the Unify database on the left, and a large CRT monitor the CAD system, and a tablet with a stylus for interaction with the drawing. I also had more hair than I do now, which probably started going when I turned up to do some demos in Milan on a workstation that was supplied by the German arm of the company … only they didn’t leave a built one … just loads of boxes with parts, and that also included the circuit boards! I had to build it afresh whilst being instructed over the phone, and with my foot firmly hooked around the radiator because I didn’t have an earthing strap! Well, that picture started me thinking about my current workstation, which is a £3,000 Microsoft Surface Book 2, and how I have to connect to video displays nowadays!

I have been through many Windows Servers, PCs and laptops since 1992, but I think I had my first real desire for a particular model when I was over in Redmond for a conference and tried the Surface Book 2. I wanted one, but I had to wait for it to become available in the UK months later, and then a further few months because I wanted the 15″ screen with a Performance Base. I convinced myself that I needed that particular specification because of my continuous use of graphics, particularly with Visio. I was probably correct about that, but I honestly don’t detach the screen very much at all. So, I have the Surface Pen for freehand work on the screen, which I do use now and then, and the Surface Dial, which I only use for scrolling web pages and the audio volume. Maybe one day I can use it Visio… I also have a Microsoft Designer Bluetooth Mouse, which I like because I am allergic to the rubber wheels on most mice, but this one has hard plastic.
The Surface Book 2 is supplied with a power adaptor that has another USB-A port to add to the two USB-A ports on the left, and one USB-C on the right of the base. Well, I couldn’t connect to any external monitor or to a wired ethernet cable, so I forked out for a Surface Dock, which is a monster with a power adaptor and a separate hub with 4 USB-3.0 ports, 2 Mini Display Ports, 1 audio out, and 1 Gigabit ethernet port. I have been stopped several times at the airport with this unit because it looks very suspicious to the border officers when it goes through the X-ray!
So, if I am traveling and want to connect directly to an external monitor, I have two choices. I can take the Surface Dock, a Mini DisplayPort to HDMI, and an HDMI cable, or I can take the Surface power adaptor and a USB-C to HDMI cable that I bought from Uni Accessories via Amazon! You can see the difference below, and I can feel it in my laptop bag too!

[Read more…] about My Surface Book 2 video connections