map 0 top image  
Follow @sandrilaLtd Tweet

Articles about Microsoft ® Office Visio ®

Paying my dues

First of all I need to pay my dues to the other Visio websites, blogs and forums, so, in no particular order: MCC11 logo

Links to all the Visio articles

Various useful formulae for use in Visio shapesheet cells

  • Resizing shape's width with text:
    Set cell Width = GUARD(TEXTWIDTH(TheText))

  • Resizing shape's width with text, but with a minimum size (10mm in this case):
    Set cell Width = GUARD(MAX(TEXTWIDTH(TheText), 10mm))

  • Resizing shape's height with text:
    Set cell Height = GUARD(TEXTHEIGHT(TheText,Width))

  • Resizing text with the shape:
    Set cell Character -> Size = 10 pt*Height/0.75 in

  • Resizing text with the shape (with minimum and maximum values):
    Set cell Character -> Size = MIN(48 pt, Max(4 pt,10 pt*Height/0.75 in.))

  • Level text - text that is always horizontal, sometimes called 'gravity text':
    Set cell Text Transform -> TxtAngle = -ANG360(Angle)

  • Using an Action to toggle a cell
    1. Create a section -> Actions
    2. in the Menu cell add the text that you want to appear on the shape's right click menu (typically set the text to "Toggle")
    assume we wish to toggle cell "User.Toggle":
    3. in the Action cell add the formula =SETF(GetRef(User.Toggle), NOT(GetRef(User.Toggle)))
    Now when we select Toggle on the shape's menu the value in cell User.Toggle will alternately be TRUE and FALSE.

How-to articles

How to remove extraneous layer information from a shape master

(Instructions for Visio 2003/Visio 2007 - for Visio 2010 the menus are different)
  1. Load the stencil, put into edit mode, open the master
  2. Select the shape's contents (Control-A)
  3. menu Format -> Layer
  4. If you are now asked to enter a leyer name then the shape has a blank layer name! Enter a name (anything - it will be removed later) and press OK
  5. On the Layer dialog click None then OK
  6. menu View -> Layer Properties and tick Remove Unreferenced Layers, then click OK
  7. Close the shape, click OK to update the shape
  8. When done, close the stencil.

3rd-party additions for Microsoft Visio

There are various lists available of 3rd-party Visio stencils and add-ons, all of which seem to be totally out of date and full of dead links. I shall endeavour to keep this list up to date, please inform me of any changes or additions. Email me

Comments:

Add comment on this article
filler Home filler | filler Site Map filler | filler Privacy Policy filler | filler Contact Us filler  
Sandrila Ltd. Summerstead House, Holly Close, Eversley, Hampshire, RG27 0PH, United Kingdom.
Phone: 0118 973 3202 (Int. +44 118 973 3202). 		Copyright © 2009-2013 Sandrila Ltd. All rights reserved.