How to Create a Regression Equation Chart in Excel 2003

1. Input your data into your spreadsheet in two columns. For example, use fertilizer use and crop yield. Make sure the data 'lines up' -- that the fertilizer use and crop yield of plot A are in the same row; the same for plot B and so on.
2. Select the height and weight data that you want to graph and use the Chart Wizard to plot the data. The dependant variable, the one that you expect is affected by the other variable (in this case crop yield), should be on the y-axis.
3. Right-click on one of the data points on the graph and select 'Add trendline.'
4. Select the 'Linear' trend/regression type and then click on the 'Options' tab.
5. Tick the box for 'Display equation on chart' and click 'OK.'
6. Move the text box containing the equation to somewhere clear of data points to improve the clarity of the graph.