If you have a scatter plot and you want to highlight the position of a particular data point on the x- and y-axes, you can accomplish this in two different ways. As an example, I’ll use the air temperature and density data that I used to demonstrate linear interpolation.

Hello there, this is hopefully a fairly short, quick example on how you can do graphing in Microsoft Excel as well as to do a linear fit and to find the value and the uncertainty of the resulting fitted slope and intercept Here I am using Excel 2010, so your screen may look a little different in terms of the layout, especially the toolbars up here but hopefully the steps will be fairly similar. Of course, the first step here is to enter in data In this case, I am using a simple Hooke's Law example so we have 'force' and 'change in length' as well as the uncertainties, because that will be important when we go and do our error bars Let's get a graph going here. To select multiple columns of data, first you select the first column, and then. You press CTRL to select the second column. Svg software for mac. To repeat that, you select the first one first, and then.

CTRL, then select the second one. Then you go 'Insert' -> 'Scatter' and we want a scatterplot Make this a little bigger. Now, Excel is sometimes too smart for its own good It decided that whatever column we have on the left is the x-axis but since we're doing the Hooke's law graph, we usually want the force to be on our y-axis. To swap them around or to select any new data, you right-click on the graph area and go 'Select Data.' Series 1, you go edit it clean out this stuff and select the correct x-data and clean out that stuff to select the correct y- data and OK so finally we have our forces on the y, and our change in length on the x Legend we don't really need as long as we are only graphing one thing on the graph Then what we need.we need error bars Error bars, they are hidden right now, so the first thing you need to do is to come up with any error bars and that's under 'Layout' -> 'Error Bars' and select any one of these. And once they are exposed, then we can click on it, right-click on it, and format it to get the right value we want most of the time, we have custom error bars that we specify and so this will allow us to select the whole range of data to have a different error bar for different data points.

This is vertical, so our 'dF' and that's what happens if you don't clean stuff out before selecting data; it adds in extra stuff and now for your horizontal. Do the same thing so fairly quickly, we have already got our points plotted, and our error bars plotted, and our scales are fairly well chosen so that's the advantage of graphing by computer instead of by hand to complete the graph, we of course need a title and personally, I perfer a very very long descriptive title that tells exactly what's going on why you are doing the graph and also a little about the method of how you did it then we also need axes labels this bottom here: we need the name 'change in length', symbol 'x', and unit 'm' for meters. And also for the other vertical one. 'Force', 'F', 'N' so the graph is more or less complete in the sense that we have got a title and points with error bars Next step of course is becasue we know it's a linear relationship and we need to get the spring constant, we need to do a fit Excel does do it automatically for you and that's if you right-click on any point and go 'Add Trendline.' And when you add this trendline, you can choose a linear trendline, and also to have the equation displayed on the chart So you can see right away that the relationship is fairly linear. This best fit line does in fact hit through all the error boxes, which is good.