ABSTRACT

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.

part 1|82 pages

Setting the Stage

chapter Chapter 1|8 pages

Introduction

chapter Chapter 2|5 pages

How to Use This Book

chapter Chapter 3|7 pages

The Philosophy of Data Visualization in Excel

chapter Chapter 4|27 pages

Introduction to Making Graphs in Excel

chapter Chapter 5|20 pages

Fundamental Formulas Used in Building Your Graphs

chapter Chapter 6|10 pages

Building a Custom Color Palette in Excel

part 2|240 pages

Making Graphs in Excel

chapter Chapter 7|4 pages

Sparklines

chapter Chapter 8|8 pages

Heatmap

chapter Chapter 9|5 pages

Stripe Chart

chapter Chapter 10|7 pages

Waffle Chart

chapter Chapter 11|13 pages

Gantt Chart

chapter Chapter 12|10 pages

Comparing Values with Two Graph Types

chapter Chapter 13|11 pages

Broken Stacked Bar Chart

chapter Chapter 14|8 pages

Diverging Bar Chart

chapter Chapter 15|6 pages

Block Shading (Same Frequency)

chapter Chapter 16|8 pages

Block Shading (Different Frequencies)

chapter Chapter 17|17 pages

Mark an Event with a Line

chapter Chapter 18|11 pages

Dot Plot

chapter Chapter 19|14 pages

Slope Chart

chapter Chapter 20|8 pages

Overlaid Gridlines

chapter Chapter 21|6 pages

Lollipop Chart

chapter Chapter 22|12 pages

Bullet Chart

chapter Chapter 23|18 pages

Tile Grid Map

chapter Chapter 24|18 pages

Histogram

chapter Chapter 25|12 pages

Marimekko Chart

chapter Chapter 26|9 pages

Cycle Plot

chapter Chapter 27|6 pages

Strip Chart

chapter Chapter 28|12 pages

Raincloud Plot

chapter Chapter 29|8 pages

Making Better Tables

part 3|24 pages

Moving Visuals Out of Excel

chapter Chapter 30|6 pages

Exporting Graphs from Excel

chapter Chapter 31|14 pages

Redesigns and Examples

chapter Chapter 32|2 pages

Conclusion