Understanding Visio’s Color Formulas

I was recently exploring the ShapeSheet formulas available in Visio that affect colors, and I decided that I needed to make a shape that I can change the fill color, tint, shade and tone of dynamically. This allows me to copy the formulas from a Shape Data row value for pasting into a ShapeSheet cell.


The top part of the shape displays the chosen fill color, and the RGB and HSL formulas can be copied from the Shape Data window.

There are three horizontal bands below the main rectangle that each have a yellow control handle which slides to the left and right. This control handle will change the value for the TINT(…), SHADE(…) and TONE(…) functions.

The shape also contains copious hyperlinks to the ShapeSheet function definitions and many right mouse menu actions to set the fill color to one of the standard, theme or color map options.


Links to Microsoft MSDN pages:

Download the Visio document with the Color Formulas master shape on from here : VisioColorFormulas.vsdx

Whilst thinking about this, I realised that my good friend, and fellow Visio MVP, John Goldsmith, created an excellent Visio color picker shape. See Creating a color picker in visio





Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI


Microsoft Office 365 Development, and more...


Automate, Accelerate, Accurate


Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Smart graphics for visual people

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...

%d bloggers like this: