Data Visualization in Excel

Contents
To help guide you through the tutorials, each chapter is roughly classified by difficulty depending on the number of steps, how many different chart types are used, and how much data preparation is needed.

■ Beginner ■■ Intermediate ■■■ Advanced

Acknowledgements

PART ONE: SETTING THE STAGE

1. Introduction

2. How to Use This Book

3. The Philosophy of Data Visualization in Excel

4. Introduction to Making Graphs in Excel

5. Fundamental Formulas Used in Building Your Graphs

6. Building a Custom Color Palette in Excel

PART TWO: MAKING GRAPHS IN EXCEL

7. Sparklines ■

8. Heatmap ■

9. Stripe Chart ■

10. Waffle Chart ■

11. Gantt Chart ■

12. Comparing Values with Two Graph Types ■■

13. Broken Stacked Bar Chart ■■

14. Diverging Bar Chart ■■

15. Block Shading (Same Frequency) ■

16. Block Shading (Different Frequencies) ■■

17. Mark an Event with a Line ■■

18. Dot Plot ■■

19. Slope Chart ■■

20. Overlaid Gridlines ■■

21. Lollipop Chart ■■

22. Bullet Chart ■■■

23. Tile Grid Map ■■■

24. Histogram ■■■

25. Marimekko Chart ■■■

26. Cycle Plot ■■■

27. Strip Chart ■■

28. Raincloud Plot ■■■

29. Making Better Tables

PART THREE: MOVING VISUALS OUT OF EXCEL

30. Exporting Graphs from Excel

31. Redesigns and Examples

32. Conclusion

Appendix 1. Color Tools

Appendix 2. Data Visualization Tools

Appendix 3. Additional Excel Resources

Appendix 4. Quick Instructions List

References

Index