Schwabish Jonathan. Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks

A K Peters/CRC Press, 2023. — 390 p. — (AK Peters Visualization Series). — ISBN: 978-1-003-32155-2.This book closes the gap between what people think Excel can do and what they can achieve in the tool. Over the past few years, recognition of the importance of effectively visualizing data has led to an explosion of data analysis and visualization software tools. But for many people, Microsoft Excel continues to be the workhorse for their data visualization needs, not to mention the only tool that many data workers have access to. Although Excel is not a specialist data visualization platform, it does have strong capabilities. The default chart types do not need to be the limit of the tool’s data visualization capabilities, and users can extend its features by understanding some key elements and strategies. Data Visualization in Excel provides a step-by-step guide to creating more advanced and often more effective data visualizations in Excel and is the perfect guide for anyone who wants to create better, more effective, and more engaging data visualizations.Introduction
How to Use This Book
The Philosophy of Data Visualization in Excel
Introduction to Making Graphs in Excel
Fundamental Formulas Used in Building Your Graphs
Building a Custom Color Palette in Excel
Sparklines
Heatmap
Stripe Chart
Waffle Chart
Gantt Chart
Comparing Values with Two Graph Types
Broken Stacked Bar Chart
Diverging Bar Chart
Block Shading (Same Frequency)
Block Shading (Different Frequencies)
Mark an Event with a Line
Dot Plot
Slope Chart
Overlaid Gridlines
Lollipop Chart
Bullet Chart
Tile Grid Map
Histogram
Marimekko Chart
Cycle Plot
Strip Chart
Raincloud Plot
Making Better Tables
Exporting Graphs from Excel
Redesigns and Examples
Conclusion
Appendix
Color Tools
Data Visualization Tools
Additional Excel Resources
Quick Instructions List