• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • Visio Shape Report Converter
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network
You are here: Home / Visio / Formatting Custom Units in Visio

Published on October 13, 2011 by David Parker

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:

image

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:.

=GUARD(Prop.MaxOperatingTemp-Prop.MinOperatingTemp)

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.

image

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:

image

QED.

Related

Filed Under: Visio

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Comments

  1. Arnav Sud says

    October 13, 2011 at 9:27 pm

    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!!!

    Reply
    • davidjpp says

      October 13, 2011 at 9:44 pm

      Wow! That was quick response … I’ve added a Data Bar graphic example at the end of the blog.

      Reply
  2. Sean says

    October 26, 2022 at 11:41 am

    David,

    I am trying to format the input on a shape data set. I want the format to be a telephone number. For example (123) 111-2222

    Reply
    • David Parker says

      January 3, 2023 at 9:10 am

      Hmmm … not so easy … I had a go, but it really requires some code, not just ShapeSheet formulas

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Themes Validation VBA Video Visio Visio 2007 Visio 2013 Visio for the Web Visio Online Visio Services Visio Viewer Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • LinkedIn
  • Twitter

Search this website

Recent posts

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

Copyright © 2023 · Executive Pro on Genesis Framework · WordPress · Log in