MS Excel - Stat Dashboard, Data arranging/manipulating, displaying meaningful graphs

General information for the business: Small Hotel Management Company Kind of development: Customization of existing program Description of requirements/functionality: I require an Excel sheet to automate data manipulation, and display of statistics, saving a lot of manual work and time to try and figure out which graphs work and how. Basic navigation UI needed. Possibility of generating a 3 month report? Currently this is very time consuming - I am using Google sheets but all number data no graphs just one basic sales graph, now want to move it all into Excel as it is far more powerful and feature rich for the uses I will need and build up of a lot of data over time. Specific technologies required: Excel, VB OS requirements: Windows Extra notes: Your recommendation and ideas welcome, and if you have done similar job before - Full Criteria and Scope inside the attachment