Dashboards for Excel

CHAPTER 13

Creating an Interactive Gantt Chart Dashboard

In the next three chapters, I’ll discuss how to create a Gantt chart dashboard. In this chapter, I’ll take you on a tour of the dashboard so you can become familiar with its mechanisms from a high level. As is the case with most of this book, you’ll reverse engineer what’s already been created. This allows you to divide the underlying mechanics into different sections. Moreover, it should drive home a salient point about reusable components: your work can be broken in disparate pieces. What you build is the sum of its parts, and those parts can exist independently on their own or together ...