The adventures of Visio section shapes continues

A while back I created a stencil of Visio section shapes. They were based on screen shots of the Shapesheet, I added control handles to adjust “cell” widths. The cells content was stored in Excel. I then loaded the “cell” contents from Excel. So, I had shapes that looked like Shapesheet sections, but they hadContinue reading “The adventures of Visio section shapes continues”

Visio RowType?

I love spelunking through the Visio shapesheet and creating Visio shapes that are more than just plain clipArt. I use CellsSRC() to explore because I can iterate through an entire shapesheet and learn. Though CellsSRC sounds like Cells Source, it actually stands for Section, Row and Cell. Section is misleading. If you look at theContinue reading “Visio RowType?”

Visio Background Check

Another interesting question from the Visio section of Answers. The user wanted to find the background colour of a page. He was using the Backgrounds tab on the Design ribbon. This creates a background page with a name like VBackground-1. So, what he was looking for was the colour of the first shape on theContinue reading “Visio Background Check”

ShapeSheet Shapes

A lot of people only know Visio as an app to create business diagrams with clip art and connecting lines. Some have realized you can connect the diagram to a data source like Excel and bring life to the content. Some have also realzed you can add embelishments to the shapes called Data Graphics thatContinue reading “ShapeSheet Shapes”

Adding Shape Data to a series of new shapes

I have been playing with Visio Visualization in Power BI and the first step is to create a Visio drawing. Basically it is a bunch of shapes, but I need to add Shape Data to the new shapes, basically the key that will link the shape to the row of data in Excel. I couldContinue reading “Adding Shape Data to a series of new shapes”