Articles tagged with: Formulas
Are you developing Visio solutions that will be used across the Globe? Have you experienced strange behavior using ShapeSheet functions like INDEX, LOOKUP, SUM, RGB or others that involve lists of items?
If so, then you, …
Do you have shapes that contain multiple colors that you’d like to easily change?
Wouldn’t it be neat to be able to specify those colors in Shape Data fields, along with other parameters for the shape?
Visio’s …
Learn how to create a bar-graph Visio shape which visually responds to data. Once you’ve built this SmartShape, we’ll then show you how to link it to external data imported from Excel!
Learn about an exceptional Visio SmartShape: a shape that allows you to define your own Multi-shape. With the Configurable Stickman, you can define up to five different poses that can then be quickly recalled with the click of a mouse!
Learn about the benefits of Visio SmartShapes, the power of the ShapeSheet, and how a few parameterized Visio shapes can replace a whole set of “dumb” clip-art symbols!
In our last article on smart frames, we built a SmartShape that maintained a constant border-thickness, no matter the size of the shape.
It was a fairly simple frame, it got the job done, but it …
Download and enjoy this multi-featured Visio SmartShape of a Microphone, submitted by one of our users!
Learn how to parameterize your Visio SmartShapes by using ShapeSheet formulas to control Geometry. In this first article in a series, you’ll build a frame shape which maintains a constant border-thickness when the shape is resized!
Learn how to add smarts to your Visio SmartShapes–and have fun doing it–by looking at mischievous examples of badly behaved, not-so-smart shapes!
If you’ve ever drawn arcs in Visio, then grouped them together, you may have noticed that they behave oddly when you resize the group. In this article, we’ll explain why this happens and how to fix it. You’ll also learn about the two shape interaction styles that Visio shapes have: 1D and 2D shapes!
Visio doesn’t have an option to resize shapes such that they remain on-center. But the free shapes in this article do!
Learn how to create interesting visual effects while uncovering the capabilities of Visio’s ShapeSheet and the Smart Shapes it enables you to create. This article shows you how to create a wintry scene with Smart Trees that fade into the distance as you reduce their size.
Learn how to take a strip of icons and turn it into a Visio multi-shape. Your new “Film Strip Shape” will react to right-mouse clicks or shape data values to show one of the icons. You’ll also learn how to convert these shapes into Icon Sets for use with Visio 2007′s Data Graphics feature!
Learn how to create an offset radial fill effect to add cool 3D effects to your Visio SmartShapes!
Learn how to create non-changing text that resizes with your Visio SmartShapes by using metafiles!
Learn how to use the ShapeSheet to make font-sizes increase and decrease with the size of your shapes.
Download a dimension-line shape that can be set to match the scale of an imported background images, maps or plans. You can then accurately measure and document dimensions on the imported graphic.
If you are doing date-related calculations in Visio’s ShapeSheet, you may occasionally want to add months to dates. Read this article to find out how!
Learn how to use the ShapeSheet more efficiently by defining reusable custom functions that can be called from multiple cells.
Learn how to add constraints to your Visio shapes using the ShapeSheet’s BOUND function.
Count the days ’til Santa arrives with the Visio Advent Calendar. Devs can peek under the hood to see how the ShapeSheet makes this thing tick!
Learn about the ShapeSheet’s POLYLINE function and PolyLineTo row type, and how they can work to make your shapes smaller and faster. Download the VBA code that will help you poly-line-ify your shapes with the click of a button!
Abuse the ShapeSheet by using gargantuan formulas to cleverly count geometry sections in a ShapeSheet — a feature that is “technically” not provided for by conventional thinking.
If you are developing Visio solutions for use in many cultures, you will be interested in this article’s explanation of how to control units in the ShapeSheet.
