Project Portfolio Dashboard Excel Template
This dashboard display follows box layout with simple colors, easy charts, picture links & lots of conditional formatting goodness.
Fetching a relevant project plan from all plans:
This was one of the trickiest things. Since each plan has its own table, getting selected project’s table is necessary to drive all calculations. This is how it's done.
Define lstPlans as a list of all tables =plan1,plan2…,plan10
Use INDEX to fetch one of the tables from this array like this =INDEX(lstPlans, activity-row-number, column-number, plan-number)
EmoticonEmoticon