RE: Dashboarding
you can put the data into a pivot table and use pivot chart and slicers to achieve what you are asking

google dashboard pivot table slicer and there should be some videos on how to do it

its important you understand how to do it from scratch rather than have something ready built so you can maintain/change/edit it ongoing
so have a go at it and if you have certain hiccups i can help trouble shoot you thru it