Can I pivot this worksheet

[Trebor777]

Hi, the worksheet below is fictional. I created it to show the structure of the table I am trying to analyse.

I am a total newbie to pivot tables & charts. I have read a lot, but have no practical experience. What I am trying to do is not as simple as the examples I have seen.

The fictional sheet covers 3 months daily sightings of birds from 3 regions of the UK. There are several blank elements & rows. (The blank elements actually contain zero values, but have been formatted to show blank.)

My 1st question is ....... Can I pivot this worksheet to show a stacked bar chart with months along the x-axis, and vertical stacked bars showing the total counts for each species, for the UK as a whole (apologies to Ireland), or do I need to simplify the original sheet?

Hope this is clear, I repeat I am a total newbie. KK