Dynamic Excel Sales Dashboard

I need an Excel-based dashboard that turns my raw sales tables into clear, at-a-glance insights. The focus is strictly on two areas: overall sales revenue and individual product performance; I’m not tracking customer demographics right now.

Visually, I’m looking for a clean mix of bar charts to compare product lines side-by-side and line charts to show how revenue trends evolve over time. The workbook has to refresh smoothly every day, so please plan for an automated data pull or a one-click Power Query/Pivot refresh that keeps formulas and visuals in sync without manual intervention.

Deliverables I expect:
• A single Excel file containing the fully formatted dashboard, supporting data model, and refresh logic
• Brief, step-by-step notes inside the workbook (or a short read-me sheet) explaining how I update data daily and how any slicers/filters work

If you’ve built similar revenue and product tracking dashboards before, let me know—especially if you’re comfortable with dynamic ranges, Pivot Charts, and Power Query.