Overview
Data visualization isn’t just about charts—it’s about making numbers clear, compelling, and memorable. This two-day course takes you from Illustrator’s built-in Graph tools through advanced custom visualization techniques, giving you the skills to transform spreadsheets into professional infographics that inform and engage.
You’ll work with Excel data integration, customize chart appearances to match brand guidelines, build sophisticated visualizations from scratch, and create accessible, reusable templates for ongoing projects. Whether you’re creating annual reports, marketing dashboards, or editorial graphics, you’ll learn to communicate data with clarity, style, and professional control.
Format: 2 Days | VILT
Who Should Attend
- Designers creating data visualizations, infographics, and reports
- Marketing and communications professionals presenting data visually
- Information designers and visual journalists
- Anyone who needs to transform spreadsheet data into compelling graphics
What You’ll Learn
- Create and customize charts using Illustrator’s Graph tools
- Import, analyze, and update data from Excel including pivot charts
- Perform roundtrip editing between Illustrator and Excel
- Apply Excel visual chart styles directly in Illustrator
- Build custom visualizations manually for complete creative control
- Design radial, proportional, and grid-based infographics
- Create custom sliding, scaling, and stacking symbol column designs
- Apply accessibility best practices to data visualization
- Develop reusable infographic templates and design systems
Course Outline
Module 1: Illustrator Graph Tools Fundamentals
- Chart types: column, bar, line, area, pie, scatter, and radar
- Creating charts from scratch and from data
- Understanding the Graph Data window
- When to use Illustrator charts vs. other visualization tools
Module 2: Excel Integration and Data Management
- Preparing data in Excel for import into Illustrator
- Using Excel for data analysis and pivot charts before visualization
- Importing Excel data into Illustrator graphs
- Roundtrip editing: updating data in Excel and refreshing in Illustrator
- Applying Excel visual chart styles inside Illustrator
Module 3: Customizing Chart Appearance
- Ungrouping and editing chart elements for custom styling
- Applying custom colors, typography, and brand guidelines
- Creating custom sliding, scaling, and stacking symbol column designs
- Building custom graph designs with symbols and patterns
- Balancing editability with visual customization
Module 4: Information Hierarchy and Visual Storytelling
- Principles of effective data visualization
- Creating visual hierarchy: what viewers see first, second, third
- Using color, scale, and position to emphasize key data
- Building narrative flow through sequential graphics
- Avoiding common data visualization mistakes and misleading graphics
Module 5: Building Infographic Templates
- Planning infographic structure and layout flow
- Combining charts, icons, and explanatory text
- Creating reusable layouts and graphic styles
- Building template systems for recurring reports and dashboards
Module 6: Manual Chart Construction
- Why and when to build charts manually instead of using Graph tools
- Calculating proportions and translating data to visual elements
- Building bar, column, and area charts from shapes
- Creating line charts with precise data points and control
Module 7: Radial and Circular Visualizations
- Constructing pie and donut charts with complete control
- Radial bar charts and rose diagrams
- Circular timelines and cyclical data visualization
- Using rotation and transformation for radial layouts
Module 8: Proportional and Grid-Based Systems
- Unit charts and pictorial statistics
- Waffle charts and grid-based proportions
- Treemaps and area-based visualizations
- Isotype-style graphics and visual counting systems
Module 9: Visual Metaphors and Iconography
- Using metaphor to make data relatable and memorable
- Illustrated data: when and how to stylize visualizations
- Designing icons that scale and communicate clearly
- Building consistent icon families for data categories
- Creating symbols and reusable icon libraries
Module 10: Accessibility in Data Visualization
- Color choices for color-blind accessibility
- Patterns, textures, and redundant encoding for clarity
- Text alternatives and labeling strategies
- Testing visualizations for accessibility compliance
Module 11: Building Reusable Visualization Systems
- Creating visualization templates and style guides
- Documenting systems for team use and consistency
- Building Graphic Styles and Symbols for ongoing projects
- Managing libraries for repeated visualization elements
Module 12: Export and Delivery
- Preparing infographics for print: resolution, color, and bleeds
- Exporting for web: PNG, SVG, and interactive considerations
- Creating multiple sizes from a single source file
- Packaging files for clients, collaborators, and production teams
Prerequisites & Technical Requirements
- Intermediate Illustrator experience (comfortable with shapes, layers, and basic tools)
- Adobe Illustrator CC (current or recent version recommended)
- Microsoft Excel for data preparation and analysis exercises
Customization Options
This course can be customized around your data types and deliverables—financial reports, marketing metrics, scientific data, or editorial infographics. Bring your actual datasets and brand guidelines, and we’ll build infographics and visualization systems you can use immediately in your ongoing projects.