Thursday, June 20, 2013

Calculate Grid

Create a grid with a spreadsheet or a pencil.


Graphs and grids show data in visual form. It's easier to compare numbers and understand the relationships between them when they are plotted on a grid. It's possible to draw grids with a ruler and pencil, but it's more usual now to create them in a spreadsheet.


Instructions


1. Enter your data points into the Excel spreadsheet.








2. Choose "Chart" from the "Insert" drop-down menu. A series of dialogue boxes will take you through formatting the graph. Click "Next" to select which kind of graph you want.








3. Choose line graph. Other choices of graph type include pie, bar and surface. These will not show your data on a grid.


4. Select row or column in the next dialogue box, depending on how you entered your original data.


5. Enter the coordinates of range of data you want to appear on your grid. Click "Next."


6. Select major grid lines if your data points are numerically far apart. Select major and minor grid lines if your data points are close together. Click whether to insert the graph in the current document or create a new document.

Tags: your data, data points, your data points, Click Next, grid lines, grid lines your