AI-Powered Excel Charting: Turn Your Data into Clear Visual Insights

Important note: This training may demonstrate AI tools that are not approved for use with Stanford data. Inclusion in this session does not imply institutional approval. Participants should refrain from entering Stanford data into unapproved tools. An up-to-date list of approved and reviewed tools is available on the GenAI Evaluation Matrix page at https://uit.stanford.edu/ai/genai-tool-matrix.

--------

Transform your Excel charts from basic to brilliant with AI-powered assistance. Discover how to leverage AI Playground, ChatGPT, Microsoft Copilot, and other AI tools to choose the perfect visualization, create professional designs in seconds, and automatically generate data insights that tell compelling stories. Whether you're building simple reports or executive dashboards, explore how AI can turn hours of formatting work into minutes of smart, strategic visualization.

Learning Objectives:
- Build and format all major chart types (column, bar, line, pie, scatter)
- Experience AI recommendations for the best chart type for your data
- Generate professional color schemes and styling with AI
- Explore combination charts and secondary axes with AI guidance
- Create executive dashboards with AI-recommended layouts
- Discover how to automatically generate data narratives and insights from charts
- Troubleshoot chart problems using AI diagnosis
 

Module Breakdown:

Module 1: Chart Fundamentals + AI Recommendations
- Basic chart types and when to use each
- Chart anatomy (axes, legends, titles, data labels)
- Creating and modifying charts
- AI Integration: AI as visualization consultant
- "I have sales data by region and quarter. What chart should I use?"
- AI explains WHY certain visualizations work better
- Hands-on: Use AI to choose optimal chart for various datasets

Module 2: AI-Enhanced Chart Customization
- Formatting chart elements (colors, fonts, styles)
- Adding data labels and annotations
- Professional styling principles
- AI Integration: AI-generated color palettes with hex codes
- AI-written chart titles and annotations
- Hands-on: Transform basic chart to professional quality using AI assistance

Module 3: Advanced Charts + AI Automation
- Combination charts (line + column)
- Secondary axes for different scales
- Sparklines for quick trend visualization
- Chart templates for consistency
- AI Integration: AI-generated chart combinations for complex data
- Automatic trend analysis and forecasting
- AI-provided step-by-step instructions for technical setups
- Hands-on: Build complex dashboard chart with AI guidance

Module 4: AI-Powered Data Stories & Dashboards
- Creating comprehensive dashboards
- Arranging multiple charts effectively
- Dashboard design principles
- AI Integration: AI as data storyteller
- Upload charts and ask "What story does this data tell?"
- AI generates narrative insights and executive summaries
- AI-written VBA scripts for chart automation (no coding required)
- Hands-on: Create 3-chart dashboard with AI-generated insights and summary