Google Sheets Expert Needed ( Design important )

I have a growing Google Sheet of raw business data that needs to be turned into meaningful, presentation-ready visuals. The scope centers on data analysis and visualization inside Sheets, followed by building native charts and graphs that update automatically whenever the source data changes.

Key visuals I need:
• line charts
• bar graphs
• pie charts

You’ll start by shaping the data with the right formulas so totals, percentages, and trends recalculate in real time. Once the structure is solid, create the charts directly in the spreadsheet, style them for clarity, and make sure they remain linked to the dynamic ranges (no manual refreshing).

Deliverables:
1. Cleaned and well-structured dataset within the same file
2. Formula layer (SUMIFs, QUERY, ARRAYFORMULA, etc.) that powers the visuals
3. Interactive line charts, bar graphs, and pie charts placed on a dedicated “Dashboard” tab
4. Brief walkthrough or short Loom showing how to extend or edit the setup

If this matches your Google Sheets skill set and you can turn the job around quickly, I’m ready to get started right away.