Data Visualization in Excel : A Guide for Beginners, Intermediates, and Wonks (Hardcover)

Part 1: 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 2: 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 Bars. 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. 22. Bullet Chart. 23. Tile Grid Map. 24. Histogra. 25. Marimekko. 26. Cycle Plo. 27. Strip Chart. 28. Raincloud Plot. 29. Making Better Tables. Part 3. Moving Visuals Out of Excel. 30. Exporting Graphs from Excel. 31. Redesigns and Examples. 32. Conclusion.