WHAT THIS VBA DASHBOARD DOES

Automatically:

• Reads data from a sheet named RawData
• Detects:
• Numeric columns → totals, averages, min, max
• Text columns → counts & distributions
• Creates a Dashboard sheet with:
• KPI summary table
• Category breakdown table
• Charts:
• Column chart (numeric totals)
• Pie chart (top category distribution)
• Formats everything for CEO / Executive view