• 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
    • Using Visio in Education for GIS
    • 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➡
      • Visualize Complex Processes with Microsoft Visio
      • 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

ShapeSheet Functions

Published on April 20, 2020 by David Parker

Using some Visio Shape Data in Visio for the Web

Like a lot of UK TV viewers last week, I watched Quiz, a drama about Major Charles Ingram who apparently cheated his way to the jackpot in Who Wants to be a Millionaire. Some of the questions that he was asked were quoted in that show, and I was surprised how easy the last two questions were for me, but that was probably because of my own education as a building architect. However, I decided to lookup the rest of the questions, and I would have fallen before getting to those questions unless my Phone-A-Friend could have helped me on one in particular. At the same time, I was thinking about the differences between Visio desktop and web editions (yeah, really!), so I have created a Visio document that contains all of the questions that the Major answered correctly. This document can be viewed by everyone and downloaded. If it is saved into OneDrive or SharePoint Online and then viewed online.

[Read more…] about Using some Visio Shape Data in Visio for the Web

Filed Under: Data Visualizer, Visio, Visio for Web, Visio Online Tagged With: Hyperlinks, Shape Data, ShapeSheet Functions, Visio, Visio for the Web

Published on March 31, 2020 by David Parker

Using CODE() and UNICODE() functions in Visio

Microsoft Visio does have CHAR() and UNICHAR() ShapeSheet functions, just like Excel, but it does not have the inverse CODE() and UNICODE() functions, unlike Excel. However, there is a way to create a formula in the Visio ShapeSheet to provide these functions.

The following worksheet demonstrates how the CHAR(), CODE(), UNICHAR(), and UNICODE() functions work in Excel.

ColumnFormula
Indexn
Char=IFERROR( CHAR(INT([@Index])),””)
Code=IFERROR( CODE([@Char]),””)
Unichar=UNICHAR(INT([@Index]))
Unicode=UNICODE([@Unichar])
[Read more…] about Using CODE() and UNICODE() functions in Visio

Filed Under: Excel, Lists, Shape Data, ShapeSheet Formulas, Visio Tagged With: Excel, ShapeSheet Functions, Visio

Published on March 25, 2020 by David Parker

Preventing Deletion of Container Members in Visio

The concept of Structured Diagrams was introduced in Visio 2010 and is featured in many of the templates supplied with Microsoft Visio, and in some third-party solutions, like mine. Connectors, callouts, containers and lists are the key parts of a structured diagrams, and there are times when preventing the deletion of members of a container or list is desirable.

  • An example cross-functional flowchart
  • Accidental deletion of a process shape
[Read more…] about Preventing Deletion of Container Members in Visio

Filed Under: Containers, Lists, Process Flows, ShapeSheet Formulas, Visio Tagged With: Containers, Lists, ShapeSheet Functions, Visio

Published on August 8, 2019 by David Parker

Multi-line text in Visio Shape Data

The Shape Data (nee Custom Properties) dialog and window only provides a single line to view or edit text values. It is a great shame because the value can be up to 64k characters, and long text can be pasted into it. I, and many others, have complained about this for many years to Microsoft, but nothing has been done to rectify this. Of course, I do develop custom user interface components for many customers, but that is not always desirable. Therefore I sometimes re-purpose standard Visio elements to provide the ability to view or edit multi-line text in Shape Data rows.

  • Description Shape Data row
  • Edit using ScreenTip or Action
  • Scrollable multi-line text
    Scrollable multi-line text
  • The first 248 characters are displayed on mouse hover
  • Simple ShapeSheet formulas to do this
[Read more…] about Multi-line text in Visio Shape Data

Filed Under: Shape Data, ShapeSheet Formulas, Visio Tagged With: Shape Data, ShapeSheet, ShapeSheet Functions

Published on July 22, 2019 by David Parker

Writing a WeekNum(…) function for Visio

I needed to display the week number of dates in a Visio project of mine, but there is no WeekNum(…) function built-in, so I had to write one, and allow for the date that the week numbers begin in to be varied from 1st January.  I also needed to allow for the week numbers to go backwards from the specified week number begin date.
Excel has a WeekNum(..) function, which can take an optional parameter for the day of the week to begin on, and an IsoWeekNum(..) function, and the following table shows the values change for the first 35 days of the year:
Excel Week Num Formulas
[Read more…] about Writing a WeekNum(…) function for Visio

Filed Under: Shape Data, ShapeSheet Formulas, TimeTable, Visio, Visio 2016 Tagged With: Excel, ShapeSheet Functions

Published on March 7, 2019 by David Parker

Changing Visio Shape Size and Angle with Linked Data

I was recently laying out a computer room floor plan to scale in Visio, from survey data of the cabinets\racks within it, and it occurred to me that I could work a bit smarter than I first thought. Originally, I was going to just add lots of rectangles, size them, rotate them, and label each them with their name. Then I thought, why not use the Width, Depth and Name columns from the survey data to do most of the work for me? It was so simple to do, and only took a few minutes, so I thought I would share my methodology because it demonstrates how easy it is to work smarter with Visio….

These are the simple steps shown above, written out for your education….

[Read more…] about Changing Visio Shape Size and Angle with Linked Data

Filed Under: Excel, External Data, mFormula, ShapeSheet Formulas, Visio Tagged With: Shape Data, Shape Design, ShapeSheet, ShapeSheet Functions

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 5
  • Page 6
  • Page 7
  • Page 8
  • Page 9
  • Interim pages omitted …
  • Page 12
  • Go to Next Page »

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Jumping between Shapes in Visio
  • Co-authoring and Commenting with Visio Documents
  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript LayerManager Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Setup and Deployment Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Validation VBA Video Visio Visio 2007 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

  • Amazon
  • E-mail
  • Facebook
  • LinkedIn
  • Twitter
  • YouTube

Search this website

Recent posts

  • Jumping between Shapes in Visio
  • Co-authoring and Commenting with Visio Documents
  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio

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