On 02 Aug 2023, Stanley M. Max made a presentation at Towson University (located in Towson Maryland) before the TUgis 2023 conference. (TUgis stands for Towson University GIS.) Stanley spoke about a Visio mapping project that he worked on with David J. Parker. Stanley originated the idea for this mapping project and initiated the process. However, the programming involved in the project was beyond Stanley’s skillset, so he looked on the web for a Visio expert to do that portion. He found David Parker’s information, and Stanley asked David if he would be willing to take over the programming to complete what needed to be done to bring the project to fruition. David kindly agreed with the request.
What follows is a slightly edited abstract of the talk:
Microsoft Visio is a powerful diagramming program used to produce visuals like organization charts, flowcharts, and floorplans. It has many advanced features enabling power users to carry out sophisticated quantitative analysis and generate state-of-the-art graphics. At the same time, newcomers to the program can get started fairly quickly and easily using basic, easy-to-learn procedures. Since Visio forms part of the Microsoft Office family, the program shares characteristics familiar to computer users of all levels. Visio can be used for mapping projects — which provides the central focus of this TUgis project. For a task primarily involving mapping, then, certainly, ArcGIS provides the superior package. However, the versatility that Visio offers — since so much more can be done with it than just mapping — makes Visio an extraordinarily helpful tool for education.
In our project we used Microsoft Visio to produce a map of all 27 member states of the European Union (EU) following the United Kingdom’s withdrawal from the bloc in 2020. We have associated this map with a legend containing the names of these 27 countries. When you click on a country’s name, the country is highlighted on the map and a table pops up containing these key demographic items for the country:
- Population, which Stanley input.
- Area in km², which again Stanley input.
- Percent of the total EU population, calculated by a formula embedded in Visio. David Parker programmed Visio to make this calculation.
- Percent of the total EU area, also calculated by Visio. Again, David carried out the Visio programming.
- Population density, again calculated and again via David’s programming skills, to show the number of people per square kilometre.
This project combines computer mapping, contemporary European politics, and demography. It serves as a case study of Visio’s usefulness in an educational setting.
Related articles
Using Notepad++ to Edit Visio ShapeSheet formulas
Visio shapes get their smartness from the formulas that are entered into the ShapeSheet, but editing these formulas can be extremely tricky and prone to error because of the lack of a modern programmer’s interface. Formulas can be quite long (up to 64k characters) but even medium size ones like the one in User.GetWorkdays cell…
Adding a second Function header bar to Visio swimlanes
I was recently asked if a second function header bar can be added to the swimlanes in the cross-functional flowchart templates in Visio. Some swimlanes can get quite wide, so it can be useful to have a duplicate function header shape on the far-side too. It is quite simple to duplicate the existing function header…
More Parsing XML Data in Visio Shapes
My last article looked at parsing an XML string with a known structure and order of elements and attributes. This can be acceptable in some scenarios, but what if the elements or attributes are in a different order? Then it is necessary to use the element and attribute names rather than their index position. This…
Parsing XML data in Visio Shapes
One of my current projects uses XML data, and some of the values in the XML data control the display and content of Visio shapes. Therefore, I looked deeper into how the XML data can be used directly to control parts of the graphics. Although the external data linking feature in Visio Professional and Visio…
Highlighting dirty text in Visio shapes
I suppose I should explain what I mean by dirty text first 🙂 I often display the value of a Shape Data row in Visio text, but sometimes the solution requires that the value is also editable. This is ok if the client accepts that all editing is done with the Shape Data window or…
Navigate to named areas in Visio with SS Plus
Many years ago, when I was an architect, I used a Unix CAD system with large buildings. I was able to navigate quickly to rectangular areas that I had named. Well, the Export to PowerPoint feature in Visio Plan 2 provides Slide Snippets, which are named areas that can be exported to PowerPoint. My SS…