Analysis of raw data from excel sheet

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