 So in the last video we focused in on just changing our unit sold only when unit sold changes Do we get to see? All these different flexibilities. We still have to come in here and still arbitrarily change this around well That's nice and all but if that's the case Can't we just take that what if analysis and apply that? Here we can actually we can actually create sort of a two variable what if analysis So if we come now over here, and we say for example make a net income analysis Same kind of approach will be brought in. I'll go ahead and clean that up and we're gonna need a little bit more space, so I'm gonna Bring that up to an in there. We are and I'll go ahead and say that we'll be looking at the average price per unit go ahead and Stretch that one out as well as you can see I've already done this once before But now what we're gonna do is we're gonna look at some of the different amounts say for example we start with 1900 I Want to go ahead and check on? $100 increments for the next few rounds see how much am I gonna make? Give or take all of these different segments now. I do want to use the same thing I want to go ahead and use the same number of units sold as well Now one of the things I'm gonna do is I'm also Gonna go ahead and come down here, and I'm gonna make a reference to be 26 Right here in my eye for the same thing we did up here with units So just to showcase off, you know, that's our our money maker So now what I get to do is I get to kind of look and say well one of the things I can do is I can Select these options By going back to the data section going back to what if analysis and selecting data table again Now I have two options a row input cell in a column input cell again for column input cell That's this we're referring to this when this gets put in To that cell when this gets put into that cell so This actually stays pretty much the same thing But our row input our row input is now referring to what happens when this gets put in what happens when this gets put in Etc. That's referring now to b5 when I select okay What I should see happen as you can see is I get a few different numbers now I'm gonna take that format and Clean it up a little bit and we can see suddenly we see that transition of time now How many units are being sold and at what price? Same kind of thing just like we did with one Data point we can take these same numbers and we can actually now graph them We can go in insert make another straight scatter plot clean it up a little bit remove the Title and just clean it up formatting was on the axes We don't need to go so deep. So again, we'll do 300 by 700 and you can see we start to get a little bit of a cleaner look and feel to it now. Let me just Set this up so that it's right in place There we are So now you can start to see each one of these Points that we've done here here here here are being labeled out however, they're being labeled out as you can see as Series 1 series 2 series 3 this is obviously a problem. We don't want say for example series 1 series 2 series 3 We would like to have some type of Label here We can do that by coming to our design tab Inside of our design tab, you notice we have this select data icon this select data icon is going to actually allow us to Label it out. So in this case you see that we have All these different ones now series 1. Alright, that's nice But what's it name? Well, we can come in here and well, it's right there Okay, we can come in here Okay, we can come in here Okay You can see the point we get one more and Last one edit boom beautiful beautiful now I've got a color coordinated guide with each one of my elements