Excel Charts & Reporting Automation

I need an Excel expert who can turn my raw data into clear, up-to-date charts and summary reports. The goal is a “smart” workbook that updates itself whenever I drop in new numbers, so logical formulas, dynamic ranges, or even light VBA are welcome if they make upkeep effortless. Once we start, I’ll share the data set and the key metrics I care about; I’m open to your advice on the most effective chart types and layout. The finished file should be easy for me to maintain without additional help. Please include samples of past work that show similar dashboards or report-driven spreadsheets you’ve created so I can quickly see your style and approach. Deliverables: • A single Excel (.xlsx) workbook containing automated charts and reports • Any supporting formulas or macros already embedded and documented • Brief instructions on how I can refresh the data and visuals in the future