Formatting Custom Units in Visio

A recent reader asked how can you use custom units in Visio when the only number formats available appear to be currencies, lengths and percentage. In his case he would like to display Kgs and the symbol for degrees Celsius. Well, I will explain how you can do this for Shape Data, at source, or in Data Graphics.

Displaying Custom Units in Shape Data

In the following example, I have taken a normal Server master and added four extra Shape Data rows – MaxOperatingTemp, MinOperatingTemp, Weight, and TempRange:


I have included TempRange to show that the other two temperature Shape Data rows are indeed numeric, even tough they display the custom unit °C in both the Shape Data window and in the Data Graphics – without needing to add any extra formatting.

In each of these four Shape Data rows I have added a custom format in the form

=”0.0 ‘text'”

The first part specifies the number format, and the second part is any text within single quotes. The whole lot is surrounded by double-quotes.

These formulae can be entered in the ShapeSheet, as above, or in the Define Shape Data dialog, without the equals sign and the double-quotes, however, the formula for the TempRange value cell had to be entered using the ShapeSheet:.


Tip : If you need to insert special symbols like °C then simply use the Insert / Symbol command on any text box, then copy and paste the characters into the formula.

Displaying Custom Units in Data Graphics

In my example, I have displayed the Memory Shape Data row in the Data Graphics with the Gb custom unit. Unlike the other Shape Data rows that I added, this one does not have a custom format defined in the Shape Data row, it is merely added to the display, and this is surprisingly easy … When you are in the Value Format row, the temptation is to open the Data Format dialog with the builder button on the right hand side.


However, none of the Category settings allow you specify a custom unit, except for the Date/Time … and these are not dates – but you can use the Custom Format box. So, all you need to do is enter the custom units in the same way as before.

You can apply custom units to the values in Data Bars too:



Posted in Visio. 2 Comments »

2 Responses to “Formatting Custom Units in Visio”

  1. Arnav Sud Says:

    Awesome! Worked like a charm!! Though it works with “Text” only I suppose? I mean I edited the data graphic to look like “Data Bars” and it did not work…!?
    But surely, that has to be a first on the internet! Well done!!!

Leave a Reply

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

You are commenting using your 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.


O365 and SharePoint

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

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

Azure Solutions for Office 365, and more...

Rob Fahrni



Life with Visio and other Microsoft Toys!

Nilsandrey's Weblog

Just another 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

%d bloggers like this: