Excel Dashboards and Reports

Introduction 1

Part I: Moving from Spreadsheets to Dashboards

Chapter 1: Introducing Dashboards 11

Chapter 2: Developing Your Data Model 29

Part II: Excel Chart Basics

Chapter 3: Introducing Excel Charts 55

Chapter 4: Understanding Chart Types 75

Chapter 5: Working with Chart Series 109

Chapter 6: Formatting and Customizing Charts 139

Part III: Going Beyond Tables and Charts

Chapter 7: Using Pivot Tables 187

Chapter 8: Using Pivot Charts 221

Chapter 9: Using Excel Sparklines 245

Chapter 10: Chartless Visualization Techniques 259

Part IV: Creating Advanced Dashboard Components

Chapter 11: Components that Show Trending 279

Chapter 12: Components that Group Data 305

Chapter 13: Components that Show Performance against a Target 323

Part V: Automating Your Dashboards and Reports

Chapter 14: Macro-Charged Reporting 339

Chapter 15: Adding Interactive Controls to Your Dashboard 355

Part VI: Working with the Outside World

Chapter 16: Importing Microsoft Access Data into Excel 379

Chapter 17: Sharing Your Work with the Outside World 395

Index 411