 Let's make a progress bar in Excel, so we'll build something that looks a bit like this, imagine, we need to make something get 10 out of 10, someone's completing your sheet and filling stuff in, and it will go 1, 2, 3, 4, and keep building up and building up and building up, and then finally it 10 out of 10, a big tick to say that this is clearly done, move on, maybe this is an interactive worksheet, maybe it's full filling enough, whatever, however we get this number it doesn't matter, I've just done it with a spin button. So let's build one, I'm going to do this in a new sheet, zoom in a bit, and we're going to do it with a donut chart, so what we need for this is we need to have basically a complete number, some progress and some remaining, this will be the three components of our chart, so I'm going to put in just 10, Wyddech chi'n dweud bod ni'n dweud y cerdd pethu? Wel, roedd ond i fewn ni'n gwerthu. Felly rydych chi'n gwneud bod am rhan o'n ddau pethu. Rwy'n rhaid i ddweud ff்at구요. Dyma rydych chi'n mythio i meddwl i wneud ychwanegosu ac yn ddefnyddio'n y blw. Fi wnaeth hyn yn gyngor honest i flyni. The progress, I'm going to leave as orange, and here the remaining, click that and make sure it's selected and you do fill for blank. Delete everything else, kind of scale it to where I think it needs to be, and kind of scale it where I think it needs to be. Now, what behaviour I want, is that say, if it was out of… put out of 10 flatly on Dificus, when it's complete, I want that to say 10, zero and zero. I want it to look like this. Erbyn y gallwch yn dechrau, roi'r awm nhw'n fyddiol. 0, 5, 5 ar darth, a 5 arall, ychydig fydd drwy. Llywodwch ymlaeswyd. Yn y gallwch yn ychydig brifol arall a'r bwysig yn y cwrn. Mae'n meddwl i'n gwybod,yn ni'n meddwl. Fi yw'r rhan scoel oes. Roi'n meddwl o'r rhan oes, ac gallwch elu'r rhan oes fyddfa i chi'n meddwl. Cymru. First I'm going to highlight all of this, go to my formulas tab, create from selection and left column. This means they're all named now and I don't need to worry about what's in what cell. I'm just going to deal with it. The first thing's first, when it is complete, when it is current, I want this to read 10 and everything else to read zero. I'm going to start with here with an if and I'm going to say if, well, the current score, is equal to the out of score, that's it, we've hit 10. Well, I want that to read, well, the equivalent of the out of score, really. I don't want to manually put that in. I might have to change that later. Emma's false. I'm going to say that as zero. So there we go. If the current score is 10, it's going to pop up as 10. Now the progress, I want this to be, if the current score is equal to the out of score, I want that to be zero. It's the other way around. And if false, I want it to read as current. So the current is now 10 out of 10, if I change it to say 7 out of 10. And here, well, I want this to be basically out of minus whatever the progress is. So now we've got current 7, 8, 9, 10. We'll need to change this all more time to have an if statement. If current is equal to out of, well, that's going to be zero as well. So here we go. Now it's working if my score is 1 out of 10, the chart's filled in partially, 3 out of 10, 5, 8, 10 out of 10, it's all done. Now I want to make a big tick in the middle. So how am I going to do that? Well, first I'm going to select data and rename this data series as my progress. That is what it is. And I'm going to add in a new one called check. I'm just going to OK that for now. So I've got two data series on here. Now from the chart design, we're going to use a combo chart because we're going to do two different things on it. One is going to be the ring of the donut chart. That's as normal. And the check, I want it to be a scatter. So I'm going to have a dot now here that represents the one data point that's on there. But what I really want is I'm going to just put an X and a Y here just so I know and I want 0.5 and 0.5 and I'll check. I'm not going to edit the data. So the X value is that and the Y value is this. Now that she probably give you some ideas of how you might want to rearrange this and maybe add more data points if you want to change it. Now the axes, I'm going to have to override and make sure it's 0 and 1 and 0 and 1. And that means that dot is always going to be in the centre. And then finally, delete the things I don't need, the grid lines, the coordinates. And the same thing is happening here. I'm going to change this to an if statement. So if the current is equal to the out of scope, well, if it's true and it's complete, I want that to be 0.5. And if not, I'm going to make it read minus 0.5. It's going to push it off the screen. So if I change my current score to just 8 out of 10, the dot disappears when it becomes 10 out of 10. The dot reappears, it shoots up. So fair enough having a dot there. But now I'm going to insert illustrations, icons. And when the icons are loaded up, I'm going to search for maybe a tick. So tick and I'll pick this. Just when I found you can pick any in image you like. Let's make sure I've pasted that in here. And beforehand, I'm just going to rearrange the size of this just to cover up the corner because this is roughly where maybe this will appear. So I've now sized it up to be just in the corner unintrusively. I'm going to take my checkmark, hold it over the top and rearrange the size of this. So if you press Ctrl Shift when you do these tags, it will centre it. So we can kind of rearrange the size while it's still centred. Be a little bit smaller, a little bit smaller again. There we go. And then graphics format, graphics fill. I'm going to pick the same green colour. Now if I control X that to cut it and select that dot. So I've got that series. You can see it says series check there and paste that on. Suddenly I've got a green tick there as the data point. So this is now pasted in as an image. If you resize it, it kind of stays the same size. So you need to resize your graph first and then paste in the image you're going to use. But you can see if my current score was five, it disappears. And then we've got six, seven, eight, nine, 10. And it pings up. And if you use this number correctly, you can kind of maybe, well, if I change that to 0.15, you could see the slight animation that occurs when you update these graphs, it would descend down in a different way. Sorry, that was plus 1.5. Now it descends downwards. If it was minus 0.5, it would ascend upwards. So you can take advantage maybe of that little bit of animation if you want. So if I put no outline, hide it over the top there, take the grid lines off. Now we've got a little progress bar that can tick up as we complete our worksheet.