MVP Sessions wheel

I wasn’t sure whether to call it a wheel or a clock-face, but since there are 24 MVP Visio 2010 sessions (see http://visio.microsoft.com/mvpsessions )  I decided on a wheel … so in this blog I present my alternative interface into these sessions, created in Visio of course!

I created an Excel workbook in which I listed all of the sessions, their descriptions, and links to the video and any supporting files. I then created the wheel diagram, and used Link Data to Shapes to automatically add Shape Data rows and hyperlinks to each shape, and Data Graphics to automatically colour each shape.

Finally, I saved the Visio page as web pages (VML, XAML and SVG format output), and as pdf.

MVPSessions

Open the VML web output : http://www.bvisual.net/resources/mvpsessionsIE.htm

Open the SVG web output : http://www.bvisual.net/resources/mvpsessions.htm

Open the XAML web output : http://www.bvisual.net/resources/mvpsessionsX.htm

Open the Visio file : http://sdrv.ms/NYHH8V

Open the Excel file : http://sdrv.ms/OI3EKU

Open the pdf : http://sdrv.ms/OI2i2I

UPDATE : see https://blog.bvisual.net/2013/07/08/mvp-sessions-for-getting-started-with-visio-2010/

Linking Excel Ranges to Visio Shapes

I have often linked Excel worksheets and ranges to Visio over the years. I used the Database Wizard initially, but have been using the Link Data to Shapes feature since Visio 2007. I had noticed that I sometimes didn’t get a full list of the available ranges when trying to link in Visio, so I decided to investigate why.

Firstly, I created a sample Excel 2010 worksheet with a header row, and three rows of data in Sheet1.

SNAGHTML1c9f99

Read the rest of this entry »

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

Microsoft Power BI, Analysis Services, MDX, DAX, M, Power Pivot and Power Query

davecra.wordpress.com/

Microsoft Office 365 Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Smart graphics for visual people

Pluralsight blog

be smart, be clear, be visual ...