Look at the equation and shape of the trendline critically: Do they make sense? Is this the simplest possible explanation for the relationship between the two variables? Copy Data and Graphs into a Word Document The purpose of his tool is to find the simplest mathematical model that explains the relationship between the two variables you are graphing. Warning: It is very easy to use the trendline tools to produce nonsense. To clear a trendline, right-click on the trendline and select "Clear". You may need to try a couple of trendlines before you get the most appopriate one. Check the box for "Display equation on chart" Use the simplest equation that you think will cut through all the error bars on your graph. To make a trendline and determine its equation, right-click on a data point and choose "Add trendline." Choose the shape that best describes your graph. Sometimes you want to find (and interpret) the equation that relates the two variables you graphed. If yourerror bars are different, you must choose a error bar size that represents allyour error bars. Then enter the uncertainty for the y-values in the box marked "Fixed Value." NOTE: Excelcan only create error bars that are the same size for all data points. Choose "Both" under "Display" and "Fixed Value" under "Error Amount". Right-click on a data point and choose"Format data series." Click on the "Y error bars" tab. Try changing the color of the plot area, the numbers on the axes and the appearance of the data points. You can also right-click on a feature to get a menu. Once the graph is made, you can modify most features of the graph by double-clicking on the feature you want to change.Choose "As object in" to store the graph in the same worksheet as the data and click"Finish" Screen 4: This screen selects where you will store the graph.Make sure your final graph has a title, axes that are labeled (with units), and no legend. Play with the settings to see what they do. Screen 3: This screen has multiple menus.
Since you did this before starting the Wizard, just click "Next." Screen 2: This screen allows you to choose which data to plot.Screen 1: Choose "XY (Scatter)" and click "Next.".Select all the cells that contain the data that you want to graph.Graphing with Excel Making Graphs in Excel Making/Changing a Graph