1. Kansas State University
  2. »Division of Communications and Marketing
  3. »K-State Today
  4. »Linking updatable data to a 1xbet online sports betting with Microsoft Visio

K-State Today

June 8, 2011

Linking updatable data to a 1xbet online sports betting with Microsoft Visio

Submitted by Shalin Hai-Jew

Manually building various informational graphics can be time-consuming and tedious, particularly if the data is continually changing. One feature of Microsoft Visio 2010 enables the integration of existing information from a variety of sources -- an Excel workbook, an Access database and others -- to be pulled into an informational graphic. This also enables easy updating of previously connected data for an engaging and up-to-date visual.

First, open Visio and in the File Menu, go toNew. You will be asked to choose from a range of templates.

1xbet online sports betting

SelectProject 1xbet online sports betting by clicking the highlighted template. Then click theCreatebutton at the right, just below the image of the 1xbet online sports betting .

The workspace is defined as follows in the sample provided by Microsoft Visio of the fictional Contoso Pharmaceuticals.

1xbet online sports betting

Using the premade 1xbet online sports betting as a template for the building of a new 1xbet online sports betting , you will be going to the Data tabin the menu bar in order to change the information that is in the 1xbet online sports betting .

1xbet online sports betting

At the top left of this tab, go toLink Data to Shapes. When you click that, you will see a Data Selector window.

Click the radio button next to your selection to indicate the type of data that you would like to import. For this example, we will be using a Microsoft Excel workbook. Make sure that the first row of items contains labels for the information below.


You will be asked to locate the file. Once you’ve found it, clickNext.

The next slide clarifies that all data from each row and column will be included.


ClickNextonce you’ve made your selections. The next window reads: “Configure Refresh Unique Identifier.”This feature enables the 1xbet online sports betting to be updated as the data in the Excel Workbook are updated.

Going with the default assumes that your data is labeled appropriately by what is at the head of the columns. (This will mean that as the Excel Workbook is updated, the former structure is maintained.)

ClickNextfor the screen, or go directly toFinish.

The External Data window below will be refreshed.


Click on the 1xbet online sports betting elements in the workspace that are not related to your project, and delete them. If there are any text elements and tables that you do not want, you can delete those. Or, you may use aCtrl + Ato delete all elements. To change the name of the file, go to theVBackground-1 tabto make the change. That tab is directly to the bottom left of the workspace.

To change the “Project Launch 1xbet online sports betting ,” you must go to theDesign tab, change the design theme…and then you’ll be allowed to make a change to that text.

To relate data back to a particular shape, you will first need to drag the 1xbet online sports betting shapes onto the workspace. Once those have been placed, you will be dragging each of the column elements onto the various objects.

To create a 1xbet online sports betting , highlight “block 1xbet online sports betting ” in your 1xbet online sports betting Shapes column at the right. For our purposes, we’ll use the fictional dates set up in the Excel chart. (Be sure that you’re back on Page 1 and not on Background. The Background is used to create recurring uneditable elements. Because a 1xbet online sports betting should be malleable and should change with new information, it would not be advisable to place a 1xbet online sports betting on the background.)


ClickOK.

Next, we want to place events on the 1xbet online sports betting . In the 1xbet online sports betting Shapes area, choose how you want particular dates to be represented. For this example, we will use aPin milestone.


To place events on the 1xbet online sports betting , go to the External Data below, and drag each event onto the work space.

As each element appears on the screen, a “Configure Milestone” window appears for you to verify the information. Just clickOK, and the event will go automatically to the correct space in the 1xbet online sports betting . Simultaneously, the External Data will show a link next to the dates that have been linked into the 1xbet online sports betting . In the following screen capture, the first four dates have been expressed on the 1xbet online sports betting , but the latter three have yet to appear.

Different types of symbols may be used to indicate different types of milestones. To update the data, go through the same processes as before in terms of uploading a new updated Excel Workbook with new data, and either manually update the 1xbet online sports betting or use the automated update feature.