How can I consolidate dashboards from multiple project plan workbooks

[andrejwu]

I have your Project Plan templates. I'd like to create a master workbook that has automatically updating the Project Status Dashboard tabs from multiple workbooks.


I've tried and while I can get the data across - I can't get the milestone, burndown or gantt charts to come across.


Help!

 

[Hui]

Andrewjwu


Firstly, welcome to the Chandoo.org Forums


You cannot link directly to Charts, Milestones or Burndown on other sheets/workbooks.

The only way to do this is to link to the data and recreate the bits (Charts, Milestones and Burndowns) in the Summary Workbook

 

[andrejwu]

Hui - Thanks for the counsel