 Hello and welcome back to another tutorial in this video We're going to be showing you how to build a cumulative line chart as you see on the screen now Obviously what it does is it tells us what the total is right at the very end here in December in this this purpose And we can see how that total was achieved over a period of time as the the total numbers of the levers cumulatively added Over that duration of time so cumulative is often used when we're talking about maybe levers or attrition That might be a familiar term for many of you So we'll stick with that sort of time for getting this and hopefully you'll find this video very useful for that purpose So soon as you're ready, we're going to jump straight in with a video and show you how this is achieved So we've got our data table here and we can see over the course of months So what January through to December and we can see the number of levers We're going to stick with the term levers just be easier the number of levers we have per month So obviously we want to show that in the cumulative number rather than just these numbers over months So if I was just to put a basic line chart in so go insert And then we'll go into charts and just do a basic line chart We can see that it's going to be a bit all over the place because it's just going to show each number by month So it's great to show you a number of levers by months But we want to show that cumulative View so we can see obviously starting from the number that left in January or through to december What the total were as a growing number over those period of months So in order to do that obviously we're missing a piece of information. We need a calculation or another column That will give us this cumulative number And to do that we're going to be using The sum formula, but we're going to be using A restricted or not really restricted, but we could be locking that range So if we have control over the number it's adding and to explain that the best way to probably do it Is to just jump in and talk you through as i'm doing it So we'll put a new column header here. We'll call this cumulative And then what we need to do here is then put in our formula So what we're going to do is use the sum formula. So equal sum open brackets And again, what we're going to do is we'll the first starting point of our sum range is always going to be C5 so what we want to do is we want to lock the the range of c or the cell reference c5 Do that with our dollar symbols We're then going to do our codon Because obviously this is then going to now ask us to put in the the last Cell reference in our range and that for this first part is going to be also c5 Then we can close brackets here So as you can see when you do a sum When you only got one cell reference is only going to sum the values in here The reason that we've locked the first at the starting point and not the last is because when I then drag this formula down You can see that our sum range is now grown. So it's still fixed. So it's always going to start with c5 But now in this next row for february, it's now going to do the sum of c5 through to c6 So we can see that the two of those adds together gives us our total of 24 If i'm to pull it down one more again, you can see now our sum range has increased even further So it's now going from row 5 to row 7 giving us the total of 34 So i'm just going to pull that all the way down to the december december field And then all these little error messages we've got here We can just highlight where they are and just go ignore error just go like this bit ignore annoying on the page So what happens when we now use that well at the moment our series is simply just using The result range we have here What we can do is if we just extend this now To go over to our cumulative cumulative one You can now see the difference we've got so we've got the same starting point here for january But our first series the result is this obviously showing us by month And this cumulative one is now this orange line showing us how that grows over time All we need to do is we can just simply select our first one the result series And you can see it then disappears from view And now what the benefit of having this chart is is it allows us just to see predominantly how growth has been over course of time So obviously We're going to see you know what the last date here or not date the number is here. So for december We know that we've had a total number of levers of 114 And what we could do here. What's always helpful is just to Let me talk through that So as we know if you select the line obviously you have all the data points So you could do your data labels if you just select the one individual point again And then obviously it will only select that point to which we can now go into here and do add data label And we've got 114 so we can see that 114 is our total number of levers And we can see that how that moved over time This is quite a steady line chart line graph going up But let's say we have a pair of the numbers and let's say that in march We significantly increase this. Let's say you put 50 in here Like that then what this line chart then becomes really beneficial for shi- throwing Is that we can see we've now got a change total? So we're at 154 and very quickly We're able to visually see that march was the month that we had a real sudden uptick in the number of levers So this is a great way to be able to understand and look see our data over time And to tidy that up as we did in our previous video when we were looking at charts All we're going to do is simply just change the text to white in that column in column d Oh, and we've got a bit of a Formatting issue there. Oh, no, it's gone away now So even though when we select our chart, you can still see it But what we can do is if we just pull our chart down to here And let's just scroll down ever so slightly Scroll up a bit Go like that and you can see we've now got our clearance to chart So it's all obviously this is a quite quick Quick solution to just getting this chart in there You might want to play around make the formatting a bit better Just so it obviously looks a bit nicer on the eye Depending on the presentation you're going to use it on but there you go. That's how we achieved our line chart So we hope you enjoyed this video If you did please do give the video a thumbs up It's greatly appreciated and it does really help out the channel if you haven't already do subscribe to the channel Make sure you hit that bell notification Then you'll be notified of all of our new videos as they're coming out Thank you very much for watching and we shall see you in the next video