Free ebook
Free ebook: Excel Charts & Data Visualization
A hands-on guide to creating clear, effective Excel charts: choosing the right chart type, formatting for readability, combo charts with dual axes, sparklines, and building dashboard-ready visuals. Real worked examples throughout.
Get the ebookCourse path
Turn Charts & Visualization into a course path
Charts & Visualization strings this into a structured, mixed-friendly path with a full lesson list.
View course path5 subtopics in this path
Chart selection, formatting, combo charts, sparklines, conditional formatting, map-style visuals, and storytelling with data.
Each item pairs the learning structure with curated public YouTube resources where available, so learners can move from outline to video practice quickly.
Pick bar, column, line, pie, scatter, or combo charts based on the question your data answers.
Leila Gharani
Open on YouTube (opens in a new tab)
Leila Gharani
Open on YouTube (opens in a new tab)
Clean titles, axes, labels, legends, colors, and gridlines so charts are easier to read.
Leila Gharani
Open on YouTube (opens in a new tab)
Leila Gharani
Open on YouTube (opens in a new tab)
Chandoo
Open on YouTube (opens in a new tab)Combine chart types and use secondary axes without misleading the reader.
Highlight trends, exceptions, heatmaps, duplicates, and top/bottom values directly in cells.
Add compact trend visuals inside cells for dense reports.
Real Excel screenshots showing what this topic looks like in practice.
Leila Gharani
Strong starter lesson for choosing, creating, formatting, and extending Excel charts.
Open on YouTube (opens in a new tab)Leila Gharani
Directly teaches dynamic chart highlighting, a key visualization skill beyond basic chart tutorials.
Open on YouTube (opens in a new tab)Leila Gharani
Useful for making business charts more visual without leaving Excel.
Open on YouTube (opens in a new tab)Leila Gharani
Specialized chart tutorial for project and reporting timelines.
Open on YouTube (opens in a new tab)Leila Gharani
Teaches polished chart design for learners improving the visual quality of reports.
Open on YouTube (opens in a new tab)
Simon Sez IT
Course-style framing and dashboard connection make it a strong visualization resource.
Open on YouTube (opens in a new tab)
freeCodeCamp.org
Dedicated data-visualization course format is highly relevant for chart and dashboard learners.
Open on YouTube (opens in a new tab)
Kevin Stratvert
Accessible tutorial for learners who need a practical introduction to Excel chart creation.
Open on YouTube (opens in a new tab)Chandoo
Targets advanced charting for dashboards, a strong match for visualization-focused paths.
Open on YouTube (opens in a new tab)
Kenji Explains
From-scratch advanced chart builds help learners add sophisticated visuals to reports.
Open on YouTube (opens in a new tab)
Technology for Teachers and Students
Extracted from saved YouTube search results - titled "Quick and Simple Charts", filed under Charts & Visualization for its charts coverage.
Open on YouTube (opens in a new tab)
Atil Gurcan
Extracted from saved YouTube search results - titled "Data Visualization & Co Authoring", filed under Charts & Visualization for its co-authoring coverage.
Open on YouTube (opens in a new tab)26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
ExcelJet (opens in a new tab)
MyOnlineTrainingHub (opens in a new tab)
XelPlus (opens in a new tab)
Excel Campus (opens in a new tab)
Wise Owl (opens in a new tab)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)Course platforms
