• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Visio Guy

Smart graphics for visual people




  • Home
  • Hire Me
    • Hire Me
    • Résumé
  • Products
    • Products
    • Bubble Revision Shape
    • Layers to Pages Utility
    • Rack Unit Dimension Line
    • Radial Elements Tool with up to 100 Wedges
    • Text on a Circle Visio SmartShape
  • Index
    • Articles by Date
    • YouTube – VisioGuy
    • Download Information
    • Suggestion Box
    • Shop
    • Visio Art
    • Visio Links
    • – Visio Shapes & Stencils
    • – Visio Templates & Drawings
  • About
    • About
    • Donate
    • GitHub
    • jsFiddle
    • Reading List
    • Subscribe & Follow
      • – E-mail
      • – facebook
      • – Twitter
      • – RSS
    • Privacy Policy
  • Discussion Forum
You are here: Home / Archives for Formulas

Formulas

Constrain Control Handle to Circle

November 7, 2018 By Visio Guy 6 Comments

If you’ve ever needed to constrain a Viso SmartShape’s control handle to a circle or other curve, then you’ve finally found the right article!

[Read more…] about Constrain Control Handle to Circle

Filed Under: Development, Power User, ShapeSheet Tagged With: Control Handles, Controls, Formulas, SETATREF, SETATREFEXPR, ShapeSheet Formulas, ShapeSheet Functions

List Separators in Visio’s ShapeSheet are Crazy!

April 21, 2010 By Visio Guy 2 Comments

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, my friend, are a victim of list-separator craziness!

 

 

 

[Read more…] about List Separators in Visio’s ShapeSheet are Crazy!

Filed Under: ShapeSheet Tagged With: Formulas, FormulaU, List Separators, ShapeSheet, ShapeSheet Formulas

Choose Colors with Shape Data Fields

October 21, 2009 By Visio Guy 22 Comments

choose-colors-in-shape-data

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 Shape Data fields don’t directly support colors, but I’ve come up with a workaround. You can read how I did it, or just get the download and re-use what I’ve already built!

[Read more…] about Choose Colors with Shape Data Fields

Filed Under: ShapeSheet Tagged With: Color, Formulas, Functions, Shape Data, ShapeSheet, ShapeSheet Formulas, User-defined Cells

Trilogy-meter Data Graphics Part I

February 23, 2009 By Visio Guy 3 Comments

trilogy bar graph

Today, Visio Guy will show you how to create a three-bar SmartShape and link it to data using Visio 2007 Professional’s brilliant “Link Data to Shapes” feature.

We’ll cover the intricacies of creating a shape that visually reacts to data, and show you how to link instances of this shape to actual rows of data in an Excel spreadsheet!

This is the first in a three-part series on data graphics and data linking, so read-on, and stay tuned!

[Read more…] about Trilogy-meter Data Graphics Part I

Filed Under: Data, Power User, ShapeSheet Tagged With: Data Linking, Formulas, SmartShapes, Text, Visio 2007

A Re-programmable Visio Multi-shape: The Configurable Stickman!

November 14, 2008 By Visio Guy 4 Comments

If you’ve read our last article, Visio Multi-shapes, then you know what a great feature multi-shape-ness can be.

However, until you graduate from Visio Geek University (go VGU!), and become proficient with ShapeSheets, those pesky multi-shapes can be quite difficult to build.

So what if user’s could somehow define their own multi-shapes?

That question has burned today’s article into my mind, and today it comes to you via the information super-highway. Ladies and Gentlemen, may I introduce to you the Configurable Stickman, which who can be set to one of five positions.

And YOU can define the positions yourself!

[Read more…] about A Re-programmable Visio Multi-shape: The Configurable Stickman!

Filed Under: Shapes Tagged With: Formulas, Functions, Multi-shapes, Power User, ShapeSheet, ShapeSheet Formulas, User-defined Cells

A SmartShape is Worth 1000 Symbols

September 22, 2008 By Visio Guy 9 Comments

The promise of the Visio SmartShape is that one single shape can replace an entire army of symbols.

With a little bit of parameterization, we can clear out the redundancy in our symbol libraries, thereby simplifying maintenance for our developers, and ease-of-use for our customers.

Today’s article will demonstrate just how Visio SmartShapes can do that, and we’ll teach you how to conjure up some of the behind-the-scenes magic that makes it happen!

[Read more…] about A SmartShape is Worth 1000 Symbols

Filed Under: AV Equipment, Development, Shapes, ShapeSheet Tagged With: Formulas, Parameterize, ShapeSheet;SmartShapes

