Creating a New Data Graphic

Refreshing data in a new data graphicIn this tutorial we continue the series on Visualizing Data by looking at creating a new Data Graphic from scratch.  Being able to create a new data graphic in Visio is a useful skill to have, as data graphics can be used in other diagram types, for example Pivot Diagrams. [br]In this example we explore how a data bar graphic can be added to a shape in Visio and once set, applied to other shapes in order to graphically represent the numerical data in the linked dataset, in this case an Excel spreadsheet.

Linking and breaking new data graphic links

When the new data graphic has been made it must be connected to the data source for it to function properly. In our case, the data underlying the diagram is saved in an Excel spreadsheet, so to demonstrate how to update the new data graphic in the diagram we change some of the data in Excel.

Refreshing data to update the new data graphic

TIP: There is a choice when doing this: you can elect to refresh only the data linked to the new data graphic or to refresh all the data at once.

[br]In the tutorial I choose to refresh all the data and when it has been updated we look at how the new data graphic changes to reflect the changes.

We also look at how the link that connects linked data from a data source may become broken and how it can be restored.  the tutorial concludes by testing the data graphic we have created by changing the underlying data and refreshing the diagram.

The parameters we put in when we created the new data graphic were set to change the progress bar if the data grew or shrank between the limits we set, so to observe the changes in the new data graphic, these values are changed.

creating a new data graphic

© 2010 Netresult