Excel Data Bar Chart Dashboard

I have an existing Excel workbook that already holds the core data I need to visualise. What I am missing is a clear, attractive dashboard built primarily with bar charts so that trends and comparisons jump out at first glance.

Here is what I am after:
• Structure the raw sheet(s) so the chart ranges update automatically when new rows are added.
• Design a series of bar charts—clustered, stacked, or cumulative where appropriate—that spotlight the most important figures.
• Lay them out on a dedicated “Dashboard” tab with consistent colours, readable labels, and dynamic titles.

I will supply the current file as soon as we start. If you have ideas for adding slicers, simple VBA buttons, or other interactive touches, feel free to include them—just keep the focus on bar-chart clarity.

The finished workbook should open without errors in the latest desktop version of Excel (Microsoft 365). Once I can refresh the data and see the visuals update smoothly, the job is done.