Plotting Graphs in Excel



centercenterqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnm100000100000qwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmPlotting Graphs in ExcelFor Use with Your Hooke’s Law Data2017J A HARGREAVESUse of Excel 2010 Physics- A Graph of Hooke’s Law2139433431540Insert data, or open up your existing spreadsheet.020000Insert data, or open up your existing spreadsheet.7816853359160038449251943100Click on Home4000020000Click on Home31438852830195Highlight data to be plotted. Click on Insert, then select“Scatter”00Highlight data to be plotted. Click on Insert, then select“Scatter”1103176366232042586563676765First highlight the data that you want to plot. As these are not next to each other you should click in the first column and drag down the cells that you want to plot, then holding down the CONTROL key repeat for the other column. This involves the left mouse- try it!Go to INSERT and then SCATTER graph. Plot the first graph the dots without lines.00First highlight the data that you want to plot. As these are not next to each other you should click in the first column and drag down the cells that you want to plot, then holding down the CONTROL key repeat for the other column. This involves the left mouse- try it!Go to INSERT and then SCATTER graph. Plot the first graph the dots without lines.29452466720610053244752658110The quick way to make a good graph is to select the template within the DESIGN tab, with a straighline and lots of gridlines. This will almost give the graph we want which we can just edit. However, if you want to start from scratch see the next slide and advanced section.4000020000The quick way to make a good graph is to select the template within the DESIGN tab, with a straighline and lots of gridlines. This will almost give the graph we want which we can just edit. However, if you want to start from scratch see the next slide and advanced section.Do check that your gaph looks correct. Sometimes Excel has a huff and produces nonsense. Usually you need to go back start again and only highlight the data and not the headings! It doesn’t like blanks in cells, so don’t leave any!351675257175You can then insert Chart and Axes Titles and label axes with units. Ensure the graph has been selected.Click on Chart Tools – Layout.Click on Legend – select none.You can then insert Chart and Axes Titles and label axes with units. Ensure the graph has been selected.Click on Chart Tools – Layout.Click on Legend – select none.42652953303905You want to delete this “legend” as it is taking up too much. Select this legend and click delete You want to delete this “legend” as it is taking up too much. Select this legend and click delete 77806559277350059517733135677We want to move the graph as it is too small. Click on move chart within the design menu and click move to a new page and it will fill a whole A4 page.We want to move the graph as it is too small. Click on move chart within the design menu and click move to a new page and it will fill a whole A4 page.4676775-1720850Once you get the move chart option click on “ new sheet” and give your graph a name. In this case Hooke’s Law Once you get the move chart option click on “ new sheet” and give your graph a name. In this case Hooke’s Law 24873592856858Click on the axes and give them names. It ought to have a quantity and unit. These are separated by a “\”00Click on the axes and give them names. It ought to have a quantity and unit. These are separated by a “\”24789701179061Click on the axes and give them names. It ought to have a quantity and unit. These are separated by a “\” Titles can be added to this box and click return when finished.00Click on the axes and give them names. It ought to have a quantity and unit. These are separated by a “\” Titles can be added to this box and click return when finished.35863161532302We want small points or crosses not great blobs. Click on the data points on your graph to highlight them, then right click on the mouse until you get a format data series menu. At the bottom. Click on format data series and then change the marker options from the built in menu to about 5 point and + or x shape.00We want small points or crosses not great blobs. Click on the data points on your graph to highlight them, then right click on the mouse until you get a format data series menu. At the bottom. Click on format data series and then change the marker options from the built in menu to about 5 point and + or x shape.31081441179061Click on the Chart Title in the Layout menu and give your graph a name. In this case it can be Hooke’s Law, but generally for graphs you would give it the title of “A Graph of {Y axis} against {X- axis}” by {Name}00Click on the Chart Title in the Layout menu and give your graph a name. In this case it can be Hooke’s Law, but generally for graphs you would give it the title of “A Graph of {Y axis} against {X- axis}” by {Name}37792643083362Now we can format our axis and make sure our scale is the best it can be. Either right click on the axis or go to the top menus. Set the scale to be as large as possible with minimum gap at the top.00Now we can format our axis and make sure our scale is the best it can be. Either right click on the axis or go to the top menus. Set the scale to be as large as possible with minimum gap at the top.5054390919002A different way to get to the axes menu00A different way to get to the axes menu55409521657233The axis menu. Fix the maximum and minimum values. Make sure that the minor units are multiples of the major unit. Or your scale will be terrible! Try it you can always change it!Repeat for the other axis. You can use a different scale –use what fits!00The axis menu. Fix the maximum and minimum values. Make sure that the minor units are multiples of the major unit. Or your scale will be terrible! Try it you can always change it!Repeat for the other axis. You can use a different scale –use what fits!49041051382395These are the settings I used for the X-axis.00These are the settings I used for the X-axis.Additional Information – Advanced Graphing & Alternative methodsUse of Excel 2010 in AH Physics781685335916002095503435985Insert data, including uncertainties.Full stop in front of uncertainties stops “arith. operation”.020000Insert data, including uncertainties.Full stop in front of uncertainties stops “arith. operation”.38449251943100Click on Home4000020000Click on Home1153160372110004058285154368500105791021723350031438852830195Highlight data to be plotted. Click on Insert, then select“Scatter”00Highlight data to be plotted. Click on Insert, then select“Scatter”46012103625850025723851200785002991485228663500309626010960100045021502638425Click on Legend – select none.4000020000Click on Legend – select none.45974001509395Ensure the graph has been selected.Click on Chart Tools – Layout.4000020000Ensure the graph has been selected.Click on Chart Tools – Layout.44354753305175You can then insert Chart and Axes Titles and label axes with units. 4000020000You can then insert Chart and Axes Titles and label axes with units. 5020310252476000424878512769860037782502914650Select Gridlines. Insert Major and Minor Gridlines – horizontal and vertical.Again ensure the graph has been selected.4000020000Select Gridlines. Insert Major and Minor Gridlines – horizontal and vertical.Again ensure the graph has been selected.475361092456000629666031819850040354253905250Click on Trendline Select “More Trendline Options”.Select “linear” if appropriate.4000020000Click on Trendline Select “More Trendline Options”.Select “linear” if appropriate.30391103439795Click on “Display Equation on Chart”020000Click on “Display Equation on Chart”49726854556125Custom Error Bars592518525603200036772852560955Click on Error Bars – select More Error Bars Options020000Click on Error Bars – select More Error Bars Options3801110317246000426783516865600031724601439545Select BothClick on Custom and then Specify Value020000Select BothClick on Custom and then Specify Value65633602515235Click to highlight data insertion box.020000Click to highlight data insertion box.5001260289623500298196035629850026104853029585001682753562350Click and drag down column to insert value of +Y in data box.Repeat for Negative Error ValueClick Okay4000020000Click and drag down column to insert value of +Y in data box.Repeat for Negative Error ValueClick Okay33058102258060026638251514475To select horizontal error bars, click on any horizontal error bar on the graph.4000020000To select horizontal error bars, click on any horizontal error bar on the graph.4221480819150Changes to Horizontal Error Bars020000Changes to Horizontal Error Bars2514601735455This should now read “Horizontal Error Bars”.Repeat the procedure to enter customised horizontal error bars.This should now read “Horizontal Error Bars”.Repeat the procedure to enter customised horizontal error bars.548894016458630064109602362835Click to highlight data insertion box.020000Click to highlight data insertion box.503936029806900026612851752600Click, Drag down vertical column to insert data in box.Click okay020000Click, Drag down vertical column to insert data in box.Click okay3816351705610Doubleclick or right click just next to one of the points.Format Data Series should open.If you get Format Trendline or Format Error bar then you have clicked on the line, point or error bar.00Doubleclick or right click just next to one of the points.Format Data Series should open.If you get Format Trendline or Format Error bar then you have clicked on the line, point or error bar.To change dot size / shape. ( Use Format Data Series59728103036570004934585279844500449643522555200042964104503420Select Marker Options. Built in. Choose style and size020000Select Marker Options. Built in. Choose style and size)Increase the size of the graph to at least half a page.2553335154368500Uncertainty in Gradient, Intercept - Use of Linest46482004598670Hold down Ctrl, Shift and press enter.(CMD, Shift and enter on Apple computers).00Hold down Ctrl, Shift and press enter.(CMD, Shift and enter on Apple computers).4102105217795Y Range of Cells0Y Range of Cells838835458914519532604589145015151105227320X Range of Cells0X Range of Cells2673353512820Highlight four cells. Type in =LINEST(B2:B6,A2:A6,TRUE,TRUE)400000Highlight four cells. Type in =LINEST(B2:B6,A2:A6,TRUE,TRUE)1553210397256000313436039725600032581854665345Uncertainty in Y Intercept020000Uncertainty in Y Intercept291528545351700017056104516120004483104792345Uncertainty in Gradient020000Uncertainty in Gradient37153853620770Y Intercept020000Y Intercept4483103754120Gradient020000Gradient ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download