Hello - thank you for posting your excel workbooks. Do you have a Tableau Workbook to show what you have atttempted so far? The way to easily achieve a view such as this in a single view is by the use of a Tableau Dashboard. There are several training videos under the Strories and Dashboards area of this page - Tableau Training and Tutorials that will assist you in building a single view as desired.
I hope this helps.