Andy_Morland
New Member
- Joined
- Jan 27, 2015
- Messages
- 5
Hi All
I am trying to create a dashboard at present using a large set of raw data.
I have created pivot charts using the data to represent it for varying metrics.
However, I now need to have the 3 sets of raw data populate automatically under each graph. I had planned to do this using pivot tables, however the issue I have is that as data changes month on month, when the tables are refreshed, they will overalp each other. What I really want is for them to refresh, leave a spare between them at the end, and then the new pivot begins in the next row.
Does anyone have any suggestions which may help? I fear I may be missing something very basic.
Thanks
Andy
I am trying to create a dashboard at present using a large set of raw data.
I have created pivot charts using the data to represent it for varying metrics.
However, I now need to have the 3 sets of raw data populate automatically under each graph. I had planned to do this using pivot tables, however the issue I have is that as data changes month on month, when the tables are refreshed, they will overalp each other. What I really want is for them to refresh, leave a spare between them at the end, and then the new pivot begins in the next row.
Does anyone have any suggestions which may help? I fear I may be missing something very basic.
Thanks
Andy