Introduction. Part I: Moving from Spreadsheets to Dashboards. Chapter 1: Introducing Dashboards. Chapter 2: Developing Your Data Model. Part II: Excel Chart Basics. Chapter 3: Introducing Excel Charts. Chapter 4: Understanding Chart Types. Chapter 5: Working with Chart Series. Chapter 6: Formatting and Customizing Charts. Part III: Going Beyond Tables and Charts. Chapter 7: Using Pivot Tables. Chapter 8: Using Pivot Charts. Chapter 9: Using Excel Sparklines. Chapter 10: Chartless Visualization Techniques. Part IV: Creating Advanced Dashboard Components. Chapter 11: Components that Show Trending. Chapter 12: Components that Group Data. Chapter 13: Components that Show Performance against a Target. Part V: Automating Your Dashboards and Reports. Chapter 14: Macro–Charged Reporting. Chapter 15: Adding Interactive Controls to Your Dashboard. Part VI: Working with the Outside World. Chapter 16: Importing Microsoft Access Data into Excel. Chapter 17: Sharing Your Work with the Outside World. Index.