Get the free plot diagram maker form

Instructions and Help about plot diagram maker form

Hi in this session I'm going to cover how to create an XY scatter chart now the reason why we would use an XY scatter chart is to see the relationship or the correlation between two values, so we would have an x the x-axis we have a column that kind of represents our x value which will be here on our x-axis, and we have a column that will represent our Y values which would be on our y-axis now the x-axis would be our independent variable, so it's not dependent on anything and the y-axis is our dependent variable so that basically would depend it on the values of the x-axis so here's this kind of small table of our X variable or X values and our Y values so basically what we're saying here is as the temperature decreases we are seeing an increase in the sales of jackets now we may have other types you may have another type of table where you would see a different x value and different Y values, and you want to see the relationships or the correlation between those two values and us XY or scatter chart would show that relationship so let's see how we create this type of chart let me go ahead and bring this table over select that control-c bring it into a new worksheet and paste the value there let's double-click this column the lines here in between the columns just to autofit let's make this a little bigger and basically what we can do is since there's these there are no breaks within the cells I can just select any of the cells and go into insert chart I'm excuse me insert charts scatter, and we're going to select the scatter with the markers and basically this gives us our scatter chart we don't need this here I usually take away the legends like that delete take away the grid lines here, and we can see here it says we have just a few I mean not that many values we can see that it's kind of a downward trend but what you can also do is you can add a trend line, so you can select any of those values select that and right click, or I think you can go to layout let's see me do layout or format it doesn't let you do that, but I let's do it manually it would do you have these two these a chart layouts that you can see one is it what a trend line but if you didn't want to use those and have these extra grid lines so if you selected that it will have all these grid lines here that's undo that the other way to do it is just to select the values see these markers here for the values and right click that and add trend line it's going to give you the format trend line dialog box, and basically we just select what it has here usually I just select linear I'm not too familiar with the other ones a logarithmic or polynomial or moving average in relation to the trend line here, but usually I can just I just select that and click close, and you can see that there's a downward trend in the data here now we have this our Y value goes down negative here which we really don't have in our table here so what we can do is we can click that and right click it and go to...