Graphing in excel
The following example will show you how to make a scatter plot, add a linear regression trend line, and how to fine tune the graphs appearance.
Making a scatter plot
Box 3. Graphing basics.
Once your graph is made it will automatically be updated to reflect any changes you make to the data used to create the graph.
To modify most things on your graph use the Layout Ribbon.
Modify the chart layout, the chart must be selected.
The default formatting offered by Excel is rarely appropriate for science
Most formatting can be done from the Home Ribbon, or by right clicking a cell(s) and selecting ‘Format Cells’. The Format Cells window has several tabs that control most cell features (see Figure 16). For example, under the Number tab you can select a variety of formats for the cell contents. If you format the cell contents as Number, you can set the number of decimal places (Excel will automatically round the number for you). Once you have formatted a cell as a number, any non-number characters are ignored by Excel when the data is sorted.
To change sheet formats (adding Headers or Footers, adding grid lines etc.) use the Page Layout Ribbon.Often you will find you want to insert a spreadsheet directly into a report you are writing. If you are working with Word and Excel, there are two ways to add spreadsheets to a Word document. You can create the spreadsheet directly in Word by choosing Excel Spreadsheet from Insert > Table. When you create an Excel spreadsheet in Word, you are actually working in Excel (notice when you are in the spreadsheet the ribbon’s change to Excel ribbons). The second way is to select the cells in Excel, copy the cells and then paste them into Word. The Excel cells will be converted into a Word table. The cells will now behave as a Word table, not as a spread sheet.