 In this training video, we're going to look at linking shapes to Excel data. So there's just some picture shapes in this diagram, which we're now going to link to an Excel data file. So to do this, I'm going to go through the data tab. I'm going to do a custom import. Excel file in this example. I'm going to browse for it. The file that's in here is the file I want. I'm going to go through the wizard now. Leave it on the default recommendation. I'm just going to finish. So it's brought in all the data from the Excel file. Now we don't know which person is which person. So we can now click and drag the data onto the person's picture. So I can just click and drag straight onto the person. That aligns what's called a data graphics. As soon as you link, the data graphic is generated. We can control this. So same again. I've got three other pictures. So this is now all linked to Excel data. Now what I want to show next to their interfaces is the... I can choose another kind of information I want. Quarter one, quarter two, quarter three. So I want to show the annual target. So I'll just show the annual target. Well, what the target is for these people. So it's this field here I want to show. In this example, now I'm going to close the Excel data window down. Make it bigger in Excel. I can now go to the data graphics. And the one that's been demonstrated at present is this one here. Now I don't need to use this one because when you link, you get all sorts of data graphics that come with it. I can choose another one and I can even modify them. So I'm going to add all the shapes. Go to the advanced data graphics and I'll pick it. So that's the one that's applied by default. I'll go and see what this one is. So they'll give me another one here with text against it. So that gives me the region and the quarter one target. Well, actually I'll leave the region there because I'm going to leave that there. I might also want their name. So let's go back to that particular data graphic. Now it's linked and we can do a bit of modification. I can now click it and edit it. So it's showing a quarter one. I'm going to say this one I don't want. I'm going to show their name. So I'm going to add a new item. And I want the business development manager. And I want that as text. And then you can choose the position. So I'll have it. Default is far right. I can take the default off. And I can show it different positions, middle and middle bottom. This example I'll go bottom edge, far right. Click OK. And I can see how this is working so far. Apply and OK. So now I've got the name of the person, what region I came from. I might say I want their turnover to be top left. So top left up here. We'll give the annual turnover. So top right. So go top right, top right, top right. It will give me a bit more space between the structure. So I'm going to go top right. And I'll do the last data graphic as annual turnover. So I'm just going to edit. Add a new one. I want the annual target. I'll display it as text. And I don't want to use the default position. I want it top and far right. And then OK. And there's an example of the information you can now store for each of the people who've got the target. If I make it a bit bigger, I'll change it to 60%. A bit bigger maybe. OK. This kind of size, we can see the annual target, the region of the business manager, the name. And you can see that you can always make these bigger. You can extend them a little bit. So they look a bit nicer, something like this. But this is now showing this video of how to manually link Excel data to an image in this example. When you've managed to then get what's called data graphics and you can manage the data graphics, which in this example, we'll show an annual target, the region, and who the business manager is. So this is what it now looks like in standard view. And then this kind of information can be printed or we'll keep it in different data graphics. But this completes the training video on linking Excel data to shapes and images by manually linking the Excel data and then choosing whatever data graphics we want to use in line with the images and pictures. But the beauty about this kind of link, this kind of diagram, if the Excel data is updated, so will the information update after a refresh, because there's a refresh option here. So when the Excel data is updated, the picture will update itself with all the images and all the data graphics as soon as the refresh all is selected. But this completes the training video on linking Excel data to images we had to do it manually in this case and then we then controlled data graphics for the link.