How to Build Smart Frames and Bezels #2

July 12, 2008 By Visio Guy 1 Comment

Read Full ArticleIn 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 had a uniform frame-thickness all the way around, and offered no way for an end-user to change that thickness.

In this article, we’ll add some flexibility to the shape by making separate margin parameters for each side. We’ll also expose the margin settings to the user via Shape Data fields.

[Read more…] about How to Build Smart Frames and Bezels #2

Filed Under: ShapeSheet Tagged With: Formulas, ShapeSheet, SmartShapes, Tutorial

Visio Microphone Shape

June 18, 2008 By Visio Guy 4 Comments

Read Full ArticleWapperdude submitted this “mike” shape to Visio Guy, for us to pass on to our readers.

According to WD, the inspiration came as follows: I saw a request for audio symbols in the Visio forum, had this dumb 1998 mike shape, sent it to school and now it’s smarter.

So for you A/V folks out there in Visio Land, here’s a new SmartShape for your diagramming enjoyment!

[Read more…] about Visio Microphone Shape

Filed Under: AV Equipment, Shapes Tagged With: A/V, Color, Formulas, Multi-shapes, ShapeSheet, SmartShapes

How to Build Smart Frames and Bezels #1

June 15, 2008 By Visio Guy 4 Comments

Read Full Article If you create elevation drawings for rack systems, for cabinetry, for A/V systems with TVs and video monitors, or for walls with doors and windows, you’ll find yourself needing frame shapes.

And while your equipment may come in different sizes, the frames should maintain consistency when they are stretched.

For example, you may have several sizes of monitor: 19-inch, 21-inch, 48-inch, etc. Even though the picture gets bigger, the bezel around the display stays the same thickness. You get more display area, not more plastic!

A Visio SmartShape offers an elegant way to depict these objects. With a little bit of ShapeSheet programming, you can make one shape that can do the job of several!

We’ll call these shapes Smart Frames. This article is the first installment in a series about creating and understanding Smart Frame shapes in Visio! So enjoy this article and stay tuned in the future!

[Read more…] about How to Build Smart Frames and Bezels #1

Filed Under: ShapeSheet Tagged With: Formulas, ShapeSheet, SmartShapes, Tutorial

Punish Your Users with (not so) SmartShapes That Misbehave

June 14, 2008 By Visio Guy 5 Comments

Read Full Article You can learn a lot from bad examples.

Call it learning-from-our-mistakes, anti-patterns, or devilish fun, there’s a lot to be gained by looking at how-not-to-do-it.

Those of us over 30 might remember our first introduction to BASIC programming, taught to us by our friend Jeff, in the electronics corner at the local super market. While Dad was shopping, Jeff went over to the Commodore Vic 20 demo kiosk and typed the following lines:

1
2
10 PRINT "Chris is a turkey!"
20 GOTO 10
10 PRINT "Chris is a turkey!"
20 GOTO 10

Utterly useless, except for the fact that it forever singed into our memory the ideas of branching and infinite loops…

[Read more…] about Punish Your Users with (not so) SmartShapes That Misbehave

Filed Under: Development, ShapeSheet, Video Tagged With: Formulas, Hidden, ShapeSheet, SmartShapes, Tutorial, User-defined Cells

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to Next Page »

Primary Sidebar

Buy Text on a Circle Shape
Article — Video — Purchase

Categories

Buy my book!

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Tag Cloud

A/V Artistic Effects BPM Code Connectors Control Handles Countries Custom Patterns Custom Properties Data Graphics Data Linking Data Visualization David Edson David Parker Fill Format Formulas Functions Geometry Gradient Images Links Maps Multi-shapes Network Programming repeating shapes Resources Right-Click Actions Scale Shape Data ShapeSheet ShapeSheet Formulas ShapeSheet Functions SharePoint shiny SmartShapes Sport Sports Text Themes Tools Transparency User-defined Cells Visio 2007 Visio SmartShapes

Top Posts & Pages

  • - Visio Shapes & Stencils
  • - Visio Templates & Drawings
  • Bubble Revision Shapes
  • Amazon AWS Visio Shapes
  • Sankey Diagram Shapes for Visio
  • Visio Network Server Shape Icon Customization Tool
  • Dynamic Updating Org Charts in Visio!
  • Go 3D with Free Isometric Piping Shapes for Visio
  • Text to the Bottom of the Shape
  • Free Visio People Shapes

www.visguy.com - Visio Guy - since 2006

 

Loading Comments...