HOW TO MAKE KITE DIAGRAMS. The following instructions describe how to use Excel to create the graphs you will need for the field trip poster. See me for help with how to do this and remember to save your work often onto your jump drive. To make Kite Diagrams you first need to open the Kite Diagram Excel sheet found on the class web page. You will have to make a new graph for each of the organisms found along your transect. Fill in the “Number per M2” column on the table (the other columns will fill automatically) Click on a cell on your spreadsheet that has no data in it Click the “Chart” button Click “Area” Click the top left chart sub-type Click “Next” Select the “series” tab at the top of the box Click the “add” button Click the red blue symbol at the right side of the values line Highlight the data values in the “Pos 50% Value For Graph” column on the table (don’t include the title) Click the red blue symbol once more Click the “add” button Click the red blue symbol at the right side of the values line Highlight the data values in the “Neg 50% Value For Graph” column on the table (don’t include the title) Click the red blue symbol once more Click the red blue symbol on the “Category (x) Axis Labels line Highlight the data listed in the “Distance Along Transect” column of the table Click the red blue symbol Click “Next” Under the “Titles” tab click in the values (Y) axis box. Type “# of Organisms name” (this is the name of the organism you are charting now) Under the “Legend” tab remove the check from the “Show Legend” box Click “Next” Check “As New Sheet” Click “Finish” The graph will then show up on the screen Right click on the background of the graph. Pick “format plot Area” Check “Area” “None” Click OK Right click on the top graph area. Pick “Format Data Series” Choose the color you want this graph to be Click “Fill Effects” Click the “Patterns” tab Choose the pattern you want the graph to be. Pick one that will look good but not use lots of ink when printing the graphs. (For each organism pick a different color or pattern!) Click “OK” Click “OK” Right click on the bottom graph area. Pick “Format Data Series” Choose the same color as you picked for the top of the graph. Click “Fill Effects” Click the “Patterns” tab Choose the pattern you picked for the top of the graph. Make sure that the background color is white Click “OK” Click “OK” Right Click on the tab at the bottom of the page called chart 1 (or whatever chart you are now doing) Pick “rename” Type the name of the organism you are graphing (e.g. mud snail) Hit “Enter” Save the document to your jump drive calling it the organism you graphed You are done with this graph now create a new one for the next species, this means you have to close the spreadsheets and start all over again.
Pages to are hidden for
"To make Kite Diagrams you need to open the - DOC"Please download to view full document