Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
Books, blog, online tutorials, and a wealth of tips and trips for doing data visualization with Excel. Some resources are free, others require enrollment fee.
Storytelling with Data
Books, blog, a regular #SWDChallenge, and a podcast - all to help improve your data visualization skills using Excel.
Many resources and real-life examples of data visualizations. Check out the blog for downloadable data sets with complete instructions for making the charts.
An exhaustive collection of video tutorials and opportunities for free learning, along with download XLS files to practice. Covers all areas of Excel, not just visualization.
Qualitative Chart Chooser 3.0
By Jennifer Lyons and Stephanie Evergreen. Free to download.
R for Data Science
Open access version of the popular textbook. The book is a great learning tool and for reference. It has many examples and exercises.
Data Carpentry Lessons
Curriculum materials for data visualization in R for social sciences, ecology, and geospatial data which can also be used as self-teaching materials.
Cheatsheets for many of the popular R libraries and tasks including ggplot2. Data Wrangling cheatsheet also very useful which is not on page but can be found by searching the site.
ggplot2 Extensions Gallery
View the various extensions that can be added to ggplot2 to enhance its capabilities.
Tools to improve your data visualization
Data Visualization Checklist
Rate your visualization based on 24 guidelines covering text, arrangement, color, lines, and overall visualization to improve how you convey the story of your data.
The Truthful Art by The Truthful Art is an introduction to quantitative thinking and statistical and cartographical representation written specifically for journalists and designers. A follow-up to The Functional Art, it goes into the specifics of how to create functional charts, maps, and graphs.
Publication Date: 2016-02-18
The Functional Art by Unlike any time before in our lives, we have access to vast amounts of free information. With the right tools, we can start to make sense of all this data to see patterns and trends that would otherwise be invisible to us. By transforming numbers into graphical shapes, we allow readers to understand the stories those numbers hide. In this practical introduction to understanding and using information graphics, you'll learn how to use data visualisations as tools to see beyond lists of numbers and variables and achieve new insights into the complex world around us. Regardless of the kind of data you're working with-business, science, politics, sports, or even your own personal finances-this book will show you how to use statistical charts, maps, and explanation diagrams to spot the stories in the data and learn new things from it. You'll also get to peek into the creative process of some of the world's most talented designers and visual journalists, including Condé Nast Traveler's John Grimwade, National Geographic Magazine's Fernando Baptista, The New York Times' Steve Duenes, The Washington Post's Hannah Fairfield, Hans Rosling of the Gapminder Foundation, Stanford's Geoff McGhee, and European superstars Moritz Stefaner, Jan Willem Tulp, Stefanie Posavec, and Gregor Aisch. . The Functional Art reveals: Why data visualisation should be thought of as "functional art" rather than fine art How to use colour, type, and other graphic tools to make your information graphics more effective, not just better looking The science of how our brains perceive and remember information Best practices for creating interactive information graphics A comprehensive look at the creative process behind successful information graphics An extensive gallery of inspirational work from the world's top designers and visual artists
Publication Date: 2012-08-22
Effective Data Visualization by
Publication Date: 2019-05-14
Data Visualisation by Voted one of the "six best books for data geeks" by The Financial Times. Never has it been more essential to work in the world of data. Scholars and students need to be able to analyze, design, and curate information into useful tools of communication, insight, and understanding. This book is the starting point in learning the process and skills of data visualization, teaching the concepts and skills of how to present data, and inspiring effective visual design. Benefits of this book: A flexible step-by-step journey that equips you to achieve great data visualization A curated collection of classic and contemporary examples, giving illustrations of good and bad practice Examples on every page to give creative inspiration Illustrations of good and bad practice show you how to critically evaluate and improve your own work Advice and experience from the best designers in the field Loads of online practical help, checklists, case studies and exercises make this the most comprehensive text available
Publication Date: 2016-08-15
Visual Miscellaneum by The bestselling classic has been revised and updated! A colorful guide to the world's most consequential trivia, Visual Miscellaneum by David McCandless is a reference book like no other. It helps us make sense of our world by putting the data we are bombarded with every day--health findings, technological advances, cultural touch points, war statistics--into creative visual perspective. Like Show Me How by Lauren Smith and Schott's Miscellany, only more complete and satisfying, Visual Miscellaneum is a treat for the mind and the eye.
Publication Date: 2012-10-23
Knowledge Is Beautiful by In this sequel to the bestselling book The Visual Miscellaneum, author David McCandless uses stunning and unique visuals to reveal unexpected insights into how the world really works. Every day, every hour, every minute we are bombarded with information, from television, from newspapers, from the Internet, we're steeped in it. We need a way to relate to it. Enter David McCandless and his stunning infographics, simple, elegant ways to interact with information too complex or abstract to grasp any way but visually. McCandless creates visually stunning displays that blend the facts with their connections, contexts, and relationships, making information meaningful, entertaining, and beautiful. And his genius is as much in finding fresh ways to provocatively combine datasets as it is in finding new ways to show the results. Knowledge is Beautiful is a fascinating spin through the world of visualized data, all of it bearing the hallmark of David McCandless's boundary-breaking, signature style. The captivating follow-up to the bestseller The Visual Miscellaneum, Knowledge is Beautiful offers a deeper, more ranging look at the world and its history, with more connectivity between the pages, a greater exploration of causes and consequences, and a more inclusive global outlook. With a portion of its content crowd-sourced from McCandless's international following, Knowledge is Beautiful achieves a revolutionary and democratic look at the key issues from questions on history and politics, the facts of science, streams of literature, and much more. This is a project that will truly push the boundaries of books everywhere, providing insights into our world in a way never seen before.
Publication Date: 2014-10-21
Publication Date: 2011-07-20
Data Visualization Blogs+
Want to challenge yourself and make new visualizations? Try a
More Cool Data Visualizations