Pivot Table
I have data (see attached) that I update every week. I have to track 20 regions of data and 5 different discrepancies.
I want to create a dynamic pivot table that I can update every week with the new data. Then I have to create charts as well.
The problem I'm having is that I don't just chart the entire 20 regions. I'll need a total of 25 charts. First chart would be region 2, 4, 10, 12 & 20 for discrepancy 1, then region 2, 4, 10, 12 & 20 for discrepancy 2 and so on to discrepancy 5. Then I choose 5 more regions, (example) 1, 5, 9, 17 & 19 for discrepancy 1 and so on to discrepancy 5. What is the best way to set this up?
Any help would be greatly appreciated
Thank you in advance
|