I am trying to create a dashboard that will pull in charts from multiple workbooks. This is a dashboard where-in I need to track project performance and have 3 established workbooks that I currently report from. I want to compile top-level pertinent project indicators from these different workbooks onto a single dashboard.
The Dashboard Course from myonlinetraininghub shows the creation of a dashboard within the same workbook as the raw data and analysis. I need a separate dashboard file that reaches out to multiple workbooks. Is this possible? If so, how?
Hi Lori,
Were you hoping to analyse the data from these different workbooks in a single PivotTable or even a single chart? In other words, would you need to combine the data before analysing it or will it be presented in separate charts but all within the one dashboard?
Mynda
P.S. I moved this thread to the Dashboard Course members forum.
