I'm working on analysing the data in this sheet - mainly the 'Raw Data' sheet. I need to show year on year trends in bird population changes. You can see at the bottom of this raw data sheet many graphs. I know there is a way of anaysing ths data using pivot tables and slicer filters which is what I would like to make on a new sheet within this document. I'd like to be able to show graphs for each species, count quality on Y axis and years on the X-axis. be able to filter and the graph from one species to another. I had a similar sheet made for another purpose like attached. You may also have other ideas on how to present and analyse this information. There will likely be more work on this as my colleage also has monthly bird count data which we will would also like to analyse later. There are more 'live data' sheets we can try later. Mark
Apartment Conversion for Increased Rental Income Category: AutoCAD, Building Architecture, Building Regulations, Construction, Construction Management, Home Design, Interior Design, Project Management Budget: $750 - $1500 USD
4K Creative Promo Video Edit Category: After Effects, Animation, Color Grading, DaVinci Resolve, Final Cut Pro, Video Editing, Video Services Budget: $30 - $250 USD
