How to Use ChatGPT to Build an Interactive Excel Dashboard (Step-by-Step)

📥 Download FREE Dashboard + VBA Code Files Here 👇
https://docs.google.com/document/d/1fXlZ7mcesQuyMBmfKhiMWDM_aJF-5BtrpFugeadLdLU/edit?usp=sharing

In this Excel tutorial, you'll learn how to use @OpenAI's ChatGPT to create a fully interactive, automated Excel dashboard — from start to finish.

We’ll begin by analyzing the raw dataset and designing a clean dashboard layout using Excel shapes and cards. Then, we’ll group and summarize the data with pivot tables, build beautiful charts and graphs, and finally make the entire dashboard dynamic using slicers.

But here’s the twist — we’re not building this manually. We’ll use AI tools like ChatGPT (and even Claude AI) to write all the VBA code for us — including layout, pivot tables, and chart automation.

If you're a beginner, student, or Excel enthusiast — this tutorial is for you.

👉 Like the video, drop your thoughts in the comments, and don’t forget to subscribe for more AI-powered Excel tutorials!

#excel #exceltutorial #excelautomation #chatgpt
🕒 Chapters:
0:00 - What You'll Learn and Steps
0:48 - Analyzing Dataset
1:36 - Dashboard Layout (ChatGPT)
3:07 - Dashboard Pivot Tables (ChatGPT)
6:00 - Dashboard Charts/Graphs (Claude AI)
10:00 - Making Dashboard Interactive / Dynamic
18:00 - Conclusion

📌 Prompts Used in This Tutorial:

Prompt 1 – Get Insights from Sample Data
I’m creating an Excel dashboard using the following dataset:
Date, Month, Year, Customer Name, Customer Type, Service, Department, City, Sales Amount, Sale Type, Customer Source, Package Type
Please analyze this data and suggest:
• Key insights
• KPIs to track
• Suggested chart types for each insight
• Any trends or segmentation I should highlight (e.g., by Customer Type, Service, City, etc.)
The dashboard should be focused on sales performance and customer behavior.
Prompt 2 – Create Dashboard Layout with Shape Cards
Based on the KPIs and visuals identified earlier, please write a VBA script that:
1. Creates a new sheet called Dashboard
2. Adds shape-based KPI cards with the following labels:
o Total Sales
o Number of Customers
o Top City
o Sales by Customer Type
o Sales by Service
o Sales Trend (Monthly)
3. Adds section headers using rectangles or rounded shapes
4. Applies clean formatting (e.g., light gray background, bold fonts, modern look)
5. Leaves placeholders for future charts below the KPI cards
Please make the code modular and add comments for each part.

Prompt 3 – Generate Pivot Tables in VBA
Now write a VBA script to create Pivot Tables in a new sheet called Pivots based on this dataset:
Date, Month, Year, Customer Name, Customer Type, Service, Department, City, Sales Amount, Sale Type, Customer Source, Package Type
I need the following pivot tables:
• Total Sales by Month
• Sales by Customer Type
• Sales by Service
• Sales by City
• Sales by Package Type
Each pivot table should be formatted, have proper row/column fields, and summarize Sales Amount. Please add comments in the VBA code.

Prompt 4 – Prompt for VBA to Create Charts Based on Pivot Tables
Please write VBA code to insert charts into the “Dashboard” sheet using the pivot tables from the “Pivots” sheet.
The charts should include:
1. Line Chart: Sales Trend by Month
2. Pie Chart: Sales by Customer Type
3. Column Chart: Sales by Service
4. Bar Chart: Sales by City
Each chart should be styled professionally (titles, colors, no clutter) and placed neatly under its corresponding section on the Dashboard. Use consistent colors and layout spacing.
Clear Air - Somewhere Sunny by Kevin MacLeod is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/

Source: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100626

Artist: http://incompetech.com/

Видео How to Use ChatGPT to Build an Interactive Excel Dashboard (Step-by-Step) канала Data with Dilawar