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
Land Development Financial Model Customization Category: Data Analysis, Excel, Finance, Financial Analysis, Financial Modeling, Graphic Design, Project Management, Real Estate Budget: $750 - $1500 USD
How to draw head turn 360 degrees Category: 2D Animation, 2D Drawing, 2D Game Art, 3D Animation, Animation, Art Consulting, Character Illustration, Graphic Design, Illustration, Video Production Budget: $10 - $30 USD
Social Media Content Strategist Category: Content Strategy, Content Writing, Copywriting, Digital Marketing, Graphic Design, Internet Marketing, Social Media Management, Social Media Marketing Budget: £750 - £1500 GBP