 Hi, this is Dr. Don. I have some questions from my students. We're doing some forecasting, in this case using moving average and exponential smoothing. And the students need to add some additional data series to their basic chart. Now here in this graph, I've already created the chart and I've added the actual data points here in red. And it's just plotted against the months as the x-axis and I've prettied up the x-axis a little bit. I can show you how to do that in another video. But anyway, it's just plotting the actual values against the months here. Now I want to add in my moving average, the k-equal three and the k-equal nine. If you remember when we're doing moving average, we have some periods, some months in this case, that don't have a forecast value. If we just started selecting our range here at this first value, that would shift everything so that we'd be plotting, in this case, April against January, we don't want that. So we need to include these blank cells, these empty cells in the range we select. Let me show you, I'm gonna click inside my chart, make sure I've got the actual chart areas selected this section there. And then I'm gonna right click, select data. And we bring up a dialog box here. And what I wanna do is to add, and my series name, I'm gonna go over here and click k-equal three. That's a cell I've already typed the label in. I'm gonna go into my series values, I wanna delete information that's there, that's critical. And then we start here with this first cell and we drag down to make sure that we've got all our data selected. And here we've got a one month forecast added. So I'm gonna click okay. And click okay. Now let's look at our chart. Now whoops, instead of plotting this zero and connecting it, which looks strange, I wanna have these cells empty. And I thought they were empty. Well, which you may find out when you've been working with your spreadsheets for a while, it may appear to be empty, but there may be something in there that you don't know about that Excel sees. So one way of doing that is to click in a cell and hit the delete, and I'm gonna delete again and delete again, and that gets rid of the empty cells to make sure they're there. Now what I like to do, because it helps me for a number of reasons, is to make sure that those are empty and I'm plotting them correctly. I'm gonna click in there and I'm gonna put a function equal in A. Now that returns an error value in A and we can make sure that Excel sees that properly. I'm gonna click on that and it gives me the first part, you've gotta add the closing parentheses, shift parentheses, enter. And then I'm gonna drag that down to make those first three cells to make it obvious, one, that I wanna clue that when I do my plot and secondly, I don't want it to show up. Well, how do we make sure Excel doesn't plot that? Go back in here, click on our plot data again, right click, select data. Go down here to empty cells and let's make sure that we click show in A cells as empty and the default of course is gaps. We don't wanna plot anything there and hit okay. And that will make sure that when we plot any cell that's got an NA function, it will plot as a blank. Okay, let's add the K equal nine moving average series. I wanna start by making sure these are empty and the way I wanna do that again is use my NA, I'm just gonna drag it over, copy that there and then I'm gonna drag it down to fill those nine blank months with an NA. Then we go into our chart, left click it, right click it, select data. We're going to add series name when I click into that cell that I put K equal nine, series values, delete the stuff that's there, start with my first month and drag it all the way down to the bottom including that one month forecast that we have. Click okay, click okay and we scroll up there. We can see we've added our K equal nine. Let me click out of there so you can see a little better our month and it shifted appropriately so that we know that this month has corresponded to that month. Hope that helps.