Knowing the species composition of your plot can help you start answering research questions from wildlife habitat to woodlot value to carbon storage.
Follow these steps to create a pie chart that shows the species composition of your plot using one year of data.
- Find your plot on the ALL PLOT DATA page: http://mainefig.org/all-fig-data/
- Under SURVEY DATA, tap YEAR: view data table
- Scroll down to the very bottom of the page, and tap DOWNLOAD THIS DATASET
- Open your new file in Excel
- Organize your data by species:
- In the Excel menu, tap Sort & Filter > Filter
- In the Species cell, tap the down arrow, and select Sort A to Z
- Get counts of each species:
- Build a new table next to your dataset
- List each species name in one column
- Put the total number of each species in the column next to it
- Create your pie chart:
- Highlight the table you just built in Step 6
- In the Excel menu, tap Insert
- In the Insert menu, tap the pie chart (2-D)
Taaah-daaah! You did it.
- To simplify your pie chart to compare hardwood and softwood species:
- Build another table underneath your species count table
- List hardwood and softwood in one column
- Put the total number of hardwoods in the column next to “hardwoods”
- Put the total number of softwoods in the column next to “softwoods”