• 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 ShapeSheet Formulas

ShapeSheet 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

Visio Nerd Videos – For Developers!

July 14, 2016 By Visio Guy 3 Comments

visio-nerd-videos-thumb

If you’re interested in the deeper workings of Visio, then you’ll be interested in a series of videos that I’ve been in remiss in reporting!

[Read more…] about Visio Nerd Videos – For Developers!

Filed Under: Code, Data, Development, Power User, Shapes, ShapeSheet, Tools, Video Tagged With: John Goldsmith, Programming, shapeshe, ShapeSheet, ShapeSheet Formulas, ShapeSheet Functions

Add Spice to Your Visio Skills With Randomization!

July 16, 2010 By Visio Guy 2 Comments

the-matrix

Unfortunately, no one can be told what the ShapeSheet is. You have to see it for yourself.

Visio SmartShapes can be so much more than just clip-art. This is because the ShapeSheet allows shapes to  behave in intelligent ways, carry data and react to that data.

One under-used, little-known function is RAND(), which allows you to add randomness to your drawings. Randomness can not only be “neat-o”, but also useful. Come in and see why!

[Read more…] about Add Spice to Your Visio Skills With Randomization!

Filed Under: ShapeSheet Tagged With: Backgrounds, ShapeSheet Formulas, ShapeSheet Functions

Stress Test: Nesting “IF” Functions in the ShapeSheet

July 10, 2010 By Visio Guy 3 Comments

A Visio Guy forum member asked the question: “How many nested IF statements can I stuff into a ShapeSheet formula?”

“Good question!”, I thought and went off to investigate!

[Read more…] about Stress Test: Nesting “IF” Functions in the ShapeSheet

Filed Under: Code, ShapeSheet Tagged With: ShapeSheet Formulas, ShapeSheet Functions

Get Web Hex Color Values from Visio Shapes

May 14, 2010 By Visio Guy 5 Comments

Web designers and AI folks need to know what colors they are using. And they need to know precisely.

Bright red, Fuchsia  and Mauve just won’t do. They need exacting names like: #FF0000, #FF00FF and #E0B0FF.

Since more and more folks are using Visio for prototyping web sites and user interfaces, I thought it might be useful to create a SmartShape that displays the hexadecimal color value for a particular shape.

[Read more…] about Get Web Hex Color Values from Visio Shapes

Filed Under: Illustration, Shapes, ShapeSheet, Web Design, Wireframes & IA Tagged With: Artistic Effects, Color, ShapeSheet, ShapeSheet Formulas, Smart Colors

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

Title Block #3: Smart Tabs, Smart Text

January 23, 2009 By Visio Guy 9 Comments

title-block-3

Today we’ll continue our discussion of title block topics by talking about how to control the location of text chunks in a shape’s text block.

Sure, Visio text has tabs, which we’ll put to use. But in the wrong hands and on the wrong shapes, tabs can blow up in your face!

But never fear, for today we introduce the concept of Smart Tabs. Smart tabs are tabs that organize your text properly, even when your shape changes size!

[Read more…] about Title Block #3: Smart Tabs, Smart Text

Filed Under: Development, ShapeSheet Tagged With: ShapeSheet Formulas, Tabs, Text, Title Blocks

Visio SmartShape for Inauguration Day 2009

January 20, 2009 By Visio Guy 2 Comments

inauguration-dayHappy Inauguration Day 2009, to everyone who finds it happy!

And to those who don’t find it particularly happy…well you find something to be positive about.

Which brings me to the point of this article: a bit of Visio inauguration-day  humor!

[Read more…] about Visio SmartShape for Inauguration Day 2009

Filed Under: Humor, ShapeSheet Tagged With: Coordinates, Hidden, ShapeSheet Formulas, ShapeSheet Functions, SmartShapes, Text, Transformation, Visio Groups

Title Block #2: Let’s Make a Multi-field SmartShape!

November 19, 2008 By Visio Guy 16 Comments

In our last article on Visio title blocks, Title Blocks #1: How to Display Existing Document Information, we were introduced to a remarkable title block shape.

This single shape could display any of four different date-related bits of info: when the doc was created, edited, printed, or the current date/time.

The user simply had to choose which field to display from a drop-down list in the Shape Data Window, and Visio automatically took care of updating the values in the shape’s text.

If you need to create lots of different title blocks for different projects, then a shape like this can save you a lot of work.

And if you’re extremely curious, a power user, or a technical type, then you’ll be interested in how to build shapes like these of your own, and customize them to your own specific needs.

Today’s article will do just that. It’s fairly advanced and detailed, but if that’s what you’re looking for, then come along with us as we rip it apart, and see what it takes to build one of these “Multi-field Visio SmartShapes”

[Read more…] about Title Block #2: Let’s Make a Multi-field SmartShape!

Filed Under: Development, Shapes, ShapeSheet Tagged With: ShapeSheet Formulas, ShapeSheet Functions, Title Blocks

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

Primary Sidebar

Buy Über Bubble Revision Shape
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
  • Visio Network Server Shape Icon Customization Tool
  • Sankey Diagram Shapes for Visio
  • Amazon AWS Visio Shapes
  • Dynamic Updating Org Charts in Visio!
  • Go 3D with Free Isometric Piping Shapes for Visio
  • Text to the Bottom of the Shape
  • Map of World

www.visguy.com - Visio Guy - since 2006

 

Loading Comments...