Visio Tutorial on Advanced Data Graphics

This Visio tutorial on advanced data graphics will show you how to link an Excel spreadsheet to a Visio drawing, then display data graphics in Visio that will make your boring Excel spreadsheet more engaging.
This Visio data graphics tutorial will also show you how linking data to your Visio drawing will allow you to change the colour of a shape based on values in your Excel spreadsheet.
During this Microsoft Visio data graphics tutorial you will also see tips on getting your data to update.

Chapters
00:00 - Intro
02:06 - Get Started
03:39 - Having a look at the Excel spreadsheet
04:05 - Convert data in spreadsheet to a Table
06:05 - Import the Excel table into Visio
07:20 - Linking the Excel data to shapes
08:30 - Refreshing the Excel data
11:55 - Arrange the data graphics
13:25 - Customising shapes in data graphics
15:27 - Number formatting in Visio data graphics
16:10 - Percentage formatting (Remember to change max value to 1 or check link below).
17:15 - Change colour of graphic based on value from a spreadsheet
19:40 - Eating a fly
20:10 - Apply formatting to multiple graphics
20:30 - Making the Visio page look pretty

Advanced Data Graphics exercise file

Update that solves why 23% is filling more than half the progress bar.
#computertutoring

😊 Check out my website and social media to keep up to date - enjoy learning 😊

[leftwingg]

This was hella-entertaining and informational.

[ExestentialCrisis]

😂😅 Sniffing the water to see if the fly was in there was my absolute favorite part!!

[RenatoNovelli]

Awesome! It'd gonna be super useful to me! Tks for sharing!

[augustuscrunch]

Ancient joke: If everyone in the UK drove a pink car, it would be a pink carnation.

[chhoo]

Good video. Thanks. Have you managed to control layers using Excel? That would be the icing on the cake

[surauar-raudhahkempadangse]

This is Great! Thank you.. One question, how to ungroup the car, I tried but it say shape protection, container etc..

[TheDJPapzo]

Thank you for the video.

I am using visio professional 2016 but I don't the option for icons in the shapes sub menu. How can I get that set of icons and more . . .

[paulcutov]

Nice tutorial!
Is there a way of replacing the data on linked the excel spreadsheet (source data) by manually editing the info within the viso shape data window? i.e. change colour field box from grey to red. Although this change takes place within the shape data, is there a way of reflecting this change within the excel data?

[markbrady]

The "progress bar" for the Grey cars shows .23 or 23% but is far more than halfway filled. Seems like something's amiss.

[MrSOdgaard]

Thanks for your tutorial.
Question: I have a datagraphics where I want more text within a rectangular shape. I want two text fields - one in the Lower-Left corner and one in the Lower-Right corner.
I want the LL to be left aligned (without label) and the LR to be right aligned without label.
The LL is my challenge. How do I get this Data field Left aligned?

Thanks in advance

Stephen Odgaard (Copenhagen, DK)

[vDCme]

I have been struggling to recreate something that I did in Visio 10 years ago. I created an office floor plan in AutoCAD. Imported the dwg into Visio. Each cubicle in the floor plan or office had a closed polyline around the perimeter of the office space. Inside this perimeter was also a piece of text that gave the space it. Then I could link an odbc database, , I was using Excel as the dB file to the Visio drawing and it would shade smart objects with a value based on a legend created inside Vizio. Like I said it was 10 years ago I actually have my document but I cannot figure out how to get to work with today's version of Vizio. Are you familiar with this process or point me in any direction or how to import the AutoCAD correctly and use Visio’s “Conver CAD Objects”