Visio Tutorial on Advanced Data Graphics

Рет қаралды 25,437

Күн бұрын

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
www.computertutoring.co.uk/vi...
Update that solves why 23% is filling more than half the progress bar.
www.computertutoring.co.uk/vi...
#computertutoring
Do you need to learn fast? Then let us come to you and help: www.computertutoring.co.uk/mi...
😊 Check out my website and social media to keep up to date - enjoy learning 😊
📱 www.computertutoring.co.uk/ 📱
📽 / thecomptutor 📽
👨‍👩‍👧‍👦 / computertutoring.co.uk 👨‍👩‍👧‍👦
🦉 / ct_tutoring 🦉
📷 / computer_tutoring 📷
📌 www.pinterest.co.uk/CT_Training/ 📌

Пікірлер: 30

@kellyalvarado6533 Ай бұрын

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

@computertutoring Ай бұрын

Lots of 🪰that summer

@RenatoNovelli Ай бұрын

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

@computertutoring Ай бұрын

Thanks for saying

@leftwingg 3 жыл бұрын

This was hella-entertaining and informational.

@computertutoring 3 жыл бұрын

Glad you enjoyed it!

@robbuckles9565 3 жыл бұрын

This was excellent, thank you.

@kt9aq 3 жыл бұрын

Thank you, Simon

@computertutoring 3 жыл бұрын

My pleasure!

@abduljalilqureshi5868 Жыл бұрын

Great Video,

@charleshooper6078 3 жыл бұрын

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

@paulcutov798 3 жыл бұрын

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?

@computertutoring 3 жыл бұрын

Good question! I think that the data only goes one way.

@TheDJPapzo 3 жыл бұрын

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 . . .

@computertutoring 3 жыл бұрын

Hi if you don' have Icon Set in the Displayed as: list then your version might on be able to display a Icon Set (timestamp 21:48). My version is Visio Plan 2 (16.0.13029) Click Account - About Visio to see your version. Hope it's not a version issue 😟

@cindycubbin2932 4 жыл бұрын

👍

@MrSOdgaard 3 жыл бұрын

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)

@computertutoring 3 жыл бұрын

Hi sorry for taking a little time to get back to you. I had a little muck about with the Edit Data Graphics as in my video sort of got it working. However, using the Text Block tool in the tools section on the home tab might be what you're looking for. Arrange your graphics as in the above tutorial video then go to Home tab and in the tools section is the Text Block tool (Ctrl & Shift & 4) if you can't find it. Then you can arrange the text on your shape as you wish. You might want to add the shape to a stencil afterwards - kzfaq.info/get/bejne/qrqglcxir9OviZ8.html

@surauar-raudhahkempadangse5478 2 жыл бұрын

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

@computertutoring 2 жыл бұрын

From what I remember I think you go to Developer and shape protection. Sorry haven't got a Visio license at the mo. But hopefully by removing the Shape protection should allow you to ungroup the Shape.

@surauar-raudhahkempadangse5478 2 жыл бұрын

@@computertutoring Thank you so much. Oh yes, instead of using car or vehicles what other shape we can use? Can I use Man and Female object/shape? Maybe I use for calculate % of registration.

@augustuscrunch 2 жыл бұрын

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

@computertutoring 2 жыл бұрын

Not bad, not bad at all 😂

@vDC2me 3 жыл бұрын

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”

@computertutoring 3 жыл бұрын

Sorry not familiar with the CAD objects in Visio.

@markbrady871 3 жыл бұрын

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

@computertutoring 3 жыл бұрын

Well spotted didn't notice myself but will take a look

@computertutoring 3 жыл бұрын

Yes saw what the problem was "Silly Me" I forgot to change the 'Maximum Value' to 1. I'd left it on 0.3 which would account for the progress bar being almost full by 23%. Sorry hope this helps. 1 - Right Click graphic - Data - Edit Data Graphic 2 - Add or edit the progress bar 3 - In Maximum Value enter '1'