• 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
    • 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
    • Visio blog on Orbus website
    • 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

Excel

Published on October 15, 2020 by David Parker

Visio Data Visualizer Tips

The Microsoft Visio product team have released a great video introduction to the Visio Data Visualizer, but even that does not reveal all of its power. So, here are some tips about using the Microsoft Visio Data Visualizer add-in in Excel. Firstly, the add-in currently offers three different types of diagram, and each have a number of alternative layout arrangements.

  • Basic Flowchart – 4 layouts
  • Cross-Functional Flowchart – 5 layouts
  • Organization Chart – 5 layouts

Although these are the proposed diagram types, there is no reason why other types of data, such as network devices, cannot be used with any of them.

Sample Org Chart with Visio Data Visualizer in Excel
[Read more…] about Visio Data Visualizer Tips

Filed Under: Data Visualizer, Excel, Visio Tagged With: Data Visualizer, Excel, Visio

Published on September 23, 2020 by David Parker

Visio is NOT Vizio!

Update 1 : Microsoft read this post and immediately corrected the spelling so the following now works : https://adoption.microsoft.com/virtual-hub/search/?_sft_vh_product=microsoft-visio 🙂

Update 2 : Mr VisGuy! “spelt” is the same as “spelled” outside USA!

Aarghh! What kind of message is sent out if a company does not know how to spell the name of their own product? There is a make of TV in the States called Vizio, which is not the name of my favourite data-diagramming application, Visio. It may be pronounced the same, but believe me it is totally different. So, it is extremely disappointing that Microsoft have allowed their own product to be spelt incorrectly in the Virtual Hub in the Microsoft Ignite 2020 website.

[Read more…] about Visio is NOT Vizio!

Filed Under: Excel, Power Automate, PowerBI, Teams, Visio, Visio for Desktop, Visio for Web, Visio Plan 2 Tagged With: Excel, Power Automate, PowerBI, Teams, Visio

Published on June 5, 2020 by David Parker

Assigning Visio Shapes to Layers from Excel Table

I work a lot with layers in Visio, and written an add-in, LayerManager, to assist, but I was asked an interesting question recently: How can shapes by assigned to layers automatically from a list in Excel? So, I thought I would present my solution. This particular request was for a Timeline diagram, where the Milestone shapes are to be on specific layers. So, I just used one of the samples provided with Visio.

  • Sample Timeline has no layers
  • Milestones are group shapes
[Read more…] about Assigning Visio Shapes to Layers from Excel Table

Filed Under: Excel, LayerManager, Layers, VBA, Visio Tagged With: Excel, Layers, VBA, Visio

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 November 10, 2019 by David Parker

Visio news from MS Ignite 2019

Daniel, Scott, me and Michel at the Veeam party

Microsoft Ignite 2019 at the huge Orange County Conference Conference Center in Orlando is over for another year. 30,000 attendees over 6 days, and I have seen my first sunlight today since I arrived in Florida last Saturday! So, it is time to review just what was announced about Visio, and how much Visio is appreciated.

[Read more…] about Visio news from MS Ignite 2019

Filed Under: Data Visualizer, Floor Plans, MSFlow, MSIgnite, Org Charts, PowerBI, Process Flows, Teams, Visio, Visio for Desktop, Visio for Web Tagged With: Data Visualizer, MSIgnite, Org Chart, Processes

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

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • A Visio List Shape is also a Container
  • Taking Visio Actions Rows to the limit
  • TimeTable at RMConnect 2022
  • Custom Shapes in Visio in M365 and Web
  • A Multi-Time Zone Clock for Visio

Categories

Tags

Accessibility Add-Ins 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 Pro for Office365 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

  • A Visio List Shape is also a Container
  • Taking Visio Actions Rows to the limit
  • TimeTable at RMConnect 2022
  • Custom Shapes in Visio in M365 and Web
  • A Multi-Time Zone Clock for Visio

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