Pivot Table

[holo man]

I desire to make a dynamic pivot-table that I can update each week with the fresh data. Then I must create charts also.

The problem I am facing is that I do not just graph the entire 20-regions. I will need a total of 25-charts. First-chart would be area 2, 4, 10, 12 & 20 for inconsistency 1, then area 2, 4, 10, 12 & 20 for inconsistency 2 and so on to divergence 5. Then I select 5 more region, (for example) 1, 5, 9, 17 & 19 for divergence 1 and so on to divergence 5. What is the best approach to set-up this?

Any help?
Thank you in advance

[Ken Puls]

The best approach is to set up a data list, build a Pivot Table off that, and then probably to build PivotCharts to display the data the way you want. Hard to guide further without seeing any data though...