Hi there,

I manage a number of Adwords accounts for a large online travel agency. I've already built a fairly standard dashboard for each market seperately, now I would like to bring all of those markets together in one dashboard with dynamic data that can be shifted between market and timeline.

Another feature I would like to build in is the ability to compare data from different time periods. Week vs Week, Month vs Month, Year vs Year

So step one for me will be getting a better feel of charts with dynamic data from multiple sheets. How do I create a chart where I have a dropdown box to select the data series from different sheets, all the columns are the same, only the data differs.

From here I will keep adding and building on to it and see where I go.

Here is a sample set of data I would like to use...
https://docs.google.com/spreadsheet/...2VTLUFQNGJFTEE

Thanks in advance!