Hi there,
I manage a number of Adwords accounts for a large online travel agency. And I've built a fairly rudimentary dashboard for each market, 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 markets and/or timelines.
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/open?id=0BzOf1rWqZkz2M0xGemZpZHpva0U
Thanks in advance!
I manage a number of Adwords accounts for a large online travel agency. And I've built a fairly rudimentary dashboard for each market, 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 markets and/or timelines.
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/open?id=0BzOf1rWqZkz2M0xGemZpZHpva0U
Thanks in advance!