Advanced data graphics in Visio is a great way to link your Excel spreadsheet to Visio. This is especially useful when it comes to custom shapes outside the remit of the standard flowchart. If you want shapes to generate automatically I suggest you look to the data visualiser feature as detailed in the Flowchart from Excel and Cross functional flowchart from Excel tutorials.
Car Sales by Colour exercise file - should you want to follow along with the above tutorial.
During this data graphics tutorial you will see how creating a table in Microsoft Excel will benefit you when it comes to updating your Visio drawings and the advanced data graphics that are linked.
Once you've linked your Excel spreadsheet you can drag and drop the various rows of your data to connect to the shapes in a Visio drawing. This can be any shape, and once you know this then the power of this feature is incredible.
Should you want know how to create linked data in Visio and you've no time to watch the tutorial:
Silly me, I forgot to change the 'Maximum Value' to 1 for the progress bar. I'd left it on 0.3 which would account for the progress bar being almost full by 23%. Hope the following helps:
There you go! That's the whistle stop tour. To get more out of this and to understand it better I'm afraid you're gonna have to watch the video tutorial.
Should you want to take this further or maybe you're looking for a Visio training course for your organisation then please take a look at our Visio Training Courses: