To make Kite Diagrams you need to open the - DOC by davebusters

VIEWS: 248 PAGES: 2

									                      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.

								
To top