#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Ooops! It's looks as though I didn't attach the data. Any help would be greatly appreciated.
|
#3
|
|||
|
|||
Something like this?
|
#4
|
|||
|
|||
Thank you so much Kimberly! This is a great idea!
How do I make it dynamic so I can add data to the chart each week? Thank you again for your help. Have a great weekend, Karen |
#5
|
|||
|
|||
Convert the data range into a table. To do so:
|
#6
|
|||
|
|||
Thank You Kimberly
I'm so sorry I haven't been able to thank you for all your help Kimberly. You have been so helpful and I appreciate your time. I have one more question, I just have to take the time to post it. Thank you again! Have a great day!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pivot table design 2 | dmonroe | Excel | 2 | 11-15-2010 09:15 AM |
Using subtotals in Pivot table formulas | ninfanger | Excel | 3 | 10-23-2010 12:29 AM |
Pivot Table Refresh | tpcervelo | Excel | 0 | 09-14-2010 06:54 AM |
pivot table source data | hannu | Excel | 0 | 07-03-2010 04:54 AM |
Pivot table problem | swindon | Excel | 5 | 05-25-2010 02:05 PM